Number

Equals

• Definition: Checks if the price or monetary value is exactly equal to a specific amount.

• Use Case: Useful for exact price matches.

  • Example: Filter products priced exactly at $100.

    • price Equals 100 → Matches products priced at $100.

NotEquals

• Definition: Checks if the price or monetary value is not equal to a specific amount.

• Use Case: Excludes specific price points.

  • Example: Exclude products priced at $0 (free items).

    • price NotEquals 0 → Excludes products priced at $0.

EqualsOneOf ("In" Filter)

• Definition: Checks if the price matches one of the values in a predefined list.

• Use Case: Useful for matching against multiple specific price points.

  • Example: Filter products priced at $50, $100, or $150.

    • price EqualsOneOf [50, 100, 150] → Matches products priced at $50, $100, or $150.

EqualsNoneOf ("NotIn" Filter)

• Definition: Checks if the price matches none of the values in a predefined list.

• Use Case: Excludes multiple specific price points.

  • Example: Exclude products priced at $0, $10, or $20.

    • price EqualsNoneOf [0, 10, 20] → Excludes products priced at $0, $10, or $20.

GreaterThan

• Definition: Checks if the price is greater than a specific amount.

• Use Case: Useful for filtering high-priced items or transactions.

  • Example: Filter products priced above $500.

    • price GreaterThan 500 → Matches products priced at $501 or more.

GreaterThanOrEquals

• Definition: Checks if the price is greater than or equal to a specific amount.

• Use Case: Includes the threshold value in the filter.

  • Example: Filter products priced at $100 or more.

    • price GreaterThanOrEquals 100 → Matches products priced at $100 or more.

LessThan

• Definition: Checks if the price is less than a specific amount.

• Use Case: Useful for filtering low-priced items or transactions.

  • Example: Filter products priced below $50.

    • price LessThan 50 → Matches products priced at $49 or less.

LessThanOrEquals

• Definition: Checks if the price is less than or equal to a specific amount.

• Use Case: Includes the upper limit in the filter.

  • Example: Filter products priced at $50 or less.

    • price LessThanOrEquals 50 → Matches products priced at $50 or less.

IsEmpty

• Definition: Checks if the price field is empty (i.e., no value is present).

• Use Case: Useful for identifying missing or incomplete pricing data.

  • Example: Filter products with no price assigned.

    • price IsEmpty → Matches products with no price value.

IsNotEmpty

• Definition: Checks if the price field is not empty (i.e., a value is present).

• Use Case: Useful for ensuring all products have a price assigned.

  • Example: Filter products with a price value.

    • price IsNotEmpty → Matches products with a price.