You can use data filters to fetch specific data of a particular object.
When you use a ServiceNow connection, you can create simple or advanced data filters.
Simple data filters
You can create one or more simple data filters. When you create multiple simple data filters, the associated task creates an AND operator between the filters and loads rows that apply to all simple data filters.
1Select Data Filters tab in a synchronization task.
The Data Filters tab appears.
2Click New.
The Data Filter dialog box appears.
3Specify the following details:
Field Type
Description
Object
Select Object for which you want to assign filter fields.
Filter By
Select the Filter Field.
Operator
Select the operator.
Filter Value
Enter the Filter value.
4Click OK.
Advanced data filters
To run search queries containing complex filter expressions, use the advanced data filter.
1Click Advanced in Data Filter dialog box.
The Advanced Data Filter dialog box appears.
2Enter the Filter Expression.
3Click OK.
The following image shows the Advanced Data Filter page:
Rules and guidelines for data filters
Consider the following rules and guidelines when you apply data filters to filter ServiceNow objects:
•The filter query does not accept Null values.
•The filter condition must not be parameterized. Ensure to select the Not Parameterized option for the filter condition in the filter query option.
•Do not set up a filter that excludes records based on conditions where specific fields are not null, described as <table name><Field name> != null, or resemble <dv_field name>.
•You cannot use open and closed brackets () used in filter conditions.
You can specify the following operators, or use the formats supported by ServiceNow:
- AND operator for applying AND in simple and complex filter queries.
- OR operator for applying OR in simple queries
- ORNewQuery operator for applying OR for complex queries
For example, Category=Software AND Incident_State=7 ^NQ category=hardware AND Incident_state=1 OR Incident_state=2
For more information about the formats supported by ServiceNow, see the ServiceNow documentation.
•If a part of the filter query is not valid, ServiceNow returns rows using only the valid portion of the query and ignores the rest.
Follow these guidelines when you configure an advanced filter:
•Before you use an advanced filter, ensure that you add the -DDisableParsingForAdvancedFilter=true flag in the Custom Configuration Details section in the Secure Agent properties. For more information, see the ServiceNow advance filter Knowledge Base article.
•Ensure that the filter condition contains only the field name, operator, and field value.
•When you configure advanced filters, ensure that the filter condition contains only the field name, You must remove any additional text that is appended to the filter condition.
•When you use a NULL operator, ensure that the <Field name> appears before the <Table name> in the advanced filter condition.
