How to query "Assigned to" tasks from a Process Report?

Hi Community,

I am trying to query form Active Task assigned to users in my application from a Process report. I was not able to create a filter for the same to check assigned tasks for selected users.

= a!queryProcessAnalytics(
  report: cons!I_MY_OPEN_TASKS,
  query: a!query(
    logicalExpression: a!queryLogicalExpression(
      operator: "AND",
      filters: {
        a!queryFilter(
          field: "c0",
          operator: "includes",
          value: ri!taskName
        ),
        a!queryFilter(
          field: "c3",
          operator: "between",
          value: {
            ri!assignedOnFrom,
            a!defaultValue(ri!assignedOnTo, today())
          }
        ),
        a!queryFilter(
          field: "c4",
          operator: "in",
          value: ri!assignedTo /*issue at this filter*/
        )
      },
      ignorefilterswithemptyvalues: true()
    ),
    pagingInfo: a!defaultValue(
      ri!pagingInfo,
      a!pagingInfo(
        startIndex: 1,
        batchSize: - 1,
        sort: a!sortInfo(field: "c3", ascending: false)
      )
    )
  ),
  
)
  

In the above code "c4" is "Assigned to" column in my report which contains single user/multiple users/ user groups.
I have attached the rule input screenshot as well.


If I enter the email/username of the user I am able to see the tasks, but it won't show the tasks which have multiple users assigned.
Please suggest how can we filter the tasks by "assigned to" column.
  

  Discussion posts and replies are publicly visible

Parents Reply Children
No Data