Operator: Is Not (IS NOT)
Description
IS NOT is an operator used to check that a field is not in a specific state, where using a quoted/unquoted value might otherwise be interpreted as an option/text value.
Currently IS NOT is only used for checking for fields which do not have null/empty values (i.e. fields where one or more selections have been made).
Examples
Find all incidents with one or more components selected:
Code Block |
---|
|
EntityType = Incident AND Component IS NOT EMPTY
|
Find all assigned scripts:
Code Block |
---|
|
EntityType = TestScriptAssignment And AssignedTo IS NOT EMPTY
|
In addition to EMPTY, you can interchangeably use the word "NULL" instead, if this feels more comfortable (i.e. for people familiar with SQL):
Code Block |
---|
|
EntityType = TestScriptAssignment AND AssignedTo IS NOT NULL
|
See Also