Setting Up Filters
When setting up a mapping, it is possible to specify filters in order to limit the amount of data that will be synced between ServiceNow and Hopex.
*For example, it might be wise to set up a filter on the status of the objects, in order to avoid syncing objects which are archived.
To set up a filter:
1. From the Mapping menu, open the relevant mapping.
2. Click Manage Filters.
3. Click Add Filters.
The Add/Edit Filter page appears.
4. Select the Mode.
• AND or OR operators
*See Composing multiple filters for further information.
• Query (only if Hopex is the source)
*Queries are to be registered in Hopex first. See Saving an ERQL query for further information.
*In case you have previously defined filters for a mapping, and you create a query filter, the previous filters will be deleted.
5. Select the Field.
6. Select the Operator.
7. Select the Value (if necessary).
8. Click Add filter.
A new filter line appears.
Composing multiple filters
You can create several filter lines for the same mapping. Filter lines are composed of AND and OR operators.
*The final filter will be in the form of "AND of ORs" - i.e. FilterX AND (FilterY OR FilterZ).
Example: Filtering the sync of Applications with a version number above "3" and either the Application type "cots" or "SaaS".