Working with multiple selection criteria


The example given in Create a Set via Free Definition assigns two criteria to one Set to detect all SQL views ending with "_company". This results in the following Set:

Note that the two criteria are located within the All objects matching text box. This ensures that an AND match is created (circled in red) and all criteria in that text box must be met.

If, however you want to assign all SQL views OR all objects (of any type, not just SQL tables) ending with "_company", you need to define the layer as follows into separate criteria using the OR condition:

You can achieve this using drag and drop - i.e. drag the "name Match _company" text down and release.

Note that you can also combine multiple AND and OR clauses to achieve the rule you need:


CAST Website