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:
a!queryFilter(field: "c4",operator: "in",value: "ABC@com")
Thanks in advance.
Discussion posts and replies are publicly visible
In your report column definition you can use the function task_assignee_owner() instead of the if(). You find this function in category task metrics.