Condition Operators
The tables below provide information about the available condition operators for specific column types.
Each section contains the following information:
- System name – contains the system operator name that is used in condition strings or scripts.
- Column type – contains all column types to which the operator can be applied. When calling a column using dot-walking, the available operators correspond to the column type specified at the end. For example, when you call followers.language, where the Followers column is a list and Languages is a reference field, you can only use the operators available for the reference fields.
- Script – contains the example of the script.
- Condition builder – contains the condition and its result.
tip
- The input data for Date/Time fields must have the following format: YYYY-MM-DD hh:mm:ss.
- In scripts and JS injections, conditions for Time fields require the input time in UTC.
Summary table Operator – System name
The table below contains the list of available operators with their system names. Use it for quick search.
| Operator | System name |
|---|---|
| is | = |
| is not | != |
| is same | SAMEAS |
| is anything | ANYTHING |
| is different | NSAMEAS |
| is one of | IN |
| is not one of | NOT IN |
| greater than | > |
| less than | < |
| greater than or is | >= |
| less than or is | <= |
| greater than field | GT_FIELD |
| less than field | LT_FIELD |
| greater than or is field | GT_OR_EQUALS_FIELD |
| less than or is field | LT_OR_EQUALS_FIELD |
| between | BETWEEN |
| contains | LIKE |
| does not contain | NOTLIKE |
| starts with | STARTSWITH |
| ends with | ENDSWITH |
| is empty | ISEMPTY |
| is not empty | ISNOTEMPTY |
| on | ON |
| not on | NOTON |
| before | < |
| after | > |
| at or before | <= |
| at or after | >= |
| year is | YEAR_IS |
| month is | MONTH_IS |
| quarter is | QUARTER_IS |
| week is | WEEK_IS |
| day is | DAY_IS |
| day of week is | DAY_OF_WEEK_IS |
| hour is | HOUR_IS |
| are | ARE |
| has | HAS |
| has not | HASNOT |
| contains (dynamic) | CONTAINS_DYNAMIC |
| does not contain (dynamic) | DOESNOTCONTAIN_DYNAMIC |
| is (dynamic) | DYNAMIC |
| is not (dynamic) | ISNOT_DYNAMIC |
| changes | VALCHANGES |
| changes from | CHANGESFROM |
| changes to | CHANGESTO |
List of operators
is
The operator is case insensitive.
System name: =
| Column type | Script | Condition builder | Output |
|---|---|---|---|
| True/False | current.addQuery('active', true); or current.addQuery('active', '1'); | Active is Yes | All records where the Active field value is Yes only (the attribute value = true). |
| Choice | current.addQuery('state', '2'); // In progress | State is In progress | All records where the State field value is In progress only. |
| Document ID | current.addQuery('item', '0229fa8abcbe1f530255bff6baf40b91'); | Item is TSK0000001 Create a report | All records where the value of Item is "TSK0000001 Create a report". |
| JSON | current.addQuery('data', '{"user_id": "john.doe", "email": "john.doe@example.com"}'); | Data is {"user_id": "john.doe", "email": "john.doe@example.com"} | All records where the Data value is exactly as in the input. |
| List | current.addQuery('categories', '155988310508800001'); | Categories is Article | All records where Categories contains only the reference to the Article table. |
| Big Integer | current.addQuery('size_bytes', '100'); | Size bytes is 100 | All records where the Size bytes value is 100. |
| Integer | current.addQuery('order', '7'); | Order is 7 | All records where the Order value is 7. |
| Small Integer | current.addQuery('utc_offset', '3'); | UTC offset is 3 | All records where the UTC offset value is 3. |
| Decimal | current.addQuery('memory_usage', '12'); | Memory usage is 12 | All records where the Memory usage value is 12. |
| Float | current.addQuery('processing_time', '0.3'); | Processing time is 0.3 | All records where the Processing time value is 0.3. |
| Percent Completed | current.addQuery('threshold_exceedance', '35'); | Columns with the Percent Completed type cannot be selected in the condition builder. You can filter by these columns using the script. | All records where the Threshold exceedance value is 35. |
| Duration | current.addQuery('minimum_duration', '360000'); | Minimum duration is 360000 | All records where the Minimum duration is 360000 (= 6 minute). |
| Reference | current.addQuery('caller', '160624751417596911'); | Caller is John Doe | All records where the Caller value is only John Doe. |
| Record Class | current.addQuery('sys_db_table_id', '155931135900000084'); | Table is Users | All records where Table is User. |
| Phone | current.addQuery('mobile_phone', '+79123455678'); | Mobile phone is +79123455678 | All records where the Mobile phone value is +79123455678. |
| String | current.addQuery('first_name', 'John'); | First name is John | All records where the First name value is John. |
| Text | current.addQuery('description', 'To connect new equipment'); | Description is To connect new equipment | All records where the value of Description is "To connect new equipment". |
| Translated Text | current.addQuery('title', 'Problem'); | Title is Problem | All records where the Title value is Problem. |
| Conditions | current.addQuery('completion_conditions', 'state=7'); | Completion conditions is state=7 | All records where the Completion conditions value is state=7 (State = Completed). |
| URL | current.addQuery('website', 'simpleone.ru'); | Website is simpleone.ru | All records where the Website value is "simpleone.ru". |
is not
The operator is case insensitive.
System name: !=
| Column type | Script | Condition builder | Output |
|---|---|---|---|
| True/False | current.addQuery('active', '!=', true); or current.addQuery('active', '!=', '1'); | Active is not Yes | All records where the Active field value is not Yes only (the attribute value = true). |
| Choice | current.addQuery('state', '!=', '2'); // In progress | State is not In progress | All records where the State field value is not In progress. |
| Document ID | current.addQuery('item', '!=' '0229fa8abcbe1f530255bff6baf40b91'); | Item is not TSK0000001 Create a report | All records where the value of Item is not "TSK0000001 Create a report". |
| JSON | current.addQuery('data', '!=', '{"user_id": "john.doe", "email": "john.doe@example.com"}'); | Data is not {"user_id": "john.doe", "email": "john.doe@example.com"} | All records where the Data value is not exactly as in the input. |
| List | current.addQuery('categories', '!=', '155988310508800001'); | Categories is not Article | All records where Categories does not contain the reference to the Article table. |
| Big Integer | current.addQuery('size_bytes', '!=', '100'); | Size bytes is not 100 | All records where the Size bytes value is not 100. |
| Integer | current.addQuery('order', '!=', '7'); | Order is not 7 | All records where the Order value is not 7. |
| Small Integer | current.addQuery('utc_offset', '!=', '3'); | UTC offset is not 3 | All records where the UTC offset value is not 3. |
| Decimal | current.addQuery('memory_usage', '!=', '12'); | Memory usage is not 12 | All records where the Memory usage value is not 12. |
| Float | current.addQuery('processing_time', '!=', '0.3'); | Processing time is not 0.3 | All records where the Processing time value is not 0.3. |
| Percent Completed | current.addQuery('threshold_exceedance', '!=', '35'); | Columns with the Percent Completed type cannot be selected in the condition builder. You can filter by these columns using the script. | All records where the Threshold exceedance value is not 35. |
| Duration | current.addQuery('minimum_duration', '360000'); | Minimum duration is not 360000 | All records where the Minimum duration is 360000 (= 6 minute). |
| Reference | current.addQuery('caller', '!=', '160624751417596911'); | Caller is not John Doe | All records where the Caller value is not John Doe. |
| Record Class | current.addQuery('sys_db_table_id', '!=','155931135900000084'); | Table is not Users | All records where Table is not User. |
| Phone | current.addQuery('mobile_phone', '!=', '+79123455678'); | Mobile phone is not +79123455678 | All records where the Mobile phone value is not +79123455678. |
| String | current.addQuery('first_name', '!=', 'John'); | First name is not John | All records where the First name value is not John. |
| Text | current.addQuery('description', '!=', 'To connect new equipment'); | Description is not To connect new equipment | All records where the value of Description is not "To connect new equipment". |
| Translated Text | current.addQuery('title', '!=', 'Problem'); | Title is not Problem | All records where the Title value is not Problem. |
| Conditions | current.addQuery('completion_conditions', '!=', 'state=7'); | Completion conditions is not state=7 | All records where the Completion conditions value is not state=7 (State = Completed). |
| URL | current.addQuery('website', '!=', 'simpleone.ru'); | Website is not simpleone.ru | All records where the Website value is not "simpleone.ru". |
is same
The operator is case insensitive.
System name: SAMEAS
| Column type | Script | Condition builder | Output |
|---|---|---|---|
| True/False | current.addQuery('active', 'sameas', 'published'); | Active is same Published | All records where Active and Published have the same value (both are true or false). |
| Choice | current.addQuery('urgency', 'sameas', 'impact'); | Urgency is same Impact | All records where Urgency and Impact have the same value (both have Low, for example). |
| Date | current.addQuery('expired_at', 'sameas', 'starts_at'); | Expire at is same Starts at | All records where Expire at and Starts at have the same date. |
| Date/Time | current.addQuery('sys_created_at', 'sameas', 'sys_updated_at'); | Created at is same Updated at | All records where Created at and Updated at have the same value. |
| JSON | current.addQuery('displayable_path', 'sameas', 'formatter'); | JSON copy is same Composite key | all values where JSON copy and Composite key have the same values. |
| Reference | current.addQuery('caller', 'sameas', 'assigned_user'); | Caller is same Assigned user | All records where Caller and Assigned user have the same reference (empty values are suitable). |
| Big Integer | current.addQuery('taskpd', 'sameas', 'completed_tasks'); | Tasks per day is same Completed tasks | All records where the field value of Tasks per day and Completed tasks fields have the same value. |
| Integer | current.addQuery('service_life', 'sameas', 'warranty'); | Service life is same Warranty | All records where the Service life and Warranty fields have the same value. |
| Small Integer | current.addQuery('order', 'sameas', 'nested_level'); | Order is same Nested level | All records where the Order and Nested level fields have the same value. |
| Decimal | current.addQuery('input_voltage', 'sameas', 'output_tension'); | Input voltage is same Output tension | All records where the Input voltage and Output tension fields have the same value. |
| Float | current.addQuery('weight', 'sameas', 'height'); | Weight is same Height | All records where the Weight and Height fields have the same value. |
| Percent Completed | current.addQuery('ssd', 'sameas', 'hdd'); | All records where the SSD and HDD fields have the same value. | Columns with the Percent Completed type cannot be selected in the condition builder. You can filter by these columns using the script. |
| Duration | current.addQuery('minimum_duration', 'sameas', 'duration'); | Minimum duration is same Duration | All records where the Minimum duration and Duration fields have the same value. |
| Phone | current.addQuery('business_phone', 'sameas', 'mobile_phone'); | Business phone is same Mobile phone | All records where the Business phone and Mobile phone fields have the same value. |
| String | current.addQuery('display_name', 'sameas', 'number'); | Display name is same Number | All records where Display name and Number fields have the same value. |
| Text | current.addQuery('description', 'sameas', 'comments'); | Description is same Comments | All records where Description and Comments fields have the same value. |
| Translated Text | current.addQuery('title', 'sameas', 'portal_title'); | Title is same Portal title | All records where Title and Portal title fields have the same value. |
| Conditions | current.addQuery('pause_conditions', 'sameas', 'cancel_conditions'); | Pause conditions is same Cancel conditions | All records where Pause conditions and Cancel conditions fields have the same value. |
| URL | current.addQuery('redirect_url', 'sameas', 'path_url'); | Redirect URL is same Path URL | All records where Redirect URL and Path URL fields have the same value. |
is anything
System name: ANYTHING
| Column type | Script | Condition builder | Output |
|---|---|---|---|
| True/False | current.addQuery('active', 'anything'); | Active is anything | All records where Active has any value (true or false). |
| Choice | current.addQuery('urgency', 'anything'); | Urgency is anything | All records where the Urgency field has any value. |
| Date | current.addQuery('expire_at', 'anything'); | Expire at is anything | All records where the Expire at field contains any value. |
| Date/Time | current.addQuery('sys_created_at', 'anything'); | Created at is anything | All records where Created at has any value. |
| JSON | current.addQuery('data', 'anything'); | Data is anything | All records where the Data field has any value. |
| Reference | current.addQuery('caller', 'anything'); | Caller is anything | All records where Caller has any value. |
| Big Integer | current.addQuery('taskpd', 'anything'); | Tasks per day is anything | All records where the Tasks per day field has any value. |
| Integer | current.addQuery('service_life', 'anything'); | Service life is anything | All records where the Service life field has any value. |
| Small Integer | current.addQuery('order', 'anything'); | Order is anything | All records where the Order field has any value. |
| Decimal | current.addQuery('input_voltage', 'anything'); | Input voltage is anything | All records where the Input voltage field has any value. |
| Float | current.addQuery('weight', 'anything'); | Weight is anything | All records where the Weight field has any value. |
| Percent Completed | current.addQuery('ssd', 'anything'); | Columns with the Percent Completed type cannot be selected in the condition builder. You can filter by these columns using the script. | All records where the SSD field has any value. |
| Duration | current.addQuery('minimum_duration', 'anything'); | Minimum duration is anything | All records where the Minimum duration field has any value. |
| Phone | current.addQuery('business_phone', 'anything'); | Business phone is anything | All records where the Business phone field has any value. |
| String | current.addQuery('display_name', 'anything'); | Display name is anything | All records where Display name field has any value. |
| Text | current.addQuery('description', 'anything'); | Description is anything | All records where Description field has any value. |
| Translated Text | current.addQuery('title', 'anything'); | Title is anything | All records where Title and Portal title field has any value. |
| Conditions | current.addQuery('pause_conditions', 'anything'); | Pause conditions is anything | All records where Pause conditions field has any value. |
| URL | current.addQuery('redirect_url', 'anything'); | Redirect URL is anything | All records where Redirect URL field has any value. |
is different
The operator is case insensitive.
System name: NSAMEAS
| Column type | Script | Condition builder | Output |
|---|---|---|---|
| True/False | current.addQuery('active', 'nsameas', 'published'); | Active is different Published | All records where Active and Published have different values (one is true and the other one is false, or vice versa). |
| Choice | current.addQuery('urgency', 'nsameas', 'impact'); | Urgency is different Impact | All records where values of Urgency and Impact have different values (one has High and the other has Moderate, for example). |
| Date | current.addQuery('expired_at', 'nsameas', 'starts_at'); | Expire at is different Starts at | All records where the Expire at value is different to the Starts at one. |
| Date/Time | current.addQuery('sys_created_at', 'nsameas', 'sys_updated_at'); | Created at is different Updated at | All records where Created at and Updated at have different values. |
| JSON | current.addQuery('json_copy', 'nsameas', 'composite_key'); | JSON copy is different Composite key | all values where JSON copy and Composite key have different values. |
| Reference | current.addQuery('caller', 'nsameas', 'assigned_user'); | Caller is different Assigned user | All records where Caller and Assigned user have different reference (one empty values). |
| Big Integer | current.addQuery('taskpd', 'nsameas', 'completed_tasks'); | Tasks per day is different Completed tasks | All records where the field value of Tasks per day and Completed tasks fields have different values. |
| Integer | current.addQuery('service_life', 'nsameas', 'warranty'); | Service life is different Warranty | All records where the Service life and Warranty fields have different values. |
| Small Integer | current.addQuery('order', 'nsameas', 'nested_level'); | Order is different Nested level | All records where the Order and Nested level fields have different values. |
| Decimal | current.addQuery('input_voltage', 'nsameas', 'output_tension'); | Input voltage is different Output tension | All records where the Input voltage and Output tension fields have different values. |
| Float | current.addQuery('weight', 'nsameas', 'height'); | Weight is different Height | All records where the Weight and Height fields have different values. |
| Percent Completed | current.addQuery('ssd', 'nsameas', 'hdd'); | Columns with the Percent Completed type cannot be selected in the condition builder. You can filter by these columns using the script. | All records where the SSD and HDD fields have different values. |
| Duration | current.addQuery('minimum_duration', 'nsameas', 'duration'); | Minimum duration is different Duration | All records where the Minimum duration and Duration fields have different values. |
| Phone | current.addQuery('business_phone', 'nsameas', 'mobile_phone'); | Business phone is different Mobile phone | All records where the Business phone and Mobile phone fields have different values. |
| String | current.addQuery('display_name', 'nsameas', 'number'); | Display name is different Number | All records where Display name and Number fields have different values. |
| Text | current.addQuery('description', 'nsameas', 'comments'); | Description is different Comments | All records where Description and Comments fields have different values. |
| Translated Text | current.addQuery('title', 'nsameas', 'portal_title'); | Title is different Portal title | All records where Title and Portal title fields have different values. |
| Conditions | current.addQuery('pause_conditions', 'nsameas', 'cancel_conditions'); | Pause conditions is different Cancel conditions | All records where Pause conditions and Cancel conditions fields have different values. |
| URL | current.addQuery('redirect_url', 'nsameas', 'path_url'); | Redirect URL is different Path URL | All records where Redirect URL and Path URL fields have different values. |
is one of
caution
In the condition builder, the values in the input field should be comma-separated or separated by the line break. Spaces are not allowed.
System name: IN
| Column type | Script | Condition builder | Output |
|---|---|---|---|
| Choice | current.addQuery('priority', 'in', ['2', '3']); // High OR Moderate | Priority is one of High, Moderate | All records where Priority value is High or Moderate. |
| Document ID | current.addQuery('item', 'in', ['0229fa8abcbe1f530247ebc80fcad95c', '0229fa8abcbe1f530247cfab67e9b8ab']); | The is one of operator is not available for Document ID fields in the condition builder. Instead, use the combination of is AND is as in the example: Item is TSK0000005 Verification AND Item is TSK0000001 Task 1 | |
| Reference | current.addQuery('table_id', 'in', ['155964310500000291', '160456341213536956']); | Table is one of Known Error, Article | All records where the Table is Known Error or Article. |
| Record Class | current.addQuery('sys_db_table_id', 'in', ['155931135900000084', '156873090301469473']); | Table is one of User, Employee | All records where the Table is User or Employee. |
| Big Integer | current.addQuery('size_bytes', 'in', [10, 32]); | Size bytes is one of 10,32 | All records where the Size bytes value is equal to 10 or 32. |
| Integer | current.addQuery('order', 'in', [100, 200]); | Order is one of 100, 200 | All records where the Order value is equal to 100 or 200. |
| Small Integer | current.addQuery('utc_offset', 'in', [3, 5]); | UTC offset is one of 3, 5 | All records where the UTC offset value is equal to 3 or 5. |
| Decimal | current.addQuery('memory_usage', 'in', [100, 300]); | Memory usage is one of 100, 300 | All records where the Memory usage value is equal to 100 or 300. |
| Float | current.addQuery('processing_time', 'in', [1.5, 3.5]); | Processing time is one of 1.5, 3.5 | All records where the Processing time value is equal to 1.5 or 3.5. |
| Percent Completed | current.addQuery('threshold_exceedance', 'in', [20, 30]); | Columns with the Percent Completed type cannot be selected in the condition builder. You can filter by these columns using the script. | All records where the Threshold exceedance value is equal to 20 or 30. |
| Duration | current.addQuery('minimum_duration', 'in', [30, 60]); | Minimum duration is one of 30, 60 | All records where the Minimum duration value is equal to 30 or 60. |
is not one of
System name: NOT IN
| Column type | Script | Condition builder | Output |
|---|---|---|---|
| Choice | current.addQuery('priority', 'not in', ['2', '3']); // not High AND not Moderate | Priority is not one of High, Moderate | All records where the Priority value is any other than High or Moderate. |
| Big Integer | current.addQuery('size_bytes', 'not in', [10, 32]); | Site bytes is not one of 10, 32 | All records where the Size bytes value is any other than 10 or 32. |
| Integer | current.addQuery('order', 'not in', [100, 200]); | Order is not one of 100, 200 | All records where the Order value is any other than 100 or 200. |
| Small Integer | current.addQuery('utc_offset', 'not in', [3, 5]); | UTC offset is not one of 3, 5 | All records where the UTC offset value is any other than 3 or 5. |
| Decimal | current.addQuery('memory_usage', 'not in', [100, 300]); | Memory usage is not one of 100.00, 300.00 | All records where the Memory usage value is any other than 100.00 or 300.00. |
| Float | current.addQuery('processing_time', 'not in', [1.5, 3.5]); | Processing time is not one of 1.5, 3.5 | All records where the Processing time value is any other than 1.5 or 3.5. |
| Document ID | current.addQuery('item', 'not in', ['0229fa8abcbe1f530247ebc80fcad95c', '0229fa8abcbe1f530247cfab67e9b8ab']); | 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: Item is not TSK0000005 Verification AND Item is not TSK0000001 My task 1 | |
| Reference | current.addQuery('table_id', 'not in', ['155964310500000291', '160456341213536956']); | The is not one of operator is not available for Reference fields in the condition builder. Instead, use the combination of is not AND is not as in the example: Table is not Known Errors AND Table is not Article | |
| Record Class | current.addQuery('sys_db_table_id', 'not in', ['155931135900000084', '156873090301469473']); | The is not one of operator is not available for Record Class fields in the condition builder. Instead, use the combination of is not AND is not as in the example: Table is not Users AND Table is not Employee | |
| Percent Completed | current.addQuery('threshold_exceedance', 'not in', [20, 30]); | Columns with the Percent Completed type cannot be selected in the condition builder. You can filter by these columns using the script. | All records where the Threshold exceedance value is any other than 20 or 30. |
| Duration | current.addQuery('minimum_duration', 'not in', [30, 60]); | The is not one of operator is not available for Duration fields in the condition builder. Instead, use the combination of is not AND is not as in the example: Minimum duration is not 30 AND Minimum duration is not 60 | All records where the Minimum duration value is any other than 30 or 60. |
greater than
System name: >
| Column type | Script | Condition builder | Output |
|---|---|---|---|
| Choice | current.addQuery('priority', '>', '3'); // High | Priority greater than High | All records where Priority value is greater than High. |
| Big Integer | current.addQuery('max_length', '>', 255); | Max length greater than 255 | All records where the Max length value is greater than 255. |
| Integer | current.addQuery('order', '>', '7'); | Order greater than 7 | All records where the Order value is greater than 7. |
| Small Integer | current.addQuery('utc_offset', '>', '3'); | UTC offset greater than 3 | All records where the UTC offset value is greater than 3. |
| Decimal | current.addQuery('memory_usage', '>', '12'); | Memory usage greater than 12 | All records where the Memory usage value is greater than 12. |
| Float | current.addQuery('processing_time', '>', '0.3'); | Processing time greater than 0.3 | All records where the Processing time value is greater than 0.3. |
| Percent Completed | current.addQuery('threshold_exceedance', '>', '35'); | Columns with the Percent Completed type cannot be selected in the condition builder. You can filter by these columns using the script. | All records where the Threshold exceedance value is greater than 35. |
| Duration | current.addQuery('minimum_duration', '>', '360000'); | Minimum duration greater than 360000 | All records where the Minimum duration is greater than 360000 (= 6 minute). |
less than
System name: <
| Column type | Script | Condition builder | Output |
|---|---|---|---|
| Choice | current.addQuery('priority', '<', '3'); // High | Priority is less than High | All records where Priority value is less than High. |
| Big Integer | current.addQuery('max_length', '<', 255); | Max length less than 255 | All records where the Max length value is less than 255. |
| Integer | current.addQuery('order', '<', '7'); | Order less than 7 | All records where the Order value is less than 7. |
| Small Integer | current.addQuery('utc_offset', '<', '3'); | UTC offset less than 3 | All records where the UTC offset value is less than 3. |
| Decimal | current.addQuery('memory_usage', '<', '12'); | Memory usage less than 12 | All records where the Memory usage value is less than 12. |
| Float | current.addQuery('processing_time', '<', '0.3'); | Processing time less than 0.3 | All records where the Processing time value is less than 0.3. |
| Percent Completed | current.addQuery('threshold_exceedance', '<', '35'); | Columns with the Percent Completed type cannot be selected in the condition builder. You can filter by these columns using the script. | All records where the Threshold exceedance value is less than 35. |
| Duration | current.addQuery('minimum_duration', '<', '360000'); | Minimum duration less than 360000 | All records where the Minimum duration is less than 360000 (= 6 minute). |
greater than or is
System name: >=
| Column type | Script | Condition builder | Output |
|---|---|---|---|
| Choice | current.addQuery('priority', '>=', '3'); // High | Priority greater than or is High | All records where Priority value is greater than or equal to High. |
| Big Integer | current.addQuery('max_length', '>=', 255); | Max length greater than or is 255 | All records where the Max length value is 255 or greater. |
| Integer | current.addQuery('order', '>=', '7'); | Order greater than or is 7 | All records where the Order value is 7 or greater. |
| Small Integer | current.addQuery('utc_offset', '>=', '3'); | UTC offset greater than or is 3 | All records where the UTC offset value is 3 or greater. |
| Decimal | current.addQuery('memory_usage', '>=', '12'); | Memory usage greater than or is 12 | All records where the Memory usage value is 12 or greater. |
| Float | current.addQuery('processing_time', '>=', '0.3'); | Processing time greater than or is 0.3 | All records where the Processing time value is 0.3 or greater. |
| Percent Completed | current.addQuery('threshold_exceedance', '>=', '35'); | Columns with the Percent Completed type cannot be selected in the condition builder. You can filter by these columns using the script. | All records where the Threshold exceedance value is 35 or greater. |
| Duration | current.addQuery('minimum_duration', '>=', '360000'); | Minimum duration greater than or is 360000 | All records where the Minimum duration is 360000 (= 6 minute) or greater. |
less than or is
System name: <=
| Column type | Script | Condition builder | Output |
|---|---|---|---|
| Choice | current.addQuery('priority', '<=', '3'); // High | Priority is less than or is High | All records where Priority value is less than or equal to High. |
| Big Integer | current.addQuery('max_length', '<=', 255); | Max length less than or is 255 | All records where the Max length value is less than or equal to 255. |
| Integer | current.addQuery('order', '<=', '7'); | Order less than or is 7 | All records where the Order value is less than or equal to 7. |
| Small Integer | current.addQuery('utc_offset', '<=', '3'); | UTC offset less than or is 3 | All records where the UTC offset value is less than or equal to 3. |
| Decimal | current.addQuery('memory_usage', '<=', '12'); | Memory usage less than or is 12 | All records where the Memory usage value is less than or equal to 12. |
| Float | current.addQuery('processing_time', '<=', '0.3'); | Processing time less than or is 0.3 | All records where the Processing time value is less than or equal to 0.3 or less. |
| Percent Completed | current.addQuery('threshold_exceedance', '<=', '35'); | Columns with the Percent Completed type cannot be selected in the condition builder. You can filter by these columns using the script. | All records where the Threshold exceedance value is less than or equal to 35. |
| Duration | current.addQuery('minimum_duration', '<=', '360000'); | Minimum duration less than or is 360000 | All records where the Minimum duration is less than or equal to 360000 (= 6 minute). |
greater than field
System name: GT_FIELD
| Column type | Script | Condition builder | Output |
|---|---|---|---|
| Big Integer | current.addQuery('taskpd', 'gt_field', 'completed_tasks'); | Tasks per day greater than field Completed tasks | All records where the field value of Tasks per day is greater than the value of Completed tasks. |
| Integer | current.addQuery('service_life', 'gt_field', 'warranty'); | Service life greater than field Warranty | All records where the Service life value is greater than the value of Warranty. |
| Small Integer | current.addQuery('order', 'gt_field', 'nested_level'); | Order greater than field Nested level | All records where the Order value is greater than the value of Nested level. |
| Decimal | current.addQuery('input_voltage', 'gt_field', 'output_tension'); | Input voltage greater than field Output tension | All records where the Input voltage value is greater than the value of Output tension. |
| Float | current.addQuery('weight', 'gt_field', 'height'); | Weight greater than field Height | All records where the Weight value is greater than the value of Height. |
| Percent Completed | current.addQuery('ssd', 'gt_field', 'hdd); | Columns with the Percent Completed type cannot be selected in the condition builder. You can filter by these columns using the script. | All records where the SSD value is greater than the value of HDD. |
| Duration | current.addQuery('minimum_duration', 'gt_field', 'duration'); | Minimum duration greater than field Duration | All records where the Minimum duration value is greater than the value of Duration. |
less than field
System name: LT_FIELD
| Column type | Script | Condition builder | Output |
|---|---|---|---|
| Big Integer | current.addQuery('taskpd', 'lt_field', 'completed_tasks'); | Tasks per day less than field Completed tasks | All records where the field value of Tasks per day is less than the value of Completed tasks. |
| Integer | current.addQuery('service_life', 'lt_field', 'warranty'); | Service life less than field Warranty | All records where the Service life value is less than the value of Warranty. |
| Small Integer | current.addQuery('order', 'lt_field', 'nested_level'); | Order less than field Nested level | All records where the Order value is less than the value of Nested level. |
| Decimal | current.addQuery('output_tension', 'lt_field', 'input_voltage'); | Output tension less than field Input voltage | All records where the Output tension value is less than the value of Input voltage. |
| Float | current.addQuery('weight', 'lt_field', 'height'); | Weight less than field Height | All records where the Weight value is less than the value of Height. |
| Percent Completed | current.addQuery('ssd', 'lt_field', 'hdd); | All records where the SSD value is less than the value of HDD. | Columns with the Percent Completed type cannot be selected in the condition builder. You can filter by these columns using the script. |
| Duration | current.addQuery('minimum_duration', 'lt_field', 'duration'); | Minimum duration less than field Duration | All records where the Minimum duration value is less than the value of Duration. |
greater than or is field
System name: GT_OR_EQUALS_FIELD
| Column type | Script | Condition builder | Output |
|---|---|---|---|
| Big Integer | current.addQuery('taskpd', 'gt_or_equals_field', 'completed_tasks'); | Tasks per day greater than or is field Completed tasks | All records where the field value of Tasks per day is equal to the value of Completed tasks or greater. |
| Integer | current.addQuery('service_life', 'gt_or_equals_field', 'warranty'); | Service life greater than or is field Warranty | All records where the Service life value is equal to the value of Warranty or greater. |
| Small Integer | current.addQuery('order', 'gt_or_equals_field', 'nested_level'); | Order greater than or is field Nested level | All records where the Order value is equal to the value of Nested level or greater. |
| Decimal | current.addQuery('input_voltage', 'gt_or_equals_field', 'output_tension'); | Input voltage greater than or is field Output tension | All records where the Input voltage value is equal to the value of Output tension or greater. |
| Float | current.addQuery('weight', 'gt_or_equals_field', 'height'); | Weight greater than or is field Height | All records where the Weight value is equal to the value of Height or greater. |
| Percent Completed | current.addQuery('ssd', 'gt_or_equals_field', 'hdd); | Columns with the Percent Completed type cannot be selected in the condition builder. You can filter by these columns using the script. | All records where the SSD value is equal to the value of HDD or greater. |
| Duration | current.addQuery('minimum_duration', 'gt_or_equals_field', 'duration'); | Minimum duration greater than or is field Duration | All records where the Minimum duration values is equal to the value of Duration or greater. |
less than or is field
System name: LT_OR_EQUALS_FIELD
| Column type | Script | Condition builder | Output |
|---|---|---|---|
| Big Integer | current.addQuery('taskpd', 'lt_or_equals_field', 'completed_tasks'); | Tasks per day less than or is field Completed tasks | All records where the field value of Tasks per day is equal to the value of Completed tasks or less. |
| Integer | current.addQuery('service_life', 'lt_or_equals_field', 'warranty'); | Service life less than or is field Warranty | All records where the Service life value is equal to the value of Warranty or less. |
| Small Integer | current.addQuery('order', 'lt_or_equals_field', 'nested_level'); | Order less than or is field Nested level | All records where the Order value is equal to the value of Nested level or less. |
| Decimal | current.addQuery('output_tension', 'lt_or_equals_field', 'input_voltage'); | Output tension less than or is field Input voltage | All records where the Output tension value is equal to the value of Input voltage or less. |
| Float | current.addQuery('weight', 'lt_or_equals_field', 'height'); | Weight less than or is field Height | All records where the Weight value is equal to the value of Height or less. |
| Percent Completed | current.addQuery('ssd', 'lt_or_equals_field', 'hdd); | Columns with the Percent Completed type cannot be selected in the condition builder. You can filter by these columns using the script. | All records where the SSD value is equal to the value of HDD or less. |
| Duration | current.addQuery('minimum_duration', 'lt_or_equals_field', 'duration'); | Minimum duration less than or is field Duration | All records where the Minimum duration values is equal to the value of Duration or less. |
between
System name: BETWEEN
| Column type | Script | Condition builder | Output |
|---|---|---|---|
| Choice | current.addQuery('priority', 'between', ['1', '3']); / between Low and High | Priority is between Low (and) High | All records where Priority value is between Low and High (Critical priority is not included). |
| Date | current.addQuery('sys_expire_at', 'between', ['2019-01-01', '2019-01-01']); | Expire at between 2019-01-01 (and) 2019-01-31 | All records where Expire at contains a date between 2019-01-01 and 2019-01-31 including these dates. |
| Date/Time | current.addQuery('sys_created_at', 'between', ['2019-01-01 03:00:00', '2019-01-01 02:59:59']); | Created at between 2019-01-01 03:00:00 (and) 2019-01-02 02:59:59 | 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. |
| Time | current.addQuery('run_time', 'between', ['10:00:00', '11:00:00']); | Run time between 10:00:00 (and) 11:00:00 | All records where Run time contains time between 10:00:00 and 11:00:00. |
| Big Integer | current.addQuery('max_length', 'between', [10, 255]); | Max length between 10 (and) 255 | All records where Max length value is in this range: [10; 255]. |
| Integer | current.addQuery('order', 'between', [1, 5]); | Order between 1 (and) 5 | All records where Order value is in this range between 1 and 5. |
| Small Integer | current.addQuery('utc_offset', 'between', [1, 3]); | UTC offset between 1 (and) 3 | All records where UTC offset value is in the range between 1 and 3. |
| Decimal | current.addQuery('memory_usage', 'between', [10, 25]); | Memory usage between 10 (and) 25 | All records where Memory usage value is in the range between 10 and 25. |
| Float | current.addQuery('processing_time', 'between', [1.5, 5.5]); | Processing time between 1.5 (and) 5.5 | All records where Processing time value is in the range between 1.5 and 5.5. |
| Percent Completed | current.addQuery('threshold_exceedance', 'between', [20, 55]); | Columns with the Percent Completed type cannot be selected in the condition builder. You can filter by these columns using the script. | All records where Threshold exceedance value is in the range between 20 and 55. |
| Duration | current.addQuery('minimum_duration', 'between', [20, 60]); | Minimum duration between 20 (and) 60 | All records where Minimum duration is in the range between 10 and 60. |
contains
caution
This condition operator returns records with partial matches and requires input datetime in UTC.
- The contains operator is not available for numeric fields in the condition builder. It is used for filtering in scripts.
- The operator is case insensitive.
System name: LIKE
| Column type | Script | Condition builder | Output |
|---|---|---|---|
| Choice | current.addQuery('state', 'like', 'publish'); | State contains publish | All records where State contains these characters in choice title. |
| Date | current.addQuery('repeat_until_on', 'like' '2019-01-01'); | Repeat until contains 2019-01-01 | All records where Repeat until contains this date. |
| Date/Time | current.addQuery('sys_published_at', 'like' '2020-01-01 03:'); | Published at contains 2020-01-01 03: | All records where Published at contains these date and time. |
| Time | current.addQuery('run_time', 'like' '03:'); | Run time contains 03: | All records where Run time contains the hour value 03. |
| Document ID | current.addQuery('item', 'like', '0229fa8a-bcbe-1f53'); | Item contains 0229fa8a-bcbe-1f53: | All records where Item contains 0229fa8a-bcbe-1f53. In the Item field, records from the Task (task) table are specified. |
| Field Name | current.addQuery('column_id', 'like', 'typ'); | Column contains typ | All records where Column contains "typ". |
| JSON | current.addQuery('json_copy', 'like', '"url": null'); | JSON copy contains "url": null | All records where JSON copy display value contains ""url": null". |
| List | current.addQuery('categories', 'like', 'artic'); | Categories contains artic | All records where references in Categories contains corresponding characters in Display by ref field. |
| Reference | current.addQuery('caller', 'like', 'Aleks'); | Caller contains Aleks | All records where references in Caller contains corresponding characters in Display by ref field. |
| Record Class | current.addQuery('sys_db_table_id', 'like', 'rep'); | Table contains rep | All records where the Table title contains the "rep" characters. |
| Big Integer | current.addQuery('size_bytes', 'like', 99); | Size bytes contains 99 | All records where Size bytes contains 99. |
| Integer | current.addQuery('order', 'like', 100); | Order contains 100 | All records where Order contains 100. |
| Small Integer | current.addQuery('utc_offset', 'like', 3); | UTC offset contains 3 | All records where UTC offset contains 3. |
| Decimal | current.addQuery('memory_usage', 'like', 100 ); | Memory usage contains 100 | All records where Memory usage contains 100. |
| Float | current.addQuery('processing_time', 'like', 7); | Processing time contains 3 | All records where Processing time contains 7. |
| Percent Complete | current.addQuery('threshold_exceedance', 'like', 7); | Columns with the Percent Completed type cannot be selected in the condition builder. You can filter by these columns using the script. | All records where Threshold exceedance contains 7. |
| Duration | current.addQuery('minimum_duration', 'like', 60); | Minimum duration contains 60 | All records where Minimum duration contains 60. |
| Phone | current.addQuery('mobile_phone', 'like', '+7'); | Mobile phone contains +7 | All records where Mobile phone contains +7. |
| String | current.addQuery('email', 'like', '_'); | Email contains _ | All records where Email contains "_". |
| Text | current.addQuery('description', 'like', 'critic'); | Description contains critic | All records where Description contains the "critic" characters. |
| Translated Text | current.addQuery('title', 'like', 'prob'); | Title contains prob | All records where Title contains the "prob" characters. |
| Conditions | current.addQuery('completion_conditions', 'like', 'stat'); | Completion conditions contains stat | All records where Completion conditions contains the "stat" characters. |
| URL | current.addQuery('website', 'like', 'simpl'); | Website contains simpl | All records where Website contains the "simpl" characters. |
| HTML | current.addQuery('body', 'like', '<div>'); | Body contains <div> | All records where Body contains <div>. |
| Script | current.addQuery('script', 'like', 'return user.sys_id'); | Script contains return user.sys_id | All records where Script contains the "return user.sys_id". |
does not contain
caution
This condition operator returns records with partial matches and requires input datetime in UTC.
- The does not contain operator is not available for numeric fields in the condition builder. It is used for filtering in scripts.
- The operator is case insensitive.
System name: NOTLIKE
| Column type | Script | Condition builder | Output |
|---|---|---|---|
| Choice | current.addQuery('state', 'notlike', 'publish'); | State does not contain publish | All records where State does not contain these characters in choice title. |
| Date | current.addQuery('repeat_until_on', 'notlike' '2019-01-01'); | Repeat until does not contain 2019-01-01 | All records where Repeat until does not contain this date. |
| Date/Time | current.addQuery('sys_published_at', 'notlike' '2020-01-01 03:'); | Published at does not contain 2020-01-01 03: | All records where Published at does not contain these date and time. |
| Time | current.addQuery('run_time', 'notlike' '03:'); | Run time does not contain 03: | All records where Run time contains any hour value but 03. |
| Document ID | current.addQuery('item', 'notlike', '0229fa8a-bcbe-1f53'); | Item does not contain 0229fa8a-bcbe-1f53: | All records where Item does not contain 0229fa8a-bcbe-1f53. The Item field does not contain records from the Task (task) table. |
| Field Name | current.addQuery('column_id', 'notlike', 'typ'); | Column does not contain typ | All records where Column does not contain "typ". |
| JSON | current.addQuery('json_copy', 'notlike', '"url": null'); | JSON copy does not contain "url": null | All records where JSON copy display value does not contain ""url": null". |
| List | current.addQuery('categories', 'notlike', 'artic'); | Categories does not contain artic | All records where references in Categories does not contain corresponding characters in Display by ref field. |
| Reference | current.addQuery('caller', 'notlike', 'Aleks'); | Caller does not contain Aleks | All records where references in Caller does not contain corresponding characters in Display by ref field. |
| Record Class | current.addQuery('sys_db_table_id', 'notlike', 'rep'); | Table title does not contain rep | All records where the Table title does not contain the "rep" characters. |
| Big Integer | current.addQuery('size_bytes', 'notlike', 99); | Size bytes does not contain 99 | All records where Size bytes does not contain 99. |
| Integer | current.addQuery('order', 'notlike', 100); | Order does not contain 100 | All records where Order does not contain 100. |
| Small Integer | current.addQuery('utc_offset', 'notlike', 3); | UTC offset does not contain 3 | All records where UTC offset does not contain 3. |
| Decimal | current.addQuery('memory_usage', 'notlike', 100 ); | Memory usage does not contain 100 | All records where Memory usage does not contain 100. |
| Float | current.addQuery('processing_time', 'notlike', 7); | Processing time does not contain 7 | All records where Processing time does not contain 7. |
| Percent Complete | current.addQuery('threshold_exceedance', 'notlike', 7); | Columns with the Percent Completed type cannot be selected in the condition builder. You can filter by these columns using the script. | All records where Threshold exceedance does not contain 7. |
| Duration | current.addQuery('minimum_duration', 'notlike', 60); | Minimum duration does not contain 60 | All records where Minimum duration does not contain 60. |
| Phone | current.addQuery('mobile_phone', 'notlike', '+7'); | Mobile phone does not contain +7 | All records where Mobile phone does not contain +7. |
| String | current.addQuery('email', 'notlike', '_'); | Email does not contain _ | All records where Email does not contain _. |
| Text | current.addQuery('description', 'notlike', 'critic'); | Description does not contain critic | All records where Description does not contain the "critic" characters. |
| Translated Text | current.addQuery('title', 'notlike', 'prob'); | Title does not contain prob | All records where Title does not contain the "prob" characters. |
| Conditions | current.addQuery('completion_conditions', 'notlike', 'stat'); | Completion conditions does not contain stat | All records where Completion conditions does not contain the "stat" characters. |
| URL | current.addQuery('website', 'notlike', 'simpl'); | Website does not contain simpl | All records where Website does not contain the "simpl" characters. |
| HTML | current.addQuery('body', 'notlike', '\<div>'); | Body does not contain <div> | All records where Body does not contain <div>. |
| Script | current.addQuery('script', 'notlike', 'return user.sys_id'); | Script does not contain return user.sys_id | All records where Script does not contain the "return user.sys_id". |
starts with
The operator is case insensitive.
System name: STARTSWITH
| Column type | Script | Condition builder | Output |
|---|---|---|---|
| Choice | current.addQuery('state', 'startswith' 'publish'); | State starts with ed | All records where State contains these characters at the beginning of a choice title. |
| Field Name | current.addQuery('column_id', 'startswith' 'typ'); | Column starts with typ | All records where Column contains these characters at the beginning. |
| Reference | current.addQuery('related_ticket', 'startswith' 'email'); | Related ticket starts with email | All records where Related ticket contains these characters at the beginning of Display by ref field value. |
| Record Class | current.addQuery('sys_db_table_id', 'startswith' 'rule'); | Table title starts with bus | All records where the Table title contains these characters at the beginning. |
| Phone | current.addQuery('mobile_phone', 'startswith' '79'); | Mobile phone starts with 79 | All records where Mobile phone contains these characters at the beginning. |
| String | current.addQuery('name', 'startswith' 'iv'); | Name starts with iv | All records where Name contains these characters at the beginning. |
| Text | current.addQuery('description', 'startswith' 'default'); | Description starts with default | All records where Description contains these characters at the beginning. |
| Translated Text | current.addQuery('title', 'startswith' 'inc'); | Title starts with inc | All records where Title contains these characters at the beginning. |
| Conditions | current.addQuery('completion_conditions', 'startswith' 'stat'); | Completion conditions starts with stat | All records where Completion conditions contains these characters at the beginning. |
| URL | current.addQuery('website', 'startswith' 'simpl'); | Website starts with simpl | All records where Website contains these characters at the beginning. |
ends with
The operator is case insensitive.
System name: ENDSWITH
| Column type | Script | Condition builder | Output |
|---|---|---|---|
| Choice | current.addQuery('state', 'endswith' 'ed'); | State ends with ed | All records where State contains these characters at the end of a choice title. |
| Field Name | current.addQuery('column_id', 'endswith' 'typ'); | Column ends with typ | All records where Column contains these characters at the end. |
| Reference | current.addQuery('related_ticket', 'endswith' 'mail'); | Related ticket ends with mail | All records where Related ticket contains these characters at the end of Display by ref field value. |
| Record Class | current.addQuery('sys_db_table_id', 'endswith' 'rule'); | Table title ends with rule | All records where the Table title contains these characters at the end. |
| Phone | current.addQuery('mobile_phone', 'endswith' '92'); | Mobile phone ends with 92 | All records where Mobile phone contains these characters at the end. |
| String | current.addQuery('name', 'endswith' 'ov'); | Name ends with ov | All records where Name contains these characters at the end. |
| Text | current.addQuery('description', 'endswith' 'default'); | Description ends with default | All records where Description contains these characters at the end. |
| Translated Text | current.addQuery('title', 'endswith' 'ed'); | Title ends with ed | All records where Title contains these characters at the end. |
| Conditions | current.addQuery('completion_conditions', 'endswith' '2)'; | Completion conditions ends with 2 | All records where Completion conditions contains these characters at the end. |
| URL | current.addQuery('website', 'endswith' '.com'); | Website ends with .com | All records where Website contains these characters at the end. |
is empty
caution
Note that if the Reference field has the attribute On delete with the No action value, the ID of the deleted record remains in the field (then the reference leads to a non-existing record). Such records will not be displayed in the output of "Reference field is empty". In order to exclude records with deleted reference from the output, use this condition:
Reference Field → ID is empty.
System name: ISEMPTY
| Column type | Script | Condition builder | Output |
|---|---|---|---|
| Choice | current.addQuery('state', 'isempty'); / not None | State is empty | All records where State does not contains any value. |
| Date | current.addQuery('repeat_until_on', 'isempty'); | Repeat until is empty | All records where Repeat until does not contain any value. |
| Date/Time | current.addQuery('sys_published_at', 'isempty'); | Published at is empty | All records where Published at does not contain any value. |
| Document ID | current.addQuery('record_document_id', 'isempty') | Document record is empty | All records where Document record does not contain any value. |
| Field Name | current.addQuery('column_id', 'isempty'); | Column is empty | All records where Column does not contain any value. |
| Reference | current.addQuery('related_ticket', 'isempty'); | Related ticket is empty | All records where Related ticket does not contain any value. |
| List | current.addQuery('categories', 'isempty'); | Categories is empty | All records where Categories does not contain any value. |
| JSON | current.addQuery('json_copy', 'isempty'); | JSON copy is empty | All records where JSON copy does not contain any value. |
| Image | current.addQuery('profile_picture', 'isempty'); | Profile picture is empty | All records where Profile picture does not contain any value. |
| Big Integer | current.addQuery('size_bytes', 'isempty'); | Size, bytes is empty | All records where Size, bytes does not contain any value. |
| Integer | current.addQuery('order', 'isempty'); | Order is empty | All records where Order does not contain any value. |
| Small Integer | current.addQuery('utc_offset', 'isempty'); | UTC offset is empty | All records where UTC offset does not contain any value. |
| Decimal | current.addQuery('memory_usage', 'isempty'); | Memory usage is empty | All records where Memory usage does not contain any value. |
| Float | current.addQuery('processing_time', 'isempty'); | Processing time is empty | All records where Processing time does not contain any value. |
| Percent Completed | current.addQuery('threshold_exceedance', 'isempty'); | Columns with the Percent Completed type cannot be selected in the condition builder. You can filter by these columns using the script. | All records where Threshold exceedance does not contain any value. |
| Duration | current.addQuery('minimum_duration', 'isempty'); | Minimum duration is empty | All records where Minimum duration does not contain any value. |
| Phone | current.addQuery('mobile_phone', 'isempty'); | Mobile phone is empty | All records where Mobile phone does not contain any value. |
| String | current.addQuery('name', 'isempty'); | Name is empty | All records where Name does not contain any value. |
| Text | current.addQuery('description', 'isempty'); | Description is empty | All records where Description does not contain any value. |
| Translated Text | current.addQuery('title', 'isempty'); | Title is empty | All records where Title does not contain any value. |
| Conditions | current.addQuery('completion_conditions', 'isempty'); | Completion conditions is empty | All records where Completion conditions does not contain any value. |
| URL | current.addQuery('website', 'isempty'); | Website is empty | All records where Website does not contain any value. |
| HTML | current.addQuery('body', 'isempty'); | Body is empty | All records where Body does not contain any value. |
| Script | current.addQuery('script', 'isempty'); | Script is empty | All records where Script does not contain any value. |
is not empty
caution
Note that if the Reference field has the attribute On delete with the No action value, the ID of the deleted record remains in the field (then the reference leads to a non-existing 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, use this condition:
Reference Field → ID is empty.
System name: ISNOTEMPTY
| Column type | Script | Condition builder | Output |
|---|---|---|---|
| Choice | current.addQuery('state', 'isnotempty'); // not None | State is not empty | All records where State contains any value. |
| Date | current.addQuery('repeat_until_on', 'isnotempty'); | Repeat until is not empty | All records where Repeat until contains any value. |
| Date/Time | current.addQuery('sys_published_at', 'isnotempty'); | Published at is not empty | All records where Published at contains any value. |
| Document ID | current.addQuery('record_document_id', 'isnotempty') | Document record is not empty | All records where Document record contains any value. |
| Field Name | current.addQuery('column_id', 'isnotempty'); | Column is not empty | All records where Column contains any value. |
| Reference | current.addQuery('related_ticket', 'isnotempty'); | Related ticket is not empty | All records where Related ticket contains any value. |
| List | current.addQuery('categories', 'isnotempty'); | Categories is not empty | All records where Categories contains any value. |
| JSON | current.addQuery('json_copy', 'isnotempty'); | JSON copy is not empty | All records where JSON copy contains any value. |
| Image | current.addQuery('profile_picture', 'isnotempty'); | Profile picture is not empty | All records where Profile picture contains any value. |
| Big Integer | current.addQuery('size_bytes', 'isnotempty'); | Size, bytes is not empty | All records where Size, bytes contains any value. |
| Integer | current.addQuery('order', 'isnotempty'); | Order is not empty | All records where Order contains any value. |
| Small Integer | current.addQuery('utc_offset', 'isnotempty'); | UTC offset is not empty | All records where UTC offset contains any value. |
| Decimal | current.addQuery('memory_usage', 'isnotempty'); | Memory usage is not empty | All records where Memory usage contains any value. |
| Float | current.addQuery('processing_time', 'isnotempty'); | Processing time is not empty | All records where Processing time contains any value. |
| Percent Completed | current.addQuery('threshold_exceedance', 'isnotempty'); | Columns with the Percent Completed type cannot be selected in the condition builder. You can filter by these columns using the script. | All records where Threshold exceedance contains any value. |
| Duration | current.addQuery('minimum_duration', 'isnotempty'); | Minimum duration is not empty | All records where Minimum duration contains any value. |
| Phone | current.addQuery('mobile_phone', 'isnotempty'); | Mobile phone is not empty | All records where Mobile phone contains any value. |
| String | current.addQuery('name', 'isnotempty'); | Name is not empty | All records where Name contains any value. |
| Text | current.addQuery('description', 'isnotempty'); | Description is not empty | All records where Description contains any value. |
| Translated Text | current.addQuery('title', 'isnotempty'); | Title is not empty | All records where Title contains any value. |
| Conditions | current.addQuery('completion_conditions', 'isnotempty'); | Completion conditions is not empty | All records where Completion conditions contains any value. |
| URL | current.addQuery('website', 'isnotempty'); | Website is not empty | All records where Website contains any value. |
| HTML | current.addQuery('body', 'isnotempty'); | Body is not empty | All records where Body contains any value. |
| Script | current.addQuery('script', 'isnotempty'); | Script is not empty | All records where Script contains any value. |
on
System name: ON
| Column type | Script | Condition builder | Output |
|---|---|---|---|
| Date | current.addQuery('repeat_until_on', '2019-01-01''); | Repeat until on 2019-01-01 | All records where the Repeat until value is "2019-01-01" exactly. |
| Date/Time | current.addQuery('sys_created_at', '2020-01-01 03:00:00''); | Created at on 2020-01-01 03:00:00 | All records where the Created at value is "2020-01-01 03:00:00" exactly. |
| Time | current.addQuery('run_time', '11:00:00''); | Run time on 11:00:00 | All records where the Run time value is "11:00:00" exactly. |
not on
System name: NOTON
| Column type | Script | Condition builder | Output |
|---|---|---|---|
| Date | current.addQuery('repeat_until_on', '!=', '2019-01-01''); | Repeat until not on 2019-01-01 | All records where Repeat until is any value but "2019-01-01". |
| Date/Time | current.addQuery('sys_created_at', '!=', '2020-01-01 03:00:00''); | Created at not on 2020-01-01 03:00:00 | All records where Created at is any value but "2020-01-01 03:00:00". |
| Time | current.addQuery('run_time', '!=', '11:00:00''); | Run time not on 11:00:00 | All records where Run time is any value but "11:00:00". |
before
System name: <
| Column type | Script | Condition builder | Output |
|---|---|---|---|
| Date | current.addQuery('repeat_until_on', '<', '2019-01-01''); | Repeat until before 2019-01-01 | All records where Repeat until date is before "2019-01-01". |
| Date/Time | current.addQuery('sys_created_at', '<', '2020-01-01 03:00:00''); | Created at before 2020-01-01 03:00:00 | All records where Created at date and time is before "2020-01-01 03:00:00". |
| Time | current.addQuery('run_time', '<', '11:00:00''); | Run time before 11:00:00 | All records where Run time is before "11:00:00". |
after
System name: >
| Column type | Script | Condition builder | Output |
|---|---|---|---|
| Date | current.addQuery('repeat_until_on', '>', '2019-01-01''); | Repeat until after 2019-01-01 | All records where Repeat until date is after "2019-01-01". |
| Date/Time | current.addQuery('sys_created_at', '>', '2020-01-01 03:00:00''); | Created at after 2020-01-01 03:00:00 | All records where Created at date and time is after "2020-01-01 03:00:00". |
| Time | current.addQuery('run_time', '>', '11:00:00''); | Run time after 11:00:00 | All records where Run time is after "11:00:00". |
at or before
System name: <=
| Column type | Script | Condition builder | Output |
|---|---|---|---|
| Date | current.addQuery('repeat_until_on', '<=', '2019-01-01''); | Repeat until at or before 2019-01-01 | All records where Repeat until is "2019-01-01" or the date before it. |
| Date/Time | current.addQuery('sys_created_at', '<=', '2020-01-01 03:00:00''); | Created at at or before 2020-01-01 03:00:00 | All records where Created at is "2020-01-01 03:00:00" or the date and time before it. |
| Time | current.addQuery('run_time', '<=', '11:00:00''); | Run time at or before 11:00:00 | All records where Run time is "11:00:00" or the time before it. |
at or after
System name: >=
| Column type | Script | Condition builder | Output |
|---|---|---|---|
| Date | current.addQuery('repeat_until_on', '>=', '2019-01-01''); | Repeat until at or after 2019-01-01 | All records where Repeat until is "2019-01-01" or the date after it. |
| Date/Time | current.addQuery('sys_created_at', '>=', '2020-01-01 03:00:00''); | Created at at or after 2020-01-01 03:00:00 | All records where Created at is "2020-01-01 03:00:00" or the date and time after it. |
| Time | current.addQuery('run_time', '>=', '11:00:00''); | Run time at or after 11:00:00 | All records where Run time is "11:00:00" or the time after it. |
year is
caution
This condition operator returns records with partial matches and requires input datetime in UTC.
System name: YEAR_IS
| Column type | Script | Condition builder | Output |
|---|---|---|---|
| Date | current.addQuery('repeat_until_on', 'year_is', '2020'); | Repeat until year is 2020 | All records where the database value (in UTC) of Repeat until contains the corresponding year (2020). |
| Date/Time | current.addQuery('sys_created_at', 'year_is', '2021'); | Created at year is 2021 | All records where the database value (in UTC) of Created at contains the corresponding year (2021). |
month is
caution
This condition operator returns records with partial matches and requires input datetime in UTC.
System name: MONTH_IS
| Column type | Script | Condition builder | Output |
|---|---|---|---|
| Date | current.addQuery('repeat_until_on', 'month_is', '1'); | Repeat until month is 1 | All records where the database value (in UTC) of Repeat until contains the corresponding month (January). |
| Date/Time | current.addQuery('sys_created_at', 'month_is', '2'); | Created at month is 2 | All records where the database value (in UTC) of Created at contains the corresponding month (February). |
quarter is
caution
This condition operator returns records with partial matches and requires input datetime in UTC.
System name: QUATER_IS
| Column type | Script | Condition builder | Output |
|---|---|---|---|
| Date | current.addQuery('repeat_until_on', 'quater_is', '1'); | Repeat until quater is 1 | All records where the database value (in UTC) of Repeat until contains the corresponding quarter. |
| Date/Time | current.addQuery('sys_created_at', 'quater_is', '2'); | Created at quater is 2 | All records where the database value (in UTC) of Created at contains the corresponding quarter. |
week is
caution
This condition operator returns records with partial matches and requires input datetime in UTC.
System name: WEEK_IS
| Column type | Script | Condition builder | Output |
|---|---|---|---|
| Date | current.addQuery('repeat_until_on', 'week_is', '10'); | Repeat until week is 10 | All records where the database value (in UTC) of Repeat until contains the corresponding week. |
| Date/Time | current.addQuery('sys_created_at', 'week_is', '25'); | Created at week is 25 | All records where the database value (in UTC) of Created at contains the corresponding week. |
day is
caution
This condition operator returns records with partial matches and requires input datetime in UTC.
System name: DAY_IS
| Column type | Script | Condition builder | Output |
|---|---|---|---|
| Date | current.addQuery('repeat_until_on', 'day_is', '10'); | Repeat until day is 10 | All records where the database value (in UTC) of Repeat until contains the corresponding day of a month (10th day of any month). |
| Date/Time | current.addQuery('sys_created_at', 'day_is', '25'); | Created at day is 25 | All records where the database value (in UTC) of Created at contains the corresponding day of a month (25th day of any month). |
day of week is
caution
This condition operator returns records with partial matches and requires input datetime in UTC.
System name: DAY_OF_WEEK_IS
| Column type | Script | Condition builder | Output |
|---|---|---|---|
| Date | current.addQuery('repeat_until_on', 'day_of_week_is', '4'); | Repeat unitl day of week is Wednesday | All records where the database value (in UTC) of Repeat until contains the corresponding day of the week. |
| Date/Time | current.addQuery('sys_created_at', 'day_of_week_is', '1'); | Created at day of week is Monday | All records where the database value (in UTC) of Created at contains the corresponding day of the week. |
hour is
caution
This condition operator returns records with partial matches and requires input datetime in UTC.
System name: HOUR_IS
| Column type | Script | Condition builder | Output |
|---|---|---|---|
| Time | current.addQuery('run_time', 'hour_is', '11'); | Run time hour is 11 | All records where Run time contains the corresponding hour. |
are
System name: ARE
| Column type | Script | Condition builder | Output |
|---|---|---|---|
| The operator is available for the text columns with the name keyword. | current.addQuery('keywords', 'are', 'mail'); | Keywords are mail | All records where the Full text search column contains the corresponding value. |
has
System name: HAS
| Column type | Script | Condition builder | Output |
|---|---|---|---|
| List | current.addQuery('categories', 'has', '155988310508800001,157688891108786828'); | Categories has Article, Model | All records where Categories contains the corresponding lists of references in this order exactly. |
tip
"Categories has Article, Model" and "Categories has Model, Article" are different conditions.
To exclude all records with "Article" and "Model" categories build the following condition:
Categories has Article AND Categories has Model
has not
System name: HASNOT
| Column type | Script | Condition builder | Output |
|---|---|---|---|
| List | current.addQuery('categories', 'hasnot', '155988310508800001,157688891108786828'); | Categories has not Article, Model | All records where Categories does not contain the corresponding lists of references in this order exactly. |
tip
"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
contains (dynamic)
System name: CONTAINS_DYNAMIC
| Column type | Script | Condition builder | Output |
|---|---|---|---|
| List | current.addQuery('followers', 'contains_dynamic', '160516373014385744'); // 160516373014385744 ID of the dynamic filter Me | Followers contains (dynamic) Me | All records where one of the values of the Followers is the ID of the current user. |
caution
Note that when you use dynamic filters to return the sequence of IDs, the sequence is taken into account.
does not contain (dynamic)
System name: DOESNOTCONTAIN_DYNAMIC
| Column type | Script | Condition builder | Output |
|---|---|---|---|
| List | current.addQuery('followers', 'doesnotcontain_dynamic', '160516373014385744'); // 160516373014385744 ID of the dynamic filter Me | Followers does not contain (dynamic) Me | All records where Followers does not contain ID of the current user. |
caution
Note that when you use dynamic filters to return the sequence of IDs, the sequence is taken into account.
is (dynamic)
System name: DYNAMIC
| Column type | Script | Condition builder | Output |
|---|---|---|---|
| Reference | current.addQuery('assignment_group', 'dynamic', '1589643105003304555'); // 1589643105003304555 ID of the dynamic filter My Group | Assignment group is (dynamic) My Group | All records where Assignment group references only one record that is the group ID of the current user. |
note
If the dynamic filter returns a list of IDs, the order of the IDs is ignored.
is not (dynamic)
System name: ISNOT_DYNAMIC
| Column type | Script | Condition builder | Output |
|---|---|---|---|
| Reference | current.addQuery('assigned_user', 'isnotdynamic', '164643105003300222'); // ID of the dynamic filter My Group | Assignment group is not (dynamic) My Group | All records where Assigned user references only one record value and it is not the ID of the current user (empty values are suitable). |
note
If the dynamic filter returns a list of IDs, the order of the IDs is ignored.
Available extra operators
Condition operators changes, changes from, and changes to are applicable to any type of conditions. They are used to keep track of updates and changes in a particular field during the insertion or update of a record.
tip
To use the VALCHANGES, CHANGESFROM, and CHANGESTO operators, you need to configure it as a column extra attribute first.
changes
System name: VALCHANGES
| Column type | Script | Condition builder | Output |
|---|---|---|---|
| - | current.addQuery('priority', 'valchanges'); | Priority changes | Returns true if the Priority field value changes during the record insertion or update. When a record is inserted, the changes operator returns true for fields of any type. For example, if a business rule that runs on Insert has condition "Subject changes", then it will run when the Subject field is inserted with any value (except for null and the same as the Default value). |
changes from
System name: CHANGESFROM
| Column type | Script | Condition builder | Output |
|---|---|---|---|
| - | current.addQuery('priority', 'changesfrom', '3') | Priority changes from High | Returns true if the State field value changes from High to any other value during the record insertion or update. |
changes to
System name: CHANGESTO
| Column type | Script | Condition builder | Output |
|---|---|---|---|
| - | current.addQuery('priority', 'changesto', '3') | Priority changes to High | Returns true if the Priority field value changes to High during the record insertion or update. |