Searching by type and then by Role
Support Ticket
+issues
I am trying to create a search card that lists all of the cards of one cardtype, but only those that are associated with members of a certain role. I can't seem to come up with the right WQL string though. Please advise. Thanks!
Can't help without knowing pretty specifically what you mean by "associated with"...
Sorry about that. More specifically, I am trying to create a search card that lists all of the cards created using a form I setup as a cardtype called "Curriculum Video." But I want to further limit which cards get listed on that search card based on the Role that the particular person who is logged in has assigned to them. To back up, though, what I'm trying to do overall here is setup a way for my teachers to create a curriculum entry using that cardtype form I created, allow them to specify which school program that entry is for using a pointer card as part of the form (we have a dozen or so programs at different schools), and then create a sub menu for students who log in that belong to that program that shows them only the Curriculum Video entries that are for their school program. Is there any way to do this? I can provide further details or login info if you need. Thanks!
I found this syntax works for what I want to do, but it only works when I'm logged in as an administrator. I want to make it work when users assigned to other Roles are logged in.
{"plus":["Programs",{"refer_to":"HRB - Violin Program"}], "type":"Curriculum Video"}
See: http://musickidswagn.252.cldstr.com/wagn/HRB_Curriculum_Videos
I'm not sure I fully understand what you're trying to do, but great that you figured it out! To make it work for other Roles it sounds like you'll need to change permissions to make the relevant cards viewable by Anyone Signed In.
WQL searches automatically have permissions built in. So if the videos in question are restricted to be viewable only by the roles in question, then you shouldn't need any additional WQL, right?
Actually, that's my problem. I couldn't figure out a way to restrict the video card entries by role through the form I created to submit the content. I want teachers to be able to select through the form which groups of users can see their submission, so I used a pointer card called +Programs on the form and then used the syntax above on a search card to display those cards. If there is a better way to do this let me know, because doing it this way still allows people to search and find cards that we don't need/want them to see.
There's always a way, but it often involves coding a custom module. This question is a little too involved to answer quickly – we'd have to get in and figure out your card structure – but it's the kind of thing that would be covered with a support package. Let me know if you're interested.
That's good news. How do your support packages work and what do they cost? I didn't know you guys offered something like that. You can email me the info if that's easier. Thanks!