Show TOC

Set Filter Condition Postfix FormatLocate this document in the navigation structure

Postfix format for filter conditions allows us to combine conditions arbitrarily with logical operators AND, OR, and NOT. Postfix means that operands are followed by an operator.

In our case, two conditions are combined with the logical operator AND or OR if the conditions are followed by that operator.

A condition is negated if it is followed by the operator NOT. The resulting conditions can be combined by the operators in the same manner.

Examples

Condition as a string in infix format expressed as a filter condition:

  • Condition: price < 100 and currency_code = 'EUR'
    it_filter_condition = value #(
        ( element = 'PRICE'         operator = 'LT'  low = '100' )
        ( element = 'CURRENCY_CODE' operator = 'EQ'  low = 'EUR' )
        (                           operator = 'AND' ) )
  • Condition: category = 'Notebooks' or category = 'Tablets'
    it_filter_condition = value #(
        ( element = 'CATEGORY'      operator = 'EQ'  low = 'Notebooks' )
        ( element = 'CATEGORY'      operator = 'EQ'  low = 'Tablets' )
        (                           operator = 'OR' ) )
  • Condition: price < 100 and currency_code = 'EUR' and (category = 'Notebooks' or category = 'Tablets')
    it_filter_condition = value #(
        ( element = 'PRICE'         operator = 'LT'  low = '100' )
        ( element = 'CURRENCY_CODE' operator = 'EQ'  low = 'EUR' )
        (                           operator = 'AND' )
        ( element = 'CATEGORY'      operator = 'EQ'  low = 'Notebooks' )
        ( element = 'CATEGORY'      operator = 'EQ'  low = 'Tablets' )
        (                           operator = 'OR' )
        (                           operator = 'AND' ) )