Question
Task Report with multiple assignees
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?
