Task Report with multiple assignees

Question

Hello, 
 
 I have create a Process Task Report having as Report Context multiple processes. 
 I used the a!queryProcessAnalytics to retrieve the data, the only problem is if in column "Assigned to" (tp!assignees) if I have multiple assignments (Group1 and Group2 or Group1 and User1) I won't be able to retrieve the tasks based on the loggedinuser and the groups that is member of (having only one assignee it works.) 
 
 logicalexpressions: a!queryLogicalExpression(
 operator: "OR",
 filters: a!localVariables(
 local!groups: getgroupsformemberuser(user: ri!user),
 {
 a!forEach(
 items: local!groups,
 expression: a!queryFilter(
 field: "c1",
 operator: "in",
 value: fv!item,
 applywhen: not(rule!APN_isBlank(ri!user))
 )
 ),
 a!queryFilter(
 field: "c1",
 operator: "in",
 value: ri!user,
 applywhen: not(rule!APN_isBlank(ri!user))
 )
 }
 )
 ) 
 Any ideas how it should be handled or another solution that should be applied?

Harshit Bumb (Appyzie) · Accepted Answer

Hi there, 
 Try using this. logicalExpressions: a!queryLogicalExpression(
 operator: "OR",
 filters: a!forEach(
 items: ri!assignee_txt,
 expression: 
 a!queryFilter(
 field: "c4",
 operator: "includes",
 value: concat(tostring(fv!item),";"),
 applyWhen: not(rule!VP_utils_checkIsNull(fv!item))
 ),
 )
 ) 
 ri!assignee_txt is List of User or Group