Navigation:  Recipients - Managing customer data > Searching for recipients > Searching for fields >

Combining search rules

Previous pageReturn to chapter overviewNext page

Many searches cannot be performed using just one search rule. The OpenEMM allows you to combine any number of search rules . Search rules are linked with the AND and OR operators. If, for instance, one of the additional fields defined in the recipient profile is AGE_YEARS and you wanted to list all recipients aged 20 to 30 and having a GMX e-mail address (@gmx.de, @gmx.net etc.), you would need to define three search rules:

EMAIL LIKE %@gmx.%
AND AGE_YEARS > 19
AND AGE_YEARS < 31

The GMX search rule contains two % wildcards. GMX allows you to select your own country ID like .de or .net. The search rule filters all e-mail addresses containing the character string @gmx.. To specify the search, proceed as follows:

1.By clicking on Recipient and Overview in the navigation bar, call up the overview.
2.Open the input mask for Advanced Search.
3.The first search rule checks the e-mail address. In the Search for recipients drop-down list below Advanced search, select the EMAIL field. Select the LIKE operator. As a reference value, enter %@gmx.% into the field at the end of the line.
4.By clicking on the Add button you can now apply the search rule. The  OpenEMMwill now display the e-mail search rule above the drop-down lists with their entry fields.
5.The search rule line now features an additional drop-down list. The selections AND and OR determine how the OpenEMM links the search rules.
Fig. 4.8: Three combined search rules display only a single recipient.

Fig. 4.8: Three combined search rules display only a single recipient.

6.The second search rule checks whether the recipient is older than 19 (i.e., at least 20). In the first drop-down list, select AND. As a field, select the user-defined AGE_YEARS (details on user-defined fields can be found in chapter "Extending recipient's profiles"). Select the “greater than” relational operator (>). The reference value is 19.
7.By clicking on the Add button you can now apply the second search rule. The second search rule and the AND link now appear above the drop-down lists.
8.The third search rule filters recipients whose age is less than 31 (i.e., no more than 30). Select the AND operator and the field AGE_YEARS. Select the “less than” relational operator (<) and the reference value 31.
9.Clicking on the Add button again adds the third search rule.
10.The recipient list now displays only those profiles matching all search rules selected.

Note: You will receive the same results with the comparison operators >= 20 or <= 30.

If you want to delete a search rule, click on the Delete button behind that rule. In order to delete all search rules, click on the Overview tab.

Please note: This will cause OpenEMM to delete all search rules in the selected overview.