<< Click to Display Table of Contents >> ETL > 12.6 > Implementation Guide > Tutorial and implementation guide > Steps > Filtering  Logical operators

Both AND and OR are possible, with a Mongo-inspired syntax. To define AND condition, use $and as the name, and array of sub-conditions as a value:

"conditions": 

[

    {

        "$and": 

        [

            {

                "Name": "John"

            },                        

            {

                "Value": "abc"

            }

        ]

    }

]

 

The equivalent operator for OR operation is $or. Nesting is also possible to build some complex scenarios.