here for the fist two filters i want to use it as "AND" operator filters and last two I want use as "OR" operator. Is there any way to do it inside the a!queryrecordtype function?
Discussion posts and replies are publicly visible
Create a logical expression inside another logical expressions.
Like this
a!queryLogicalExpression( operator: "AND", filters: { /*Your filters with AND operator*/ }, logicalExpressions: a!queryLogicalExpression( operator: "OR", filters: { /*Your filters with OR operator*/ } ) )
Here is something well explained in Appian documentation https://docs.appian.com/suite/help/22.3/Query_Recipes.html#querying-on-nested-conditions
Its working thank you