ServiceNow Connector > Synchronization tasks with ServiceNow Connector > Data filters
  

Data filters

You can use data filters to fetch specific data of a particular object. The synchronization task processes the data based on the filter field assigned to the object.
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.
    1. Select Data Filters tab in a synchronization task.
    The Data Filters tab appears.
    2. Click New.
    The Data Filter dialog box appears.
    3. Specify 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.
    4. Click OK.

Advanced data filters

To run search queries containing complex filter expressions, use the advanced data filter.
    1. Click Advanced in Data Filter dialog box.
    The Advanced Data Filter dialog box appears.
    2. Enter the Filter Expression.
    3. Click OK.
    The following image shows the Advanced Data Filter page:

Supported data filter operators

ServiceNow supports logical operators that you can use to filter data:
The following table shows the supported operators and the filter usage:
Operator
Symbol
Advanced Filter Usage
Greater than
>
field > value
For example, opened_at > $LastRunTime
Greater than equals
>=
field >= value
For example, sys_updated_on >= SYSDATE-86 AND caller_idIN 62826bf03710200044e0bfc8bcbe5df1,6816f79cc0a8016401c5a33be04be441
Equals
=
field = value
For example, number = INC003451
Less than
<
field < value
For example, opened_at < $LastRunTime
Less than equals
<=
field <= value
Not equal
!=
field != value
Starts with
STARTSWITH
field STARTSWITH value
Ends with
ENDSWITH
field ENDSWITH value
Contains
CONTAINS
field CONTAINS value
Is empty
ISEMPTY
field ISEMPTY value
Is not empty
ISNOTEMPTY
field ISNOTEMPTY value
In
IN
caller_id IN 46c1293aa9fe1981000dc753e75ebeee,
9ee1b13dc6112271007f9d0efdb69cd0
Date
SYSDATE
field > SYSDATE-1
For example, opened_at > SYSDATE-1
And
AND
field operator value AND field operator value
For example, location = a23c49b037d0200044e0bfc8bcbe5dda AND
caller_id = 46c1293aa9fe1981000dc753e75ebeee
Or
OR
field operator value OR field operator value
Between
BETWEEN
field BETWEEN value1,value2
For example, sys_updated_on BETWEEN 2017-03-01,2017-03-31
field BETWEEN SYSDATE-<value>,SYSDATE-<value>
For example, sys_updated_on BETWEEN SYSDATE-14,SYSDATE-1
ORNewQuery
ORNewQuery
query1 ORNewQuery query2
For example, opened_at >= SYSDATE-14 AND opened_at <= SYSDATE-1 ORNewQuery closed_at >= SYSDATE-14 AND closed_at <= SYSDATE-1

Rules and guidelines for data filters

Consider the following rules and guidelines when you apply data filters to filter ServiceNow objects: