Skip to main content
kavyam0002
kavyam0002
December 7, 2021
Solved

How can apply filter for multiple values

  • December 7, 2021
  • 2 replies
  • 0 views

            a!queryFilter(
              field: "compliantFlag_txt",
              operator: "=",
              value: "yes"
            ),
            a!queryFilter(
              field: "compliantFlag_txt",
              operator: "=",
              value: "No"
            ),
            a!queryFilter(
              field: "proposedAction_txt",
              operator: "=",
              value:"Released Proposed"  
            ),
            a!queryFilter(
              field: "proposedAction_txt",
              operator: "=",
              value:"Delete Proposed"  
            )

how can i write these 4 filters into 2 filters... 

    Best answer by hrishikeshd997

    a!queryFilter(
  field: "compliantFlag_txt",
  operator: "in",
  value: {"yes", "No"}
),
a!queryFilter(
  field: "proposedAction_txt",
  operator: "in",
  value: {"Released Proposed", "Delete Proposed"}
)

    Additionally I would use constants for filter values instead of hard coding them.

    2 replies

    mikes0011
    mikes0011
    Brainy
    December 7, 2021

    Can you clarify what your desired eventual behavior will actually behave like?  What is the context surrounding these filters?  Any additional detail you can provide beyond a 1-phrase subject line will help if you're after helpful answers here.

    The Expression Guru
    H
    hrishikeshd997Answer
    December 7, 2021

    a!queryFilter(
  field: "compliantFlag_txt",
  operator: "in",
  value: {"yes", "No"}
),
a!queryFilter(
  field: "proposedAction_txt",
  operator: "in",
  value: {"Released Proposed", "Delete Proposed"}
)

    Additionally I would use constants for filter values instead of hard coding them.

      Terms & ConditionsAccessibility statement