Data Integration Connectors
- Data Integration Connectors
- All Products
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
|