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