Versions Compared


  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migrated to Confluence 5.3

Operator: Is Not (IS NOT)


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


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