Introduction to Work with Method multiple filters

When more than one filter (single or combined) is added to the same data store, the sub-extraction query is created with UNION or INTERSECT SQL statements. This enables extraction of records that satisfy the filter criteria.

To better describe the two different situations, this guide divides the explanation in two different case:

• More than one single filter for the same data store. This filter adds an "OR" or an "AND" condition to the query.
• More than one combined filter for the same data store, involving more than one data element. This filter adds an "OR" or an "AND" condition to the query

For both cases, we used a DB2 table named CUSTOMER, with columns NAME and SURNAME and related class NAME and SURNAME.