Here's the use case: I'd like to have a filter that is ultimately selecting for sys_user records (basically this is just a variant of an ASSIGNED TO filter). However, I want to just return the records that are the members of a group. That way, as people enter and exit the group, they are automatically added to and removed from the options presented by the filter, and it's less work for me (score!).
I've found two ways to ALMOST do this:
- Create a multi-select REFERENCE filter, and just go crazy with adding conditions to pare 195k users down to 8. This gives me multi-select goodness, but it means that anytime someone adds or leaves the group, I have to manually come and update the filter.
- Create a CASCADING filter using sys_user_grmember as my table and user as my field. Then I just fiddle with the target tables until I get my desired assigned_to fields accounted for. This gives me that sweet dynamic updating that I crave...but my end users only get to pick one user instead of an arbitrary combination of them.
Is there a way to do both? I was sure that doing a multi-select REFERENCE filter and just aiming at sys_user_grmember instead of sys_user would do the trick, but it spits back an error that "reference field 'assigned to' is not of type 'sys_user_grmember." (Figured I'd use a color similar to the error just so we can all be triggered together).
I found two previous attempts at this on Community:
How Do I Report Stories for Chosen Members of an Assignment Group?
Assigned to Interactive Filter that only shows Members of a specific group
The first one just wound up using a CASCADING filter; the second one went crazier with scripts than I'm comfortable with. But I'm open to ideas. Does anyone know a cool trick for this, or do I just tell my stakeholder that they can only have single-select. 😉
