Combining search rules
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:
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.
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.