Operators / IsNot

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:

EntityType = Incident AND Component IS NOT EMPTY

Find all assigned scripts:

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

EntityType = TestScriptAssignment AND AssignedTo IS NOT NULL

See Also