Color guide
- Blue border: root group (outermost)
- Green border: first level nested group
- Yellow border: second level nested group
How to build complex conditions
Example 1: STU.GR = 12
- Root group starts empty (blue border)
- Click Add Condition
- Select: STU table, GR field, = operator, value 12
Example 2: STU.GR = 12 AND STU.GN = M
- Root group logic (blue border): AND (default)
- Click Add Condition and enter Condition 1: STU.GR = 12
- Click Add Condition and enter Condition 2: STU.GN = M
Example 3: (STU.SC = 994 AND STU.GR = 11) OR STU.U1 = B
- Change root group (blue border) logic to OR
- Click Add Group to create a nested AND group (green border)
- In the nested group, fill the default condition: STU.SC = 994
- In the nested group, click Add Condition and enter STU.GR = 11
- Back in the root group (blue border), click Add Condition and enter STU.U1 = B
Example 4: STU.SC = 994 AND (STU.GR = 11 OR STU.GR = 12)
- Root group logic (blue border): AND (default)
- Click Add Condition and enter STU.SC = 994
- Click Add Group to create a nested group (green border)
- Change the nested group logic to OR
- In the nested group, fill the default condition: STU.GR = 11
- In the nested group, click Add Condition and enter STU.GR = 12
Example 5: (VIC.TY = 01 OR VIC.TY = 02) AND (VIC.RT = AT OR VIC.RT = AG)
- Root group logic (blue border): AND (default)
- Click Add Group to create Group 1 (green border)
- Change Group 1 logic to OR
- In Group 1, fill the default condition: VIC.TY = 01
- In Group 1, click Add Condition and enter VIC.TY = 02
- Back in the root group (blue border), click Add Group to create Group 2 (green border)
- Change Group 2 logic to OR
- In Group 2, fill the default condition: VIC.RT = AT
- In Group 2, click Add Condition and enter VIC.RT = AG
Example 6: DSP.DS = EXP AND ADS.ISI = N (multiple tables)
- Root group logic (blue border): AND (default)
- Click Add Condition and select the DSP table, DS field, = operator, value EXP
- Click Add Condition and select the ADS table, ISI field, = operator, value N