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
  • 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 
                                      )
                                     
                                    )
                             }
                          )
                      )
                 },

Reply
  • 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 
                                      )
                                     
                                    )
                             }
                          )
                      )
                 },

Children