Task Report Filter Issue

Hi All,

We have Task Report with one of column as "Assigned To" data field which is of type Normal Text and definition : if(isnull(tp!owner),tp!assignees,tp!owner)

While querying report using a!queryProcessAnalytics(), we have a set of query filters, one of the filter is "Assigned To".

All the tasks are assigned to users only.

Requirement:

Want to filter data by passing multiple values in 'Assigned To' queryfilter(), but when we pass multiple values, it does not return any result.

It returns totalCount as 0.

/*Assigned To*/

a!queryFilter(
field: "c4",
operator: "in",
value: {"ABC@com","XVZ@com}
)

Whereas It is working for single value filter, returns correct totalcount:

/*Assigned To*/

a!queryFilter(
field: "c4",
operator: "in",
value: "ABC@com"
)

Thanks in advance.

  Discussion posts and replies are publicly visible

Parents Reply Children
No Data