I need input a user or group type value, and filtering data.
but a question emerged, if field of table is a list of user of group type, "in" of operator is not working.
c1 List of User of Group - 2 item
I expected when I input one user, if the user in the list, data is able to filter.
Discussion posts and replies are publicly visible
You can change the datatype of the assignee column to text and concat the values using a delimiter like a semi colon (;)Then inside the rule to query the data, you can use a logical expression to filter the data. Here, ri!assignee_txt is a list of users or groups.
Which does not work if you assign to groups and want to display by user. I recommend to use a report based on the user context and filter by process models. This is way easier.
There is a work arround. In the assignee, you pass the userContext and all the groups of which the user is a part.
IMHO the approach here needs to be separated by use case - if we're intending to have a report of all user tasks and then filter by user or group assignment, then the viewer will need to actually enter the individual user(s) or group(s) they want to filter by. If we're intending to show a report of all of an individual user's tasks on the other hand, including the ones to which they're assigned by group membership, then we should use the other style of report and pass in that username into the contextUsers value of the report.
Yes it's possible in special cases to do extreme workarounds to squeeze more out of a single query, but to me it gets too complicated too quickly to try to have a single report and force it to do everything.
© 2022 Appian. All rights reserved.