Skip to main content
July 5, 2022
Question

A question About queryFilter's function

  • July 5, 2022
  • 5 replies
  • 0 views

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.

a!queryFilter(

field:"c1",

operator:"in",

value:ri!user

)

data:

Dictionary

 c1 List of User of Group - 2 item

    user1(User)

    user2(User)

c2 ...

c3 ...

I expected when I input one user, if the user in the list, data is able to filter. 

5 replies

stefanhelzle0001
Brainy
July 5, 2022

What do you want to achieve? Show tasks of specific processes to a user?

harshitb6843
July 5, 2022

You can change the datatype of the assignee column to text and concat the values using a delimiter like a semi colon (;)


Here, ri!assignee_txt is a list of users or groups. 

stefanhelzle0001
Brainy
July 5, 2022

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.

harshitb6843
July 5, 2022

There is a work arround. In the assignee, you pass the userContext and all the groups of which the user is a part.