Skip to main content
shalinim0003
shalinim0003
October 11, 2022
Question

Query Filter

  • October 11, 2022
  • 4 replies
  • 0 views

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?

    4 replies

    harshitb6843
    harshitb6843
    October 11, 2022

    Create a logical expression inside another logical expressions. 

    harshitb6843
    harshitb6843
    October 11, 2022

    Like this

    a!queryLogicalExpression(
  operator: "AND",
  filters: {
    /*Your filters with AND operator*/
    
  },
  logicalExpressions: a!queryLogicalExpression(
    operator: "OR",
    filters: {
      /*Your filters with OR operator*/
      
    }
  )
)

      shalinim0003
      shalinim0003Author
      October 11, 2022

      Its working thank you

      U
      ujjwalr0002
      October 11, 2022

      Here is something well explained in Appian documentation https://docs.appian.com/suite/help/22.3/Query_Recipes.html#querying-on-nested-conditions

      Terms & ConditionsAccessibility statement