A classic query in JQL (also known as a 'clause') consists of a field, followed by an operator, followed by one or more values or functions.
Field - Fields are different types of information in the system. fixVersion, issue type, date created, etc.
Operator - Operators are the heart of the query. They relate the field to the value. equals (=), not equals (!=), less than (<), etc.
Function - A function performs a calculation on either specific Jira data or the function's content.
Keyword - Keywords are specific words in the language that have special meaning.
Issue link type
Customer Request Type
Request channel type
Request last activity time
Combine multiple clauses
Choice between multiple clauses
Negate a clause or JQL query
EMPTY , NULL
Field without a value
Specify the sorting order
= , !=
equals, not equals
> , >=
(strictly) greater than
< , <=
(strictly) lesser than
~ , !~
contains, do not contain
field value has been changed before
is, is not
field has no value (only with EMPTY or NULL)
was, was not
field has or had the specified value. Only works with Assignee, Fix Version, Priority, Reporter, Resolution and Status fields
was in, was not in
field has or had any of multiple specified values
in, not in
field is one of multiple specified value
elapsed() *JSD only
completed() *JSD only
paused() *JSD only
pendingBy() *JSD only
myApproval() *JSD only
running() *JSD only
approver() *JSD only
breached() *JSD only
pending() *JSD only
Note: For time range you can either use the standard date format "yyyy-MM-dd", for example updated < "2020/09/16".
Or use "w" (weeks), "d" (days), "h" (hours) or "m" (minutes) to specify a date relative to the current time, for example: updated < "-2w".
To do a single character wildcard search, use the "?" symbol
To do a fuzzy search, use the "~" symbol at the end of a single word term.
To do a multiple character wildcard search, use the "*" symbol.
Wildcard characters need to be enclosed in quote-marks. E.g. summary ~ "cha?k"
To do a proximity search, use the "~", symbol at the end of a phrase.