This site is moving soon to become part of an integrated Appfire documentation and information site for our apps. This site will remain available during the transition to our new and improved site. Once this site is moved over, this banner will be updated with the new site link for easy access.

Take a look here! If you have any questions please email support@appfire.com

Negate queries

Owned by Daniel Turczanski, created
Aug 03, 2021
1 min read

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'")