Multiple Filtering

Hi my Appian mates,

 

here is my situation:

1. I have a task report that the AssignedUserGroup is showing an array of group Id [i.e. in Number (Integer)]

2. In my report UI, there is a Custom Filter for Assigned User group which allow multiple values

 

 

How should i configure my Task report so that I can retrieve the above result (ie. that any of the rows' Assigned User Group fulfill any of the filter value would be display in the table)

 

with(
local!filteredData: a!queryProcessAnalytics(
report: cons!rpt,
contextProcessModels: cons!pm,
query: a!query(
pagingInfo: a!pagingInfo(startIndex: 1, batchSize: -1),
logicalExpression: a!queryLogicalExpression(
operator: "AND",
filters: {

/*Assigned User Group*/
a!queryFilter(
field:"c1",
operator:"???",
value:???
)


}
)
)
),
local!filteredData.data
)

  Discussion posts and replies are publicly visible

Parents Reply Children
No Data