The And All operator is a custom operator created for the convenience of connecting a series of conditional expressions together with SQL And operators. When dragging an And All operator into a variable, the following tree element is created.
Conditional expressions should be moved into the Expressions folder beneath the And All node so that they will be connected with And operators. For example, if the expressions “C1 = C2”, “C3 = C4” and “C5 = C6” were moved into the Expressions folder as three Equal nodes, the resulting SQL would be something like the second expression below. Of course, the column names such as “C1” would be qualified with table aliases, and the expression by itself is not valid as a variable, though it would be as a dimension.
Expressions built prior to TWM 5.3.5 produce SQL like the following:
((“C1” = “C2”) AND (“C3” = “C4”)) AND (“C5” = “C6”)
whereas expressions built in later releases produce SQL like the following:
(“C1” = “C2”) AND (“C3” = “C4”) AND (“C5” = “C6”)
Older expressions with extra parentheses can be changed by re-entering them.
There are no special properties for the And All operator.