Skip to main content
shalinim0003
Known Participant
Oct 11, 2022 8:04 AM UTC
Question

Query Filter

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
    Brainy
    Oct 11, 2022 8:05 AM UTC

    Create a logical expression inside another logical expressions. 

    harshitb6843
    Brainy
    Oct 11, 2022 8:08 AM UTC

    Like this

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

    shalinim0003
    Known Participant
    Oct 11, 2022 8:15 AM UTC

    Its working thank you

    Participating Frequently
    Oct 11, 2022 8:13 AM UTC