Versions Compared

Old Version 48

changes.mady.by.user Anna Kryzhanovskaya

Saved on

compared with

New Version 49

changes.mady.by.user Igor Shakhbazyan

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Merged branch "DOC0000076" into parent

Tables below provide information about condition operators, available for specified column types.

In the tables below, condition operators separated by the column types supported are given

On this page, operators separated by type of condition are listed.

NotePlease pay attention that these are condition types, not the system types listed in the Column Type (sys_db_column_type) table

.

In the Operator Display Name table column, the user displayed operator name is specified.

In the System name table column, the system operator name is specified, which is usable in condition strings or scripts.

In the Script table column, the example script is represented.

In the Condition Builder table column, the condition and its result are represented.

Available Extra Operators

Condition operators changes, changes from and changes to are applicable to any type of condition. They are used to track updates and changes in a particular field during record insert or update.

Tip

To use the VALCHANGESthe VALCHANGES, CHANGESFROM, CHANGESTO operators, you need to configure it as a column extra attribute first.


Operator Display Name

System nameCondition Builder
changesVALCHANGES

Priority changes

Returns true if "Priority" field value has changed during record insert/update.

When a record is inserted, the changes operator returns true for fields of any type. For example, if a business rule running on Insert has condition "Subject changes", then it will run when the Subject field is inserted with any value (not null or different from the Default Value).

changes fromCHANGESFROM

Priority changes from High

Returns true if "State" field value has changed from "High" to any other value during record insert/update.

changes toCHANGESTO

Priority changes to High

Returns true if "Priority" field value has changed to "High" during record insert/update.

Boolean

Operator Display NameSystem nameScriptCondition Builder
is=

current.addQuery('active', true);current.addQuery('active', '1'); // true

Active is Yes

The output is all records where "Active" field value is Yes only (attribute active=1).

is not!=

current.addQuery('active', '!=',

false

true);

current.addQuery('active', '

0

!=', '1');

 

//

false

true

Active is not Yes

The output is all records where "Is Extendable" field value is No only the Active field is not enabled (that is, this attribute Is Extendable = Falsevalue = 'false').

is sameSAMEAS

current.addQuery('active', 'sameas', 'published');

Active is same Published

The output is all records where "Active" and "Published" have the same value (both have Yes or No).

is differentNSAMEAScurrent.addQuery('active', 'nsameas', 'published');

Active  is different Published

The output is all records where "Active" and "Published" have different values (one has Yes and the other has No or vice versa).

Choice

Operator Display NameSystem nameScriptCondition Builder
is=

current.addQuery('priority', '2'); // High

Priority is High

The output is all records where "Priority" field value is "High" only.

is not!=current.addQuery('priority', '!=', '2'); // not High

Priority is not High

The output is all records where "Priority" field value is not equal to "High".

is one ofIN// High OR Moderate
current.addQuery('priority', 'in', ['2', '3']);

Priority is one of High, Moderate

The output is all records where "Priority" value is "High" or "Moderate".

is not one ofNOT IN// not High AND not Moderate
current.addQuery('priority', 'not in', ['2', '3']);;

Priority is not one of High, Moderate

The output is all records where "Priority" value is any other than "High" or "Moderate"

contains
greater than
LIKE
>current.addQuery('state', '
like
>', '
publish
3')
;State contains publish
// High

Priority is greater than High

The output is all records where "

State" contains substring "publish" in choice title.does not contain

Priority" value is greater than High.

less than<
NOTLIKE
current.addQuery('state', '
notlike
<', '
publish
3')
;State does not contain publish
// High

Priority is less than High

The output is all records where "

State" does not contain these characters in choice title.starts with

Priority" value is less than High.

greater than or is=>
STARTSWITH
current.addQuery('state', '
startswith
=>', '
publish
3')
;State starts with publish
// High

Priority is greater than or equal to High

The output is all records where "

State" contains these characters at the beginning of choice title.ends with

Priority" value is greater than or equal to High.

less than or is<=
ENDSWITH
current.addQuery('state', '
endswith
<=', '
ed
3')
;State ends with ed
// High

Priority is less than or equal to High

The output is all records where "

State" contains these characters at the end of choice title.is empty

Priority" value is less than or equal to High.

betweenBETWEEN
ISEMPTY

current.addQuery('state',

'isempty

'between', '1', '3')

; 

//

NoneState is empty

between Low and High

Priority is between Low and High

The output is all records where "

State

Priority"

does not contain any value (None

value is between Low and High (Critical priority is not included).

is not empty
contains
ISNOTEMPTY

LIKE

current.addQuery('state', 'like', '
isnotempty
publish');
 // not None

State 

is not empty

contains publish

The output is all records where "State" contains

any value

substring "publish" in choice title.

is same
does not containNOTLIKE
SAMEAS
current.addQuery('
urgency
state', '
sameas
notlike', '
impact
publish');
Urgency is same Impact

State does not contain publish

The output is all records where "

Urgency " and "Impact" have the same value (both have Low, for example).

State" does not contain these characters in choice title.

starts withSTARTSWITH
is differentNSAMEAS
current.addQuery('
urgency
state', '
nsameas
startswith', '
impact
publish');
Urgency is different Impact

State starts with publish

The output is all records where

values of

"

Urgency" and "Impact" have different values (one has High and the other has Moderate, for example).

Date

State" contains these characters at the beginning of choice title.

ends withENDSWITHcurrent.addQuery('state', 'endswith', 'ed');

State ends with ed

Operator Display NameSystem nameScriptCondition BuilderonONcurrent.addQuery('expired_at', '2019-01-01');Expire at on 2019-01-01

The output is all records where "State"

Expire at" field value is "2019-01-01" exactly.not onNOTON

 contains these characters at the end of choice title.

is emptyISEMPTYcurrent.addQuery('
expired_at
state', '
!=', '2019-01-01'
isempty');
Expire at not on 2019-01-01
 // None

State is empty

The output is all records where "

Expire at" is any value but "2019-01-01".before<

State" does not contain any value (None).

is not emptyISNOTEMPTYcurrent.addQuery('
expired_at
state', '
<', '2019-01-01');Expire at before 2019-01-01
isnotempty'); // not None

State is not empty

The output is all records where "

Expire at" date before "2019-01-01".after>

State" contains any value.

is sameSAMEAScurrent.addQuery('
expired_at
urgency', '
>
sameas', '
2019-01-01
impact');
Expire at after 2019-01-01

Urgency is same Impact

The output is all records where "

Expire at

Urgency "

date after "2019-01-01".at or before

and "Impact" have the same value (both have Low, for example).

is differentNSAMEAS
<=
current.addQuery('
expired_at
urgency', '
<=
nsameas', '
2019-01-01
impact');
Expire at at or before 2019-01-01

Urgency is different Impact

The output is all records where values of "

Expire at

Urgency"

is "2019-01-01" or the date before it.

and "Impact" have different values (one has High and the other has Moderate, for example).

Date

Operator Display NameSystem nameScriptCondition Builder
onON

current.addQuery('expired_at', '2019-01-01');

current.

at or after>=current.

addQuery('expired_at', '

>

=', '2019-01-01');

Expire at 

at or after 2019

on 2019-01-01

The output is all records where "Expire at" field value is "2019-01-01"

or the date after it

exactly.

between
not on
BETWEEN
NOTONcurrent.addQuery('expired_at', '
>
!=', '2019-01-01');

Expire at not on 2019-01-01

The output is all records where "Expire at" is any value but "2019-01-01".

before<current.addQuery('expired_at', '<
=
', '2019-01-
31
01');

Expire

at between

at before 2019-01-01

(and) 2019-01-31The

The output is all records where "Expire at"

contains a

date

between 2019

before "2019-01-01

and 2019-01-31 including these dates

".

contains
after
LIKE
>current.addQuery('expired_at', '
like
>', '2019-01-01');

Expire

at contains

at after 2019-01-01

The output is all records where

database value (in UTC) of

"Expire at"

contains

date after "2019-01

" (for example, records that expire at 2019

-01

-23)

".

does not contain
at or before<=
NOTLIKE
current.addQuery('expired_at', '
notlike
<=', '2019-01-01');

Expire at

does not contain

at or before 2019-01-01

The output is all records where

database value (in UTC)

"Expire at"

does not contain 

is "2019-01-01"

(for example, records that expire at 2019-02-01).

or the date before it.

at or after>=
is emptyISEMPTY
current.addQuery('expired_at', '>=', '
isempty
2019-01-01');

Expire

at is empty

at at or after 2019-01-01

The output is all records where "Expire at

" does not contain any value.

" is "2019-01-01" or the date after it.

betweenBETWEEN
is not emptyISNOTEMPTY

current.addQuery('

expired

sys_created_at', '

, 'isnotempty

between', '2019-01-01 03:00:00', '2019-01-01 03:00:00');

Expire

at is not empty

at between 2019-01-01 (and) 2019-01-31

The output is all records where "Expire at" contains

any value.is same

a date between 2019-01-01 and 2019-01-31 including these dates.

contains

LIKE

SAMEAS

current.addQuery('expired_at', '
sameas
like', '
starts_at
2019-01');

Expire

at is same Starts at

at contains 2019-01

The output is all

records where

records where database value (in UTC) of "Expire at" contains "

and "Starts at" have the same date.

2019-01" (for example, records that expire at 2019-01-23).

does not containNOTLIKE
is differentNSAMEAS
current.addQuery('expired_at', '
nsameas
notlike', '
starts_at
2019-01');

Expire

at is different Starts at

at does not contain 2019-01

The output is all records where database value (in UTC) "Expire at

" and "Starts at" have different dates.

" does not contain "2019-01" (for example, records that expire at 2019-02-01).

is emptyISEMPTY
year isYEAR_IS
current.addQuery('expired_at', '
year_is', '2020'
isempty');

Expire at

year

is

2020

empty

The output is all records where

the database value (in UTC) of

"Expire at"

contains the corresponding year

does not contain any value.

month
is not empty
MONTH_IS
ISNOTEMPTYcurrent.addQuery('expired_at', '
month_is', '9'
isnotempty');

Expire at

month is September

is not empty

The output is all records where

the database value (in UTC) of

"Expire at" contains

the corresponding month

any value.

quarter
is same
QUARTER_IS
SAMEAScurrent.addQuery('expired_at', '
quarter_is
sameas', '
2
starts_at');

Expire at

quarter is II

is same Starts at

The output is all

records where the database value (in UTC) of

records where "Expire at"

contains the corresponding quarter

and "Starts at" have the same date.

week
is different
WEEK_IS
NSAMEAScurrent.addQuery('expired_at', '
week_is
nsameas', '
32
starts_at');

Expire at is different Starts at

week is 32

The output is all records where the

database value (in UTC) of

"Expire at"

contains the corresponding week.day is

value is different to the "Starts at" one.

year isYEAR
DAY
_IScurrent.addQuery('expired_at', '
day
year_is', '
10
2020');

Expire at

day is 10

year is 2020

The output is all records where the database value (in UTC) of "Expire at" contains the corresponding

day of a month (10th day of any month)

year.

day of week
month is
DAY
MONTH_
OF_WEEK_
IScurrent.addQuery('expired_at', '
day_of_week
month_is', '
1
9');

Expire at

day of the week is Monday

month is September

The output is all records where the database value (in UTC) of "Expire at" contains the corresponding

day of the week.

Date/Time

Tip

The input data for Date/Time fields must have the following format: YYYY-MM-DD hh:mm:ss

Operator Display NameSystem nameScriptCondition BuilderonON

month.

quarter isQUARTER_IScurrent.addQuery('expired_at', 'quarter_is', '2');

Expire at quarter is II

The output is all records where the database value (in UTC) of "Expire at" contains the corresponding quarter.

week isWEEK_IS
current.addQuery('
sys_created_at
expired_at', 'week_is', '
2019-01-01 03:00:00
32');
Created at on 2019-01-01 03:00:00

Expire at week is 32

The output is all records where

"Created at" field value is "2019-01-01 03:00:00" exactly.not on

the database value (in UTC) of "Expire at" contains the corresponding week.

day isDAY_IS
NOTON
current.addQuery('
sys
expired_
created_
at', '
!=
day_is', '
2019-01-01 03:00:00
10');
Created at not on 2019-01-01 03:00:00

Expire at day is 10

The output is all records where

"Created at" is any value but "2019-01-01 03:00:00".before

the database value (in UTC) of "Expire at" contains the corresponding day of a month (10th day of any month).

day of week isDAY_OF_WEEK_IS
<
current.addQuery('
sys_created
expired_at', '
<
day_of_week_is', '
2019-01-01 02:59:59
1');
Created at before 2019-01-01 02:59:59

Expire at day of the week is Monday

The output is all records where the database value (in UTC) of "Expire at" contains the corresponding day of the week.


Date/Time, Date/Time Specific

Tip

The input data for Date/Time fields must have the following format: YYYY-MM-DD hh:mm:ss


"Created at" before datetime "2019-01-01 02:59:59".><=>=MONTH_ISQUARTER_ISDAY_IS
Operator Display NameSystem nameScriptCondition Builder
onON

current.addQuery('sys_created_at', '2019-01-01 03:00:00');

after

current.addQuery('sys_created_at', '

>

=', '2019-01-01

02

03:

59

00:

59

00');

Created at after on 2019-01-01 0203:5900:5900

The output is all records where "Created at" after datetime field value is "2019-01-01 0203:5900:5900" exactly.

at or before
not onNOTONcurrent.addQuery('sys_created_at', '<!=', '2019-01-01 03:00:00');

Created at at or before 2019 not on 2019-01-01 0301 03:00:00

The output is all records where "Created at" is any value but "2019-01-01 03:00:00" or the datetime before it.

at or after
before<current.addQuery('sys_created_at', '>=<', '2019-01-01 0302:0059:0059');

Created at  at or after 2019-11before 2019-01-01 02:59:59

The output is all records where "Created at" contains before datetime "2019-1101-01 " or the dateme after it02:59:59".

betweenafterBETWEEN>current.addQuery('sys_created_at', '>=', '2019-01-01 0302:0059:0059');

current.addQuery('sys_created_at', '<=', '2019-01-02 02:59:59');Created at between 2019Created at after 2019-01-01 03:00:00 (and) 2019-01- 02 02:59:59

The output is all records where "Created at" contains a after datetime between 2019"2019-01-01 03:00:00 and 2019-01- 02 02:59:59 including these datetimes".

at or before<=containsLIKEcurrent.addQuery('sys_created_at', 'like<=', '2019-01-01 03:4400:00');

Created

at contains

at at or before 2019-01-01 03:

44

00:00

The output is all records where

database value (in UTC) of

"Created at"

contains

is "2019-01-01 03:

44

00:

" (for example, records that created at 2019-01-01 03:44:11).
Note

This condition operator returns records with partial matches and requires input datetime in UTC.

does not containNOTLIKE

00" or the datetime before it.

at or after>=current.addQuery('sys_created_at', 'notlike>=', '2019-01-01 03:00:00');

Created

at does not contain 2019-01

at at or after 2019-11-01

03:

The output is all records where

database value (in UTC)

"Created at"

does not contain 

contains "2019-

01

11-01

03:44:" (for example, records that created at

" or the dateme after it.

betweenBETWEEN

current.addQuery('sys_created_at', 'between', '2019-01-01 03:

44:11).
Note

This condition operator returns records with partial matches and requires input datetime in UTC.

is emptyISEMPTYcurrent.addQuery('closed_at', 'isempty');

00:00', '2019-01-01 03:00:00');

Created at between 2019-01-01 03:00:00 (and) 2019-01-02 02:59:59Closed at is empty

The output is all records where "Closed at" does not contain any value.

is not emptyISNOTEMPTYcurrent.addQuery('closed_at', 'isnotempty');

Closed at is not empty

The output is all records where "Closed at" contains any value.

Created at" contains a datetime between 2019-01-01 03:00:00 and 2019-01-02 02:59:59 including these datetimes.

contains

LIKE

is sameSAMEAScurrent.addQuery('sys_created_at', 'sameaslike', 'sys_updated_at2019-01-01 03:44:');

Created

at is same Updated at

at contains 2019-01-01 03:44:

The output is all

records where

records where database value (in UTC) of "Created at"

and "Updated at" have the same value.		is different

contains "2019-01-01 03:44:" (for example, records that created at 2019-01-01 03:44:11).

Note

This condition operator returns records with partial matches and requires input datetime in UTC.


does not containNOTLIKENSAMEAScurrent.addQuery('sys_created_at', 'nsameasnotlike', 'sys_updated_at2019-01-01 03:');

Created

at is different Updated at

at does not contain 2019-01-01 03:

The output is all records where

"Created

database value (in UTC) "Created at"

and "Updated at" have different values.		year isYEAR_IScurrent.addQuery('sys_created_at', 'year_is', '2019');

Created at year is 2019

The output is all records where the database value (in UTC) of "Created at" contains the corresponding yeardoes not contain "2019-01-01 03:44:" (for example, records that created at 2019-01-01 03:44:11).

Note

This condition operator returns records with partial matches and requires input datetime in UTC.

month


is emptyISEMPTYcurrent.addQuery('sys_createdclosed_at', 'month_is', '9'isempty');Created

Closed at

month is September

is empty

The output is all records where

the database value (in UTC) of "Created at" contains the corresponding month.
Note

This condition operator returns records with partial matches and requires input datetime in UTC.

quarter is

"Closed at" does not contain any value.

is not emptyISNOTEMPTYcurrent.addQuery('sysclosed_created_at', 'quarter_is', '2isnotempty');Created at quarter is II

Closed at is not empty

The output is all records where

the database value (in UTC) of "Created

"Closed at" contains

the corresponding quarter.
Note

This condition operator returns records with partial matches and requires input datetime in UTC.

week isWEEK_IS

any value.

is sameSAMEAScurrent.addQuery('sys_created_at', 'week_issameas', '32sys_updated_at');

Created at

week is 32

is same Updated at

The output is all

records where the database value (in UTC) of

records where "Created at

" contains the corresponding week.
Note

This condition operator returns records with partial matches and requires input datetime in UTC.

day is

" and "Updated at" have the same value.

is differentNSAMEAScurrent.addQuery('sys_created_at', 'day_isnsameas', '32sys_updated_at');

Created at is different Updated at

day is 10

The output is all records where

the database value (in UTC) of "Created at" contains the corresponding day of a month (10th day of any month).
Note

This condition operator returns records with partial matches and requires input datetime in UTC.

"Created at" and "Updated at" have different values.

year isYEAR_day of week isDAY_OF_WEEK_IScurrent.addQuery('sys_created_at', 'day_ofyear_week_is', '12019');

Created at day of the week is Monday year is 2019

The output is all records where the database value (in UTC) of "Created at" contains the corresponding day of the weekyear.

Note

This condition operator returns records with partial matches and requires input datetime in UTC.


hour month isHOURMONTH_IScurrent.addQuery('sys_created_at', 'hourmonth_is', '109');

Created at hour is 10 month is September

The output is all records where the database value (in UTC) of "Created at" contains the corresponding hourthe corresponding month.

Note

This condition operator returns records with partial matches and requires input datetime in UTC.

Fieldname

ENDSWITH


quarter isQUARTER_IS
Operator Display NameSystem nameScriptCondition Builder
containsLIKEcurrent.addQuery('columnsys_created_idat', 'likequarter_is', 'typ2');Column contains typ

Created at quarter is II

The output is all records where

"Column" display value contains "typ".		does not contain

the database value (in UTC) of "Created at" contains the corresponding quarter.

Note

This condition operator returns records with partial matches and requires input datetime in UTC.


week isWEEK_ISNOTLIKEcurrent.addQuery('columnsys_created_idat', 'notlikeweek_is', 'typ32');Column does not contain typ

Created at week is 32

The output is all records where

"Column" display value does not contain "typ".		starts with

the database value (in UTC) of "Created at" contains the corresponding week.

Note

This condition operator returns records with partial matches and requires input datetime in UTC.


day isDAY_ISSTARTSWITHcurrent.addQuery('columnsys_created_idat', 'startswithday_is', 'typ32');Column starts with typ

Created at day is 10

The output is all records where

"Column" display value contains "typ" at the beginning.		ends with

the database value (in UTC) of "Created at" contains the corresponding day of a month (10th day of any month).

Note

This condition operator returns records with partial matches and requires input datetime in UTC.


day of week isDAY_OF_WEEK_IScurrent.addQuery('columnsys_created_idat', 'endswithday_of_week_is', 'typ1');Column ends with typ

Created at day of the week is Monday

The output is all records where

"Column" display value contains "typ" at the end.		is empty

the database value (in UTC) of "Created at" contains the corresponding day of the week.

Note

This condition operator returns records with partial matches and requires input datetime in UTC.


hour isHOUR_ISISEMPTYcurrent.addQuery('column_idsys_created_at', 'hour_is', 'isempty10');Column is empty

Created at hour is 10

The output is all records where

"Column" does not contain any value.
is not emptyISNOTEMPTYcurrent.addQuery('column_id', 'isnotempty');

Column is not empty

The output is all records where "Column" does contain any value.

JSON

the database value (in UTC) of "Created at" contains the corresponding hour.

Note

This condition operator returns records with partial matches and requires input datetime in UTC.



Document ID

Operator Display NameSystem nameScriptCondition Builder
contains
is
LIKE
=current.addQuery('
json_copy
item', '
like', '"url": null
022d99c1-16c7-e506-023e-62dbbb69a6eb');
JSON Copy contains "url": null

Item is 022d99c1-16c7-e506-023e-62dbbb69a6eb

The output is all records where "

JSON Copy

Item"

display

field value

contains "url": null.does not contain

is "022d99c1-16c7-e506-023e-62dbbb69a6eb".

is not!=
NOTLIKE
current.addQuery('
json_copy
item', '
notlike
!=', '
"url": null
022d99c1-16c7-e506-023e-62dbbb69a6eb')
;
JSON Copy does not contain "url": null

Item is not 022d99c1-16c7-e506-023e-62dbbb69a6eb

The output is all records where "

JSON Copy

Item"

display

field value

does

is not

contain ""url": null".is

"022d99c1-16c7-e506-023e-62dbbb69a6eb".

containsLIKE
=
current.addQuery('item', 'like', '022d99c1-16c7-e506');

Item contains 022d99c1-16c7-e506

The output is all records where "Item" field value contains "022d99c1-16c7-e506".

does not containNOTLIKErecord.addQuery('item', 'notlike', '022d99c1-16c7-e506');

Item does not contain 022d99c1-16c7-e506

The output is all records where "Document Record" field value does not contain "022d99c1-16c7-e506".

is emptyISEMPTYcurrent.addQuery('record_document_id', 'isempty')

Document Record is empty

The output is all records where "Document Record" field value is empty.

is not emptyISNOTEMPTYcurrent.addQuery('record_document_id', 'isnotempty')

Document Record is empty

The output is all records where "Document Record" field value is not empty.


Field Name

Operator Display NameSystem nameScriptCondition Builder
containsLIKEcurrent.addQuery('column_id', 'like', 'typ');

Column contains typ

The output is all records where "Column" display value contains "typ".

does not containNOTLIKEcurrent.addQuery('column_id', 'notlike', 'typ');

Column does not contain typ

The output is all records where "Column" display value does not contain "typ".

starts withSTARTSWITHcurrent.addQuery('column_id', 'startswith', 'typ');

Column starts with typ

The output is all records where "Column" display value contains "typ" at the beginning.

ends withENDSWITHcurrent.addQuery('column_id', 'endswith', 'typ');

Column ends with typ

The output is all records where "Column" display value contains "typ" at the end.

is emptyISEMPTYcurrent.addQuery('column_id', 'isempty');

Column is empty

The output is all records where "Column" does not contain any value.

is not emptyISNOTEMPTYcurrent.addQuery('column_id', 'isnotempty');

Column is not empty

The output is all records where "Column" does contain any value.

JSON

Operator Display NameSystem nameScriptCondition Builder
containsLIKEcurrent.addQuery('json_copy', 'like', '"url": null');

JSON Copy contains "url": null

The output is all records where "JSON Copy" display value contains "url": null.

does not containNOTLIKEcurrent.addQuery('json_copy', 'notlike', '"url": null');

JSON Copy does not contain "url": null

'json_copy', relatedRecord.json_copy);

JSON Copy is {"value": "Asia/Manila", "policy": "Open", "sys_id": 159116700509210619, "column_id": 159116700503520188, "record_id": 156076775207774694, "language_id": 156628684306541141, "application_id": 155931135900000002, "sys_created_at": "2020-06-03 06:50:05", "sys_created_by": null, "sys_updated_at": "2020-06-03 06:50:05", "sys_updated_by": null}

The output is all records where "JSON Copy" field value is exactly this inputdisplay value does not contain ""url": null".

is not!=current.addQuery('json_copydata', '!= ', relatedRecord.json_copy);JSON Copy is not {"valueuser_id": "Asia/Manilajohn.doe", "policyemail": "john.doe@example.com"}');

Data is {"userOpen", "sys_id": 159116700509210619, "column_id": 159116700503520188, "record_id": 156076775207774694, "language_id": 156628684306541141"john.doe", "application_id": 155931135900000002, "sys_created_at": "2020-06-03 06:50:05", "sys_created_by": null, "sys_updated_at": "2020-06-03 06:50:05", "sys_updated_by": nullemail": "john.doe@example.com"}

The output is all records where "Data" field value is exactly this input.

is not!=current.addQuery('data', '!=', '{"user_id": "john.doe", "email": "john.doe@example.com"}');

Data is not {"user_id": "john.doe", "email": "john.doe@example.com"}

The output is all records where "JSON CopyData" field value is not equal to this input.

is emptyISEMPTYcurrent.addQuery('json_copy', 'isempty');

JSON Copy is empty

The output is all values where "JSON Copy" does not contain any value.

is not emptyISNOTEMPTYcurrent.addQuery('json_copy', 'isnotempty');

JSON Copy is not empty

The output is all values where "JSON Copy" contains any value.

is sameSAMEAScurrent.addQuery('diplayable_path', 'sameas', 'formatter');

Displayable Path is same Formatter

The output is all values where "Displayable Path" and "Formatter" have the same values.

is differentNSAMEAScurrent.addQuery('diplayable_path', 'nsameas', 'formatter');

Displayable Path is different Formatter

The output is all values where "Displayable Path" and "Formatter" have different values.

Keywords

Operator Display NameSystem nameScriptCondition Builder
areAREcurrent.addQuery('keywords', 'are', 'mail');

Keywords are mail

The output is all records Full text search column of which contains the corresponding value.

Image

Operator Display NameSystem nameScriptCondition Builder
is emptyISEMPTYcurrent.addQuery('profile_picture', 'isempty');

Profile Picture is empty

The output is all records where "Profile Picture" does not contain any image files.

is not emptyISNOTEMPTYcurrent.addQuery('profile_picture', 'isnotempty');

Profile Picture is not empty

The output is all records where "Profile Picture" contains an image file.


List

Operator Display NameSystem nameScriptCondition Builder
hasHAScurrent.addQuery('categories', 'has', '155988310508800001,157688891108786828');

Categories has Article, Model

The output is all records where "Categories" contains the corresponding lists of references in this order exactly.

"Categories has Article, Model"
and "Categories has Model, Article" are different conditions.


Tip

To get all records with Article, Model categories build the following condition:


Categories has Article AND Categories has Model


has notHASNOTcurrent.addQuery('categories', 'hasnot', '155988310508800001,157688891108786828');

Categories has not Article, Model

The output is all records where "Categories" does not contain the corresponding lists of references in this order exactly.

"Categories has not Article, Model"
and "Categories has not Model, Article" are different conditions.


Tip

To exclude all records with "Article" and "Model" categories build the following condition:


Categories has not Article AND Categories has not Model


is=current.addQuery('categories', '155988310508800001');

Categories is Article

The output is all records where "Categories" contains only the corresponding reference.

is not!=current.addQuery('categories', '!=', '155988310508800001');

Categories is not Article

The output is all records where "Categories" is not equal to the corresponding reference (all but Article).

containsLIKEcurrent.addQuery('categories', 'like', 'artic');

Categories contains artic

The output is all records where references in "Categories" field contains corresponding characters in Display by Ref field.

does not containNOTLIKEcurrent.addQuery('categories', 'notlike', 'artic');

Categories does not contain artic

The output is all records where references in "Categories" field does not contain corresponding characters in Display by Ref field.

is emptyISEMPTYcurrent.addQuery('categories', 'isempty');

Categories is empty

The output is all records where "Categories" field is empty.

is not emptyISNOTEMPTYcurrent.addQuery('categories', 'isnotempty');

Categories is not empty

The output is all records where "Categories" field is not empty.

contains (dynamic)CONTAINS_DYNAMICcurrent.addQuery('followers', 'contains_dynamic', '160516373014385744');

Followers contains (dynamic) Me

The output is all records where "Followers" contains ID of current user. Using dynamic filters returning sequence of IDs is not right because the sequence is taken into account. 

does not contain (dynamic)DOESNOTCONTAIN_DYNAMICcurrent.addQuery('followers', 'doesnotcontain_dynamic', '160516373014385744');

Followers does not contain (dynamic) Me

The output is all records where "Followers" does not contain ID of current user. Using dynamic filter returning sequence of IDs is not right because the sequence is taken into account. 


Big Integer, Integer, Small Integer, Decimal, Float

, Numeric

, Percent Complete

, Percent Decimal

, Days of Week, Duration

Operator Display NameSystem nameScriptCondition Builder
is=current.addQuery('max_length', 10);

Max Length is 10

The output is all records where "Max Length" contains a value equal to 10.

is not!=current.addQuery('max_length', '!=', 10);

Max Length is not 10

The output is all records where "Max Length" contains any value but 10.

is one ofINcurrent.addQuery('max_length', 'in', [10, 32]);

Max Length is one of 10,32

The output is all records where "Max Length" contains "10" or "32".

Please note that the values in the input field are comma-separated or separated by linebreak (space is not allowed).

less than<current.addQuery('max_length', '<', 255);

Max Length less than 255

The output is all records where "Max Length" contains value less than 255.

greater than>current.addQuery('max_length', '>', 255);

Max Length greater than 255

The output is all records where "Max Length" contains value greater than 255.

less than or is<=current.addQuery('max_length', '<=', 255);

Max Length less than or is 255

The output is all records where "Max Length" contains value less than 255 or equal to 255.

greater than or is>=current.addQuery('max_length', '>=', 255);

Max Length greater than or is 255

The output is all records where "Max Length" contains value greater than 255 or equal to 255.

betweenBETWEEN

current.addQuery('max_length', 'between', [10, 255]);

current.addQuery('max_length', 'between', ['10', '255']);

Max Length between 10 (and) 255

The output is all records where "Max Length" contains value in this range: [10; 255].

is sameSAMEAScurrent.addQuery('taskpd', 'sameas', 'completed_tasks');

Tasks per day is same Completed tasks

The output is all records where "Tasks per day" and "Completed tasks" contain the same value.

is differentNSAMEAScurrent.addQuery('taskpd', 'nsameas', 'completed_tasks');

Tasks per day is different Completed tasks

The output is all records where "Tasks per day" and "Completed tasks" contain different values.

greater than fieldGT_FIELD
current.addQuery('taskpd', '>gt_field', 'completed_tasks');

Tasks per day greater than field Completed tasks

The output is all records where the field value of "Tasks per day" is greater than the field value of "Completed tasks" (not including its value).

less than fieldLT_FIELDcurrent.addQuery('taskpd', '<lt_field', 'completed_tasks');

Tasks per day less than field Completed tasks

The output is all records where the field value of "Tasks per day" is less than the field value of "Completed tasks" (not including its value).

greater than or is fieldGT_OR_EQUALS_FIELDcurrent.addQuery('taskpd', '>=gt_or_equals_field', 'completed_tasks');

Tasks per day greater than or is field Completed tasks

The output is all records where the field value of "Tasks per day" is greater than the field value of "Completed tasks" or is equal to the value.

less than or is fieldLT_OR_EQUALS_FIELDcurrent.addQuery('taskpd', '<=lt_or_equals_field', 'completed_tasks');

Tasks per day less than or is field Completed tasks

The output is all records where the field value of "Tasks per day" is less than the field value of "Completed tasks" or is equal to the value.

is emptyISEMPTYcurrent.addQuery('max_length', 'isempty');

Max Length is empty

The output is all records where "Max Length" does not contain any value.

is not emptyISNOTEMPTYcurrent.addQuery('max_length', 'isnotempty');

Max Length is not empty

The output is all records where "Max Length" contains any value.

Reference

Operator Display NameSystem nameScriptCondition Builder
is=current.addQuery('caller', '160624751417596911');

Caller is John Doe

The output is all records where "Caller" field value is "John Doe" only.

is not!=current.addQuery('caller', '!=', '160624751417596911');

Caller is not John Doe

The output is all records where "Caller" field value is not "John Doe" (empty records are displayed too).

is one ofINcurrent.addQuery('table_id', 'in', ['155964310500000291', '160456341213536956']);

Table is one of Known Errors, Article

The output is all records where "Table" field contains "Known Errors" or "Article".

containsLIKEcurrent.addQuery('caller', 'like', 'Aleks');

Caller contains Aleks

The output is all records where references in "Caller" field contains corresponding characters in Display by Ref field.

does not containNOTLIKEcurrent.addQuery('caller', 'notlike', 'Aleks');

Caller does not contain Aleks

The output is all records where references in "Caller" field does not contain corresponding characters in Display by Ref field.

starts withSTARTSWITHcurrent.addQuery('caller', 'startswith', 'Aleks');

Caller starts with Aleks

The output is all records where references in "Caller" field starts with corresponding characters in Display by Ref field.

ends withENDSWITHcurrent.addQuery('caller', 'endswith', 'ev');

Caller ends with ev

The output is all records where references in "Caller" field ends with corresponding characters in Display by Ref field.

is emptyISEMPTYcurrent.addQuery('related_ticket', 'isempty');

Related Ticket is empty

The output is all records where "Related Ticket" does not contain any reference.

Note

Please note that in case the Reference field is configured to On delete = No Action, the sys_id of the deleted record remains in the field (then the reference leads to nonexisting record). Such records will not be displayed in the output of "Reference field is empty". In order to exclude records with deleted reference in the output, please use this condition:

Reference Field → ID is empty.


is not emptyISNOTEMPTYcurrent.addQuery('related_ticket', 'isnotempty');

Related Ticket is not empty

The output is all records where "Related Ticket" contain any reference.

Note

Please note that in case the Reference field is configured to On delete = No Action, the sys_id of the deleted record remains in the field (then the reference leads to nonexisting record). Such records will be displayed in the output of "Reference field is not empty". In order to exclude records with deleted reference from the output, please use this condition:

Reference Field → ID is empty.


is sameSAMEAScurrent.addQuery('caller', 'sameas', 'assigned_user');

Caller is same Assigned User

The output is all records where "Caller" and "Assigned User" have the same reference (empty values are suitable).

is differentNSAMEAScurrent.addQuery('caller', 'nsameas', 'assigned_user');

Caller is different Assigned User

The output is all records where "Caller" and "Assigned User" have different reference (one of fields emptiness is empty value is suitable).

is (dynamic)DYNAMICcurrent.addQuery('assignment_group', 'dynamic', '1589643105003304555');

Assignment Group is (dynamic) One of My Group

The output is all records where "Assignment Group" contains one of current user group ID.

is not (dynamic)ISNOT_DYNAMICcurrent.addQuery('assigned_user', 'isnotdynamic', '164643105003300222');

Assigned User is not (dynamic) Me

The output is all records where "Assigned User" does not contain ID of current user (empty value values are suitable).

Record Class

Operator Display NameSystem nameScriptCondition Builder
is=current.addQuery('sys_db_table_id', '155931135900000084');

Table is User

The output is all records where "Table" field value is "User".

is not!=current.addQuery('sys_db_table_id', '!=', '155931135900000084');

Table is not Users

The output is all records where "Table" field value is any table but "User".

is one ofINcurrent.addQuery('sys_db_table_id', 'in', ['155931135900000084', '156873090301469473']);

Table is one of Users, Employee

The output is all records where "Table" field value is "User" or "Employee".

containsLIKE

current.addQuery('sys_db_table_id', 'like', 'rep');

Table contains rep

The output is all records where "Table" title contains these characters anywhere in it.

does not containNOTLIKEcurrent.addQuery('sys_db_table_id', 'notlike', 'rep');

Table does not contain rep

The output is all records where "Table" title does not contain these characters.

starts withSTARTSWITHcurrent.addQuery('sys_db_table_id', 'startswith', 'sys');

Table starts with sys

The output is all records where "Table" title contains "sys" at the beginning.

ends withENDSWITHcurrent.addQuery('sys_db_table_id', 'endswith', 'rule');

Table ends with rule

The output is all records where "Table" title contains "rule" at the end.

HTML, Script

Operator Display NameSystem nameScriptCondition Builder
containsLIKEcurrent.addQuery('script', 'like', 'return user.sys_id');

Script contains return user.sys_id

The output is all records where "Script" contains these characters anywhere in it.

does not containNOTLIKEcurrent.addQuery('script', 'notlike', 'return user.sys_id');

Script does not contain return user.sys_id

The output is all records where "Script" does not contain these characters.

is emptyISEMPTYcurrent.addQuery('script', 'isempty');

Script is empty

The output is all records where "Script" does not contain any value.

is not emptyISNOTEMPTYcurrent.addQuery('script', 'isnotempty');

Script is not empty

The output is all records where "Script" contains any value.

Phone, String, Text, Translated Text, Conditions, Url

Operator Display NameSystem nameScriptCondition Builder
containsLIKEcurrent.addQuery('email', 'like', 'lot');

Email contains lot

The output is all records where "Email" contains these characters anywhere in it.

does not containNOTLIKEcurrent.addQuery('email', 'notlike', '_');

Email does not contain ov

The output is all records where "Email" does not contain these characters.

starts withSTARTSWITHcurrent.addQuery('last_name', 'startswith', 'iv');

Last Name starts with iv

The output is all records where "Last Name" contains "iv" at the beginning.

ends withENDSWITHcurrent.addQuery('last_name', 'endswith', 'ov');

Last Name ends with ov

The output is all records where "Last Name" contains "ov" at the end.

is=current.addQuery('last_name', 'Ivanov');

Last Name is Ivanov

The output is all records where "Last Name" contains "Ivanov" exactly.

is not!=current.addQuery('last_name', '!=', 'Ivanov');

Last Name is not Ivanov

The output is all records where "Last Name" contains any value but "Ivanov".

is emptyISEMPTYcurrent.addQuery('username', 'isempty');

Username is empty

The output is all records where "Username" does not contain any value.

is not emptyISNOTEMPTYcurrent.addQuery('username', 'isnotempty');

Username is not empty

The output is all records where "Username" contains any value.

is sameSAMEAScurrent.addQuery('display_name', 'sameas', 'number');

Display Name is same Number

The output is all records where "Display Name" and "Number" have the same value.

is differentNSAMEAScurrent.addQuery('display_name', 'nsameas', 'number');

Display Name is different Number

The output is all records where "Display Name" and "Number" have different values.

Time

Note

This condition requires input time in UTC.


Operator Display NameSystem nameScriptCondition Builder
onONcurrent.addQuery('run_time', '11:00:00');

Run Time on 11:00:00

The output is all records where "Run Time" database value is "11:00:00" exactly.

not onNOTONcurrent.addQuery('run_time', '!=', '11:00:00');

Run Time not on 11:00:00

The output is all records where "Run Time" database value is not "11:00:00".

before<current.addQuery('run_time', '<', '11:00:00');

Run Time before 11:00:00

The output is all records where "Run Time" contains time before "11:00:00" (at 10:59:59 and earlier).

after>current.addQuery('run_time', '>', '11:00:00');

Run Time after 11:00:00

The output is all records where "Created at" contains time before "11:00:00" (at 11:01:01 and later).

at or before<=current.addQuery('run_time', '<=', '11:00:00');

Run Time at or before 11:00:00

The output is all records where "Run Time" contains "11:00:00" or time before it (10:59:59 and earlier).

at or after>=current.addQuery('run_time', '>=', '11:00:00');

Run Time at or after 11:00:00

The output is all records where "Created at" contains "11:00:00" or the time after it (11:01:01 and later).

betweenBETWEEN

current.addQuery('run_time', '>=', '10:00:00');

current.addQuery('run_time', '=<', '11:00:00');

Run Time between 10:00:00 (and) 11:00:00

The output is all records where "Run Time" contains time between 10:00:00 and 11:00:00.

containsLIKEcurrent.addQuery('run_time', 'like', '11');

Run Time contains 11

The output is all records where "Run Time" contains "11" anywhere in it (hour, minute, second).

does not containNOTLIKEcurrent.addQuery('run_time', 'notlike', ':11:');

Run Time does not contain :11:

The output is all records where "Run Time" contains any minutes value but 11.

is emptyISEMPTYcurrent.addQuery('run_time', 'isempty');

Run Time is empty

The output is all records where "Run Time" does not contain any value.

is not emptyISNOTEMPTYcurrent.addQuery('run_time', 'isnotempty');

Run Time is not empty

The output is all records where "Run Time" contains any value.

is sameSAMEAScurrent.addQuery('start_time', 'sameas', 'end_time');

Start Time is same End Time

The output is all records where "Start Time" and "End Time" have the same value.

is differentNSAMEAScurrent.addQuery('start_time', 'nsameas', 'end_time');

Start Time is different End Time

The output is all records where "Start Time" and "End Time" have different values.

hour isHOUR_IScurrent.addQuery('run_time', 'hour_is', '11');

Run Time hour is 11

The output is all records where "Run Time" contains the corresponding hour: the range is [11:00:00; 11:59:59].


Table of Contents
absoluteUrltrue
classfixedPosition