Negate queries

Sometimes you want to negate the queries to find the results you are looking for. JQL has certain quirks that you need to be aware of.

Instructions

Aliases

To negate JQL aliases:

  1. Use the != sign

  2. Decide if you want to include the issues without the alias value. If yes, use the is empty clause

For example linkType!=blocks or linkType is empty

You can also use the linkType not in (…) expression

Functions

Use the issue not in functionName() expression.

For example issue not in subtasksOfParentsInQuery("status='Done'")

Related articles