Versions Compared

Key

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

Operator: Is (IS)

Description

IS is an operator used to check for specific states of a field, where the value might otherwise be interpreted as an option/text value.

Currently IS is only used for checking for null/empty values (where no selection has been made i.e. when using a multi-select pick list, such as found or fixed in version, or any non-compulsory field) - but in the future it may be extended to support other types of metadata about a field.

Examples

Find all incidents with no component assigned:

Code Block
languagenone
EntityType = Incident AND Component IS EMPTY

Find all unassigned script assignments:

Code Block
languagenone
EntityType = TestScriptAssignment And AssignedTo IS 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
languagenone
EntityType = TestScriptAssignment AND AssignedTo IS NULL

See Also