The Or All operator is a custom operator created for the convenience of connecting a series of conditional expressions together with SQL Or operators. When dragging an Or All operator into a variable, the following tree element is created.
Conditional expressions should be moved into the Expressions folder beneath the Or All node so that they will be connected with Or 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 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”) OR (“C3” = “C4”)) OR (“C5” = “C6”)
whereas expressions built in later releases produce SQL like the following.
(“C1” = “C2”) OR (“C3” = “C4”) OR (“C5” = “C6”)
Older expressions with extra parentheses can be changed by re-entering them.
There are no special properties for the Or All operator.