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
Hi,
Please add extra-logical expression for Assignee
logicalExpressions:{ if( rule!Utils_CheckIsNull(ri!Assignee),{}, a!queryLogicalExpression( operator:"OR", filters:{ apply( a!queryFilter( field:"c1", operator:"includes", value:_ ), touniformstring(getusergroup(ri!Assignee )) ), if( rule!Utils_CheckIsNull(ri!Assignee), {}, a!queryFilter( field:"c1", operator:"=", value:ri!Assignee ) ) } ) ) },