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

Mike Schmitt · Answer

something like "tostring(joinarray(tp!assignees, ","))", or maybe even as simple as "tostring(tp!assignees)", or similar - the report (invisibly and on the back end) wants to treat "assignees" like an array, and you have to force it to not render that way. It requires some real hammering-into-shape before it works with basic filtering, annoyingly.

Task Report with multiple assignees

Top Replies