Hello,
I have an active task report for which i need to create a user/group filter. I have a column in the report for assignee which can have multiple users or group values separated by ; (ex: ABC; DEF; GHI) so now if i in the user picker and enter ABC i should get all the tasks where the assignee column has ABC.
I have tried multiple methods but none is giving me the expected results. Please help!
Thanks
Discussion posts and replies are publicly visible
Can you provide some more details on what objects you are using or paste some sample code (e.g., the SAIL for your filter)? Unfortunately "Task" is usually an overloaded term so we wouldn't want to point you in the wrong direction.
Are you passing the user filter to a database query expression rule, so that your challenge is being able to use the database to search for a part of a text string (the individual user name) within a larger text string (semi colon delimited list of many users/groups) stored in the db?