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.

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

In the System name table column, the system operator name is specified, 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.

To use the 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');

Active is Yes

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

is not!=

current.addQuery('active', '!=', true);

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

Active is not Yes

The output is all records where the Active field is not enabled (that is, this attribute value = '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).

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"

greater than>current.addQuery('state', '>', '3') // High

Priority is greater than High

The output is all records where "Priority" value is greater than High.

less than<current.addQuery('state', '<', '3') // High

Priority is less than High

The output is all records where "Priority" value is less than High.

greater than or is=>current.addQuery('state', '=>', '3') // High

Priority is greater than or equal to High

The output is all records where "Priority" value is greater than or equal to High.

less than or is<=current.addQuery('state', '<=', '3') // High

Priority is less than or equal to High

The output is all records where "Priority" value is less than or equal to High.

betweenBETWEEN

current.addQuery('state', 'between', '1', '3')

// between Low and High

Priority is between Low and High

The output is all records where "Priority" value is between Low and High (Critical priority is not included).

contains

LIKE

current.addQuery('state', 'like', 'publish');

State contains publish

The output is all records where "State" contains substring "publish" in choice title.

does not containNOTLIKEcurrent.addQuery('state', 'notlike', 'publish');

State does not contain publish

The output is all records where "State" does not contain these characters in choice title.

starts withSTARTSWITHcurrent.addQuery('state', 'startswith', 'publish');

State starts with publish

The output is all records where "State" contains these characters at the beginning of choice title.

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

State ends with ed

The output is all records where "State" contains these characters at the end of choice title.

is emptyISEMPTYcurrent.addQuery('state', 'isempty'); // None

State is empty

The output is all records where "State" does not contain any value (None).

is not emptyISNOTEMPTYcurrent.addQuery('state', 'isnotempty'); // not None

State is not empty

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

is sameSAMEAScurrent.addQuery('urgency', 'sameas', 'impact');

Urgency is same Impact

The output is all records where "Urgency " and "Impact" have the same value (both have Low, for example).

is differentNSAMEAScurrent.addQuery('urgency', 'nsameas', 'impact');

Urgency is different Impact

The output is all records where values of "Urgency" and "Impact" have different values (one has High and the other has Moderate, for example).

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

Urgency is anything 

The output is all records where the "Urgency" field has any value.

Date

Operator Display NameSystem nameScriptCondition Builder
onON

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

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

Expire at on 2019-01-01

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

not onNOTONcurrent.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-01');

Expire at before 2019-01-01

The output is all records where "Expire at" date before "2019-01-01".

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

Expire at after 2019-01-01

The output is all records where "Expire at" date after "2019-01-01".

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

Expire at at or before 2019-01-01

The output is all records where "Expire at" is "2019-01-01" or the date before it.

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

Expire at at or after 2019-01-01

The output is all records where "Expire at" is "2019-01-01" or the date after it.

betweenBETWEEN

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

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

The output is all records where "Expire at" contains a date between 2019-01-01 and 2019-01-31 including these dates.

contains

LIKE

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

Expire at contains 2019-01

The output is all records where database value (in UTC) of "Expire at" contains "2019-01" (for example, records that expire at 2019-01-23).

does not containNOTLIKEcurrent.addQuery('expired_at', 'notlike', '2019-01');

Expire at does not contain 2019-01

The output is all records where database value (in UTC) "Expire at" does not contain "2019-01" (for example, records that expire at 2019-02-01).

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

Expire at is empty

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

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

Expire at is not empty

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

is sameSAMEAScurrent.addQuery('expired_at', 'sameas', 'starts_at');

Expire at is same Starts at

The output is all records where "Expire at" and "Starts at" have the same date.

is differentNSAMEAScurrent.addQuery('expired_at', 'nsameas', 'starts_at');

Expire at is different Starts at

The output is all records where the "Expire at" 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_IScurrent.addQuery('expired_at', 'year_is', '2020');

Expire at year is 2020

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

month isMONTH_IScurrent.addQuery('expired_at', 'month_is', '9');

Expire at month is September

The output is all records where the database value (in UTC) of "Expire at" contains the corresponding 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_IScurrent.addQuery('expired_at', 'week_is', '32');

Expire at week is 32

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

day isDAY_IScurrent.addQuery('expired_at', 'day_is', '10');

Expire at day is 10

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

day of week isDAY_OF_WEEK_IScurrent.addQuery('expired_at', 'day_of_week_is', '1');

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

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

Operator Display NameSystem nameScriptCondition Builder
onON

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

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

Created at on 2019-01-01 03:00:00

The output is all records where "Created at" field value is "2019-01-01 03:00:00" exactly.

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

Created at not on 2019-01-01 03:00:00

The output is all records where "Created at" is any value but "2019-01-01 03:00:00".

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

Created at before 2019-01-01 02:59:59

The output is all records where "Created at" before datetime "2019-01-01 02:59:59".

after>current.addQuery('sys_created_at', '>', '2019-01-01 02:59:59');

Created at after 2019-01-01 02:59:59

The output is all records where "Created at" after datetime "2019-01-01 02:59:59".

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

Created at at or before 2019-01-01 03:00:00

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

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

Created at at or after 2019-11-01

The output is all records where "Created at" contains "2019-11-01" or the dateme after it.

betweenBETWEEN

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

Created at between 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-01-01 03:00:00 and 2019-01-02 02:59:59 including these datetimes.

contains

LIKE

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

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

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

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

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

Created at does not contain 2019-01-01 03:

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

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

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

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

is sameSAMEAScurrent.addQuery('sys_created_at', 'sameas', 'sys_updated_at');

Created at is same Updated at

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

is differentNSAMEAScurrent.addQuery('sys_created_at', 'nsameas', 'sys_updated_at');

Created at is different Updated at

The output is all records where "Created at" 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 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 year.

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

month isMONTH_IScurrent.addQuery('sys_created_at', 'month_is', '9');

Created at month is September

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

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

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

Created at quarter is II

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

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

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

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

day isDAY_IScurrent.addQuery('sys_created_at', 'day_is', '32');

Created 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).

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

day of week isDAY_OF_WEEK_IScurrent.addQuery('sys_created_at', 'day_of_week_is', '1');

Created at day of the week is Monday

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

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

hour isHOUR_IScurrent.addQuery('sys_created_at', 'hour_is', '10');

Created at hour is 10

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

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


Document ID

Operator Display NameSystem nameScriptCondition Builder
is=current.addQuery('item', '0229fa8abcbe1f530255bff6baf40b91');

Item is TSK0000001 My task 1

The output is all records where the value of "Item" field is "TSK0000001 My task 1".

is not!=current.addQuery('item', '!=', '0229fa8abcbe1f530255bff6baf40b91')

Item is not TSK0000001 My task 1

The output is all records where the value of the "Item" field is not "TSK0000001 My task 1".

is one ofINcurrent.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.

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

Example
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"}

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

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

Data is anything 

The output is all records 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

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.

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.

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, 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('max_length', '!=', 10);

Max Length is not 10

The output is all records where "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.

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

does not containsNOTLIKEcurrent.addQuery('serial_number', 'notlike', 99);

Serial Number does not contains 99

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

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

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

Max Length is one of 10, 32

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

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

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

The output is all records where "Max Length" is not "10" and is not "32".

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" 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" 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" 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" 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" 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" 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" have 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 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 Errors, Article

The output is all records where "Table" field 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" and is not "Article".

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.

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.

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 empty value is suitable).

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

Caller is anything 

The output is all records where "Caller" 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 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 the value of "Table" field is "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 is not "User" and is not "Employee".

The is not one of operator 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.

Please note that the operator is case insensitive.

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

Email does not contain _

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

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.

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.

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.

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

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.

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.

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

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

  • No labels

© 2019-2023, SimpleOne

https://simpleone.ru