Hello,
Hopefully this is an easy one, we've found a workaround but its not optimal and sets us up for future failure and figured I'd use this as a learning opportunity.
I have the change_request table that we're creating a report for. We're looking to filter the table to only lists users that belong to a certain group (lets call it Pie Eaters). The group isn't an assigned group/division/department or anything like that but it does exist in the Group table.
Is there a way to call that list into the conditions form? I had asked in the Slack forum and someone suggested copying the query of the group which I did but don't know where to place it on here.
I also may just be misinterpreting what they meant. I'm not too familiar with building querys so any insight on that would be helpful as well. 😅
Hello @STRNow
Yes, you can achieve this. By calling the script include in conditions.
Try something like below screenshot:
Assuming Requested by should be a part of "Pie Eaters" group so for this you can query the group members in script include method and call it in your condition.
Make sure client callable is checked in script include.
Let me know if you need any help.
(=tested)
