Jira Query Language (JQL) Cheatsheet

Get Unassigned Tasks

assignee is EMPTY

Groups

Sometimes you need to mix both AND and OR conditions. This can be done with the use of braces.

The example below will fetch tasks that are not marked as done, and are assigned to "My Name" or are not assigned at all.

Status != "DONE" AND (assignee = "My Name" OR assignee is EMPTY)

Ordering

ORDER BY created DESC

One can add it after conditions like so:

Status != "DONE" ORDER BY created DESC