Task Report with multiple assignees

Certified Senior Developer

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?

  Discussion posts and replies are publicly visible

Parents Reply Children