Search

ServiceNow Connector

ServiceNow Connector

Back Next

Supported data filter operators

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

Watch

Comments

Cloud Connectivity Homepage

0 COMMENTS

We’d like to hear from you! Log in to comment.