Versions Compared

Old Version 47

changes.mady.by.user Aleksandr Zhulanov

Saved on

compared with

New Version Current

changes.mady.by.user Dina Baksheeva

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Merged branch "DOC0000371" 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  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).

is anythingANYTHINGcurrent.addQuery('active', 'anything');

Active is anything 

The output is all records where "Active" has any value (Yes or No).

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', '
isnotempty
like', '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 Operator Display NameSystem nameScriptCondition BuilderonON

"

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 withENDSWITH
current.addQuery('
expired_at
state', 'endswith', '
2019-01-01
ed');
Expire at on 2019-01-01

State ends with ed

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');

Expire at not on 2019-01-01

The
isempty'); // 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 sameSAMEAS
>
current.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 differentNSAMEAScurrent.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.at or after

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

is anythingANYTHING
>=
current.addQuery('
expired_at
urgency', '
>=', '2019-01-01
anything');
Expire at at or after 2019-01-01

Urgency is anything 

The output is all records where the "

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

Urgency" field has any value.

Date

Operator Display NameSystem nameScriptCondition Builder
onON
betweenBETWEEN

current.addQuery('expired_at', '

>=', '

2019-01-01');

current.addQuery('expired_at', '

<

=', '2019-01-

31

01');

Expire at 

between

on 2019-01-01

(and) 2019-01-31

The output is all records where "Expire at

" contains a date between 2019

" field value is "2019-01-01

and 2019-01-31 including these dates.

" exactly.

not onNOTON
containsLIKE
current.addQuery('expired_at', '
like
!=', '2019-01-01');

Expire

at contains 2019

at not on 2019-01-01

The output is all records where

database value (in UTC) of

"Expire at"

contains

is any value but "2019-01

" (for example, records that expire at 2019

-01

-23)

".

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

Expire at

does not contain

before 2019-01-01

The output is all records where

database value (in UTC)

"Expire at"

does not contain 

date before "2019-01

" (for example, records that expire at 2019-02

-01

)

".

is empty
after
ISEMPTY
>current.addQuery('expired_at', '>'
isempty');
, '2019-01-01');

Expire at

is empty

after 2019-01-01

The output is all records where "Expire at"

does not contain any value.

date after "2019-01-01".

at or before<=
is not emptyISNOTEMPTY
current.addQuery('expired_at', '
isnotempty
<=', '2019-01-01');

Expire

at is not empty

at at or before 2019-01-01

The output is all records where "Expire at

" contains any value.is same

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

at or after>=
SAMEAS
current.addQuery('expired_at', '
sameas
>=', '
starts_at
2019-01-01');

Expire

at is same Starts at

at at or after 2019-01-01

The output is all

records where

records where "Expire at"

and "Starts at" have the same date.

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

betweenBETWEEN
is differentNSAMEAS

current.addQuery('

expired

sys_created_at', '

nsameas

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

starts_at

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

Expire at 

is different Starts at

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

The output is all records where "Expire at"

and "Starts at" have different

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

year is
contains

LIKE

YEAR_IS

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

Expire

at year is 2020

at contains 2019-01

The output is all records where

the

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

the corresponding year.month is

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

does not containNOTLIKE
MONTH_IS
current.addQuery('expired_at', '
month_is
notlike', '
9
2019-01');

Expire at

month is September

does not contain 2019-01

The output is all records where

the

database value (in UTC)

of

"Expire at"

contains the corresponding month.quarter is

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

is emptyISEMPTY
QUARTER_IS
current.addQuery('expired_at', '
quarter_is', '2'
isempty');

Expire at

quarter is II

is empty

The output is all records where

the database value (in UTC) of

"Expire at"

contains the corresponding quarter

does not contain any value.

week
is not empty
WEEK_IS
ISNOTEMPTYcurrent.addQuery('expired_at', '
week_is', '32'
isnotempty');

Expire at

week is 32

is not empty

The output is all records where

the database value (in UTC) of

"Expire at" contains

the corresponding week

any value.

day
is same
DAY_IS
SAMEAScurrent.addQuery('expired_at', '
day_is
sameas', '
10
starts_at');

Expire at is same Starts at

day is 10

The output is all

records where the database value (in UTC) of

records where "Expire at"

contains the corresponding day of a month (10th day of any month).

and "Starts at" have the same date.

is differentNSAMEAS
day of week isDAY_OF_WEEK_IS
current.addQuery('expired_at', '
day_of_week_is
nsameas', '
1
starts_at');

Expire

at day of the week is Monday

at is different Starts at

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

value is different to the "Starts at" one.

is anythingANYTHINGcurrent.addQuery('expire_at', 'anything');

Expire at is anything 

The output is all records where the "Expire at" field contains any value.

year isYEAR_IS
current.addQuery('
sys_created_at
expired_at', 'year_is', '
2019-01-01 03:00:00
2020');
Created at on 2019-01-01 03:00:00

Expire at year is 2020

The output is all records where

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

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

month isMONTH_IScurrent.addQuery('
sys
expired_
created_
at', '
!=
month_is', '
2019-01-01 03:00:00
9');
Created at not on 2019-01-01 03:00:00

Expire at month is September

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 month.

quarter isQUARTER_IS
<
current.addQuery('
sys_created
expired_at', '
<
quarter_is', '
2019-01-01 02:59:59
2');
Created at before 2019-01-01 02:59:59

Expire at quarter is II

The output is all records where

"Created at" before datetime "2019-01-01 02:59:59".after

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

week isWEEK_IS
>
current.addQuery('
sys_created
expired_at', '
>
week_is', '
2019-01-01 02:59:59
32');
Created at after 2019-01-01 02:59:59

Expire at week is 32

The output is all records where

"Created at" after datetime "2019-01-01 02:59:59".at or before

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

day isDAY_IS
<=
current.addQuery('
sys
expired_
created_
at', '
<=
day_is', '
2019-01-01 03:00:00
10');
Created at at or before 2019-01-01 03:00:00

Expire at day is 10

The output is all records where

"Created at" is "2019-01-01 03:00:00" or the datetime before it.at or after>=

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_IScurrent.addQuery('
sys
expired_
created_
at', '
>=
day_of_week_is', '
2019-01-01 03:00:00
1');
Created at at or after 2019-11-01

Expire at day of the week is Monday

The output is all records where

"Created

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


"2019-11-01" or the dateme after it.containsLIKEYEAR_ISMONTH_ISQUARTER_ISDAY_ISDAY_OF_WEEK_IS
Operator Display NameSystem nameScriptCondition Builder
onON

current.

betweenBETWEEN

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

current.addQuery('sys_created_at', '<=', '2019-01-02 0201 03:5900:5900');

Created at betweenat on 2019-01-01 03:00:00 (and) 2019-01-02 02:59:59

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

not onNOTONcurrent.addQuery('sys_created_at', 'like!=', '2019-01-01 03:4400:00');

Created

at contains 2019

at not on 2019-01-

01 03

01 03:

44

00:00

The output is all records where

database value (in UTC) of

"Created at"

contains

is any value but "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".

before<current.addQuery('sys_created_at', 'notlike<', '2019-01-01 0302:59:59');

Created at

does not contain

before 2019-01-01

03

02:59:59

The output is all records where

database value (in UTC)

"Created at"

does not contain 

before datetime "2019-01-01

03

02:

44

59:

" (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.

59".

after>is emptyISEMPTYcurrent.addQuery('closedsys_created_at', '>', 'isempty2019-01-01 02:59:59');

Closed at is emptyCreated at after 2019-01-01 02:59:59

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

is not empty

Created at" after datetime "2019-01-01 02:59:59".

at or before<=ISNOTEMPTYcurrent.addQuery('closedsys_created_at', '<=', 'isnotempty2019-01-01 03:00:00');

Closed at is not emptyCreated at at or before 2019-01-01 03:00:00

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

at or after>=is sameSAMEAScurrent.addQuery('sys_created_at', 'sameas>=', 'sys_updated_at2019-01-01 03:00:00');

Created at is same Updated atat at or after 2019-11-01

The output is all records where records where "Created at" and "Updated at" have the same value.

is different

contains "2019-11-01" or the dateme after it.

betweenBETWEENNSAMEAS

current.addQuery('sys_created_at', '

nsameas', 'sys_updated_at

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

Created at is different Updated atbetween 2019-01-01 03:00:00 (and) 2019-01-02 02:59:59

The output is all records where "Created at" and "Updated at" have different values.

year is

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

contains

LIKE

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

Created at year is 2019at contains 2019-01-01 03:44:

The output is all records where the database value (in UTC) of "Created at" contains the corresponding year"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


does not containNOTLIKEcurrent.addQuery('sys_created_at', 'month_isnotlike', '9'2019-01-01 03:');

Created at month is September does not contain 2019-01-01 03:

The output is all records where the database value (in UTC) of "Created at" contains the corresponding monthdoes 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.

quarter


is emptyISEMPTYcurrent.addQuery('sys_createdclosed_at', 'quarter_is', '2'isempty');Created

Closed at

quarter is II

is empty

The output is all records where

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_IS

"Closed at" does not contain any value.

is not emptyISNOTEMPTYcurrent.addQuery('sys_createdclosed_at', 'week_is', '32'isnotempty');Created at week is 32

Closed at is not empty

The output is all records where

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 is

"Closed at" contains any value.

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

Created at

day is 10

is same Updated at

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.

day of week is

records where "Created at" and "Updated at" have the same value.

is differentNSAMEAScurrent.addQuery('sys_created_at', 'day_of_week_isnsameas', '1sys_updated_at');

Created

at day of the week is Monday

at is different Updated at

The output is all records where

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.

" and "Updated at" have different values.

is anythingANYTHINGcurrent.addQuery('sys_created_at', 'anything');

Created at is anything 

The output is all records where "Created at" has any value.

year isYEARhour isHOUR_IScurrent.addQuery('sys_created_at', 'houryear_is', '102019');

Created at hour is 10 year is 2019

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

Note

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

Fieldname

ENDSWITH


month isMONTH_IS
Operator Display NameSystem nameScriptCondition Builder
containsLIKEcurrent.addQuery('columnsys_created_idat', 'likemonth_is', 'typ9');Column contains typ

Created at month is September

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 month.

Note

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


quarter isQUARTER_ISNOTLIKEcurrent.addQuery('columnsys_created_idat', 'notlikequarter_is', 'typ2');Column does not contain typ

Created at quarter is II

The output is all records where

"Column" display value does not contain "typ".		starts withSTARTSWITHcurrent.addQuery('column_id', 'startswith', 'typ');

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_IScurrent.addQuery('sys_created_at', 'week_is', '32');

Created at week is 32

Column starts with typ

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 week.

Note

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


day isDAY_IScurrent.addQuery('columnsys_created_idat', 'endswithday_is', 'typ32');Column ends with typ

Created at day is 10

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 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_ISISEMPTYcurrent.addQuery('column_id'sys_created_at', 'day_of_week_is', 'isempty1');Column is empty

Created at day of the week is Monday

The output is all records where

"Column" does not contain any value.		is not 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_ISISNOTEMPTYcurrent.addQuery('column_idsys_created_at', 'hour_is', 'isnotempty10');Column is not empty

Created at hour is 10

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');JSON Copy contains "url": null
0229fa8abcbe1f530255bff6baf40b91');

Item is TSK0000001 My task 1

The output is all records where the value of "

JSON Copy" display value contains "url": null.does not contain

Item" field is "TSK0000001 My task 1".

is not!=
NOTLIKE
current.addQuery('
json_copy
item', '
notlike
!=', '
"url": null
0229fa8abcbe1f530255bff6baf40b91')
;
JSON Copy does not contain "url": null

Item is not TSK0000001 My task 1

The output is all records where

"JSON Copy" display value does not contain ""url": null

the value of the "Item" field is not "TSK0000001 My task 1".

is one of
=
INcurrent.addQuery('item', 'in', ['0229fa8abcbe1f530255bff70874ca7e',
'0229fa8abcbe1f530255bff6baf40b91']);

The is one of operator is not available for Document ID fields in the Condition Builder. Instead, use the combination of is OR is as in the example below:

Item is TSK0000005 Verification OR Item is TSK0000001 My task 1

is not one ofNOT INcurrent.addQuery('item', 'not in', ['0229fa8abcbe1f530255bff70874ca7e',
'0229fa8abcbe1f530255bff6baf40b91']);

The is not one of operator is not available for Document ID fields in the Condition Builder. Instead, use the combination of is not AND is not as in the example below:

Item is not TSK0000005 Verification AND Item is not TSK0000001 My task 1

containsLIKEcurrent.addQuery('item', 'like', '0229fa8a-bcbe-1f53');

Item contains 0229fa8a-bcbe-1f53

The output is all records where the value of the "Item" field contains "0229fa8a-bcbe-1f53". In the "Item" field, records from the Task (task) table are specified.

Code Block
languagejs
themeEclipse
titleExample
linenumberstrue
const tableName = 'task';
const table = new SimpleRecord('sys_db_table');
table.get('name', tableName);
const uuidExample = ss.getDocIdByIds(table.sys_id, '0');
const re = /(.{8})(.{4})(.{4})/;
const uuidFirstHalf = uuidExample.slice(0, 16).replace(re, '$1-$2-$3');
ss.info(uuidFirstHalf);
// Info: 0229fa8a-bcbe-1f53


does not containNOTLIKErecord.addQuery('item', 'notlike', '0229fa8a-bcbe-1f53');

Item does not contain 0229fa8a-bcbe-1f53

The output is all records where the value of the "Item" field does not contain "0229fa8a-bcbe-1f53". The "Item" field does not contain records from the Task (task) table.

Code Block
languagejs
themeEclipse
titleExample
linenumberstrue
const tableName = 'task';
const table = new SimpleRecord('sys_db_table');
table.get('name', tableName);
const uuidExample = ss.getDocIdByIds(table.sys_id, '0');
const re = /(.{8})(.{4})(.{4})/;
const uuidFirstHalf = uuidExample.slice(0, 16).replace(re, '$1-$2-$3');
ss.info(uuidFirstHalf);
// Info: 0229fa8a-bcbe-1f53


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

Document Record is empty

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

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

Document Record is empty

The output is all records where the value of the "Document Record" field 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 the display value of "Column" contains "typ".

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

Column does not contain typ

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

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

Column starts with typ

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

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

Column ends with typ

The output is all records where the display value of "Column" 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" contains 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

The output is all records where "JSON Copy" display value does not contain ""url": null".

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

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

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 CopyData" field value is exactly this input.

is not!=current.addQuery('json_copydata', '!=', relatedRecord.json_copy);JSON Copy is not {"value": "Asia/Manila", "policy": "Open", "sys'{"user_id": "john.doe", "email": "john.doe@example.com"}');

Data is not {"user_id": "john.doe", "email": "john.doe@example.com" 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 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 differentdifferentNSAMEAScurrent.addQuery('diplayable_path', 'nsameas', 'formatter');

Displayable Path is different Formatter

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

is anythingANYTHINGNSAMEAScurrent.addQuery('diplayable_pathdata', 'nsameas', 'formatteranything');

Displayable Path is different FormatterData is anything 

The output is all values where "Displayable Path" and "Formatter" have different valuesrecords where the "Data" fileld has any value.

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

contains CONTAINSDOESNOTCONTAIN_DYNAMIC
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." 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', 'containsdoesnotcontain_dynamic', '160516373014385744');

Followers contains does not contain (dynamic) Me

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

does not contain (dynamic)

is not right because the sequence is taken into account. 


Big Integer, Integer, Small Integer, Decimal, Float, Percent Complete, 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" is 10.

is not!=current.addQuery('
followers
max_length', '
doesnotcontain_dynamic
!=',
'160516373014385744'
10);
Followers does not contain (dynamic) Me

Max Length is not 10

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

Max Length" is not 10.

containsLIKEcurrent.addQuery('serial_number', 'like', 99);

Serial Number contains 99

The output is all records where "Serial Number" contains 99.

Info

The contains operator is not available for numeric fields in the Condition Builder. It is used for filtering in scripts. 


does not containsNOTLIKE
Operator Display NameSystem nameScriptCondition Builder
is=current.addQuery('max_lengthserial_number', 'notlike', 1099);

Serial Number does not contains 99

The output is all records where "Serial Number" does not contain 99.

Info

The does not contains operator is not available for numeric fields in the Condition Builder. It is used for filtering in scripts. 


is one ofIN

Max Length is 10

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

is not!=current.addQuery('max_length', '!=in', [10, 32]);

Max Length is

not 

one of 10, 32

The output is all records where "Max Length" is "

contains any value but 10.

10" or "32".

Note

The values in the input field should be comma-separated or separated by line break. Spaces are not allowed.


is not is one ofNOT INcurrent.addQuery('max_length', 'not in', [10, 32]);

Max Length is one of 10,32

The output is all records where "Max Length"

contains

is not "10

" or

" and is not "32".

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

The is not one of operator is not available for numeric fields in the Condition Builder. It is used for filtering in scripts. 


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

Max Length less than 255

The output is all records where "Max Length" contains value is 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 is 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 is 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 is 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 have 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 valueshave different values.

is anythingANYTHINGcurrent.addQuery('max_length', 'anything');

Max Length is anything 

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

greater than fieldGT_FIELDcurrent.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 nor 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 of Known Errors, Article

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

is not one ofNOT INcurrent.addQuery('table_id', 'not in', ['155964310500000291', '160456341213536956']);

Table is not one of Known Errors, Article

The output is all records where "Table" is not "Known Errors"

or

and is not "Article".

Info

The is not one of operator is not available for Reference fields in the Condition Builder. It is used for filtering in scripts. 


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

not

configured to On delete =

Set NULL

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

not

configured to On delete =

Set NULL

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', 'nsameasassigned_user');

Caller is different Assigned User

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

is anythingANYTHINGcurrent.addQuery('caller', 'assigned_useranything');

Caller is different Assigned UserCaller is anything 

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

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 the value of "Table" field 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 where the value of "Table" field value is any table but "User" or "Employee".

is not one ofNOT INcurrent.addQuery('sys_db_table_id', 'not in', ['155931135900000084', '156873090301469473']);

Table is not one of Users, Employee

The output is all records where the value of "Table" field

value

is not "User"

or

and is not "Employee".

Info

The is not one ofoperator is not available for Record Class fields in the Condition Builder. It is used for filtering in scripts. 


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.

Info

Please note that the operator is case insensitive.


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

Email does not contain

 ov

_

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

Info

Please note that the operator is case insensitive.


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.

Info

Please note that the operator is case insensitive.


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.

Info

Please note that the operator is case insensitive.


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

Last Name is Ivanov

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

Info

Please note that the operator is case sensitive.


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".

Info

Please note that the operator is case sensitive.


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.

Info

Please note that the operator is case sensitive.


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.

Info

Please note that the operator is case sensitive.


is anythingANYTHINGcurrent.addQuery('display_name', 'anything');

Display Name is anything 

The output is all records where "Display Name" has any value.

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