To set precedence rules for combined statement conditions

By default, multiple conditions created through the Advanced Statement Builder are combined using the logical AND operator, employed to include only those results that are generated in all conditions. Through the Join Builder function, the preferred operator can be adjusted between adjacent conditions - AND / OR -  and also parentheses can be inserted to denote required modifications to the order of these operations - referred to as precedence rules:

The procedure to set precedence rules for combined statement conditions is as follows:

1. Prerequisite procedural steps are covered separately in the topic Understanding the advanced statement builder. Refer to these before proceeding to step 2.
2. With multiple conditions linked to the overall statement algorithm displayed in the Conditions summary table, apply the 'drag and drop' technique within the Join Builder function to re-position one or more conditions. Each condition is identified by a unique integer value, incremented every time a new condition is added to the overall statement algorithm, and appears as a block icon () 1.
3. Click on the operator between the conditions to control the join behaviour: AND or OR. By default, AND is displayed.
4. Click on the parentheses icon () to control the order in which the conditions will be applied. The equation is encapsulated by square brackets ( and ).
5. Apply the same 'drag and drop' technique to re-position the brackets within the equation and control the sequence in which the condition results are derived.
6. Click on Save 2.

Note

1 In the event that a condition is removed from the overall statement algorithm, the unique integer value will be automatically re-assigned to subsequently added conditions, as appropriate.

2 Parentheses may be removed from the equation simply by clicking on the cross-box located in the top right-hand corner of the bracket icon.

See related topics...

Understanding the advanced statement builder