Logical elements

When you use a single condition element in a filter, you are limited to simple comparisons. Logical elements allow two elements to be combined for more complex comparisons.

You can use these operators to build filters with multiple conditions. The AND and OR operators can be used as leading or trailing operators when combining conditions. The negate operator (NOT) can only have one parent and one child. The negate operator inverts the result of the SQL that follows it. Although a negate element has only one child in the tree, it can generally be manipulated as a logical element.