Show Menu
Cheatography

A quick reference sheet for JQL queries

Rules

A classic query in JQL (also known as a 'clause') consists of a field, followed by an oper­ator, followed by one or more values or func­tio­ns.

Field - Fields are different types of inform­ation in the system. fixVe­rsion, issue type, date created, etc.
Oper­ator - Operators are the heart of the query. They relate the field to the value. equals (=), not equals (!=), less than (<), etc.
Func­tion - A function performs a calcul­ation on either specific Jira data or the function's content.
Keyw­ord - Keywords are specific words in the language that have special meaning.

Fields

Jira Software
Assignee
Attach­ments
Category
Comment
Component
Component
Created
Creator
Descri­ption
Due
Enviro­nment
Epic link
Filter
Fix version
Issue key
Issue link type
Labels
Last viewed
Level
Parent
Priority
Project
Reporter
Resolution
Resolved
Sprint
Status
Summary
Text
Type
Updated
Voter
Watcher
 
JSD Specific
Approvals
Customer Request Type
Request channel type
Request last activity time
SLA

Keywords

AND
Combine multiple clauses
OR
Choice between multiple clauses
NOT
Negate a clause or JQL query
EMPTY , NULL
Field without a value
ORDER BY
Specify the sorting order
 

Operators

= , !=
equals, not equals
> , >=
(strictly) greater than
< , <=
(strictly) lesser than
~ , !~
contains, do not contain
changed
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 Assig­nee, Fix Version, Prior­ity, Repor­ter, Resol­ution 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

Functions

User
Issue
Time
curren­tUser()
linked­Iss­ues()
now()
member­sOf()
latest­Rel­eas­edV­ers­ion()
remain­ing()
votedI­ssues()
releas­edV­ers­ions()
future­Spr­ints()
projec­tsL­ead­ByU­ser()
unrele­ase­dVe­rsi­ons()
issueH­ist­ory()
compon­ent­sLe­adB­yUser()
openSp­­ri­nts()
startO­fDa­y/W­eek­/Mo­nth­/Year()
update­dBy()
standa­rdI­ssu­eTy­pes()
endOfD­ay/­Wee­k/M­ont­h/Y­ear()
watche­dIs­sues()
subtas­kIs­sue­Types()
elapsed() *JSD only
projec­tsW­her­eUs­erH­asR­ole()
comple­ted() *JSD only
paused() *JSD only
pendin­gBy() *JSD only
myAppr­­oval() *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 "­yyy­y-M­M-d­d", for example updated < "­202­0/0­9/1­6".
Or use "­w" (weeks), "­d" (days), "­h" (hours) or "­m" (minutes) to specify a date relative to the current time, for example: updated < "­-2w­".

Advanced search

Wildcard searches
Fuzzy searches
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.
Prox­imity searches
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.
               

Help Us Go Positive!

We offset our carbon usage with Ecologi. Click the link below to help us!

We offset our carbon footprint via Ecologi
 

Comments

No comments yet. Add yours below!

Add a Comment

Your Comment

Please enter your name.

    Please enter your email address

      Please enter your Comment.

          Related Cheat Sheets

          JQL (JIRA Query Language) Cheat Sheet
          JIRA Text Formatting Notation Cheat Sheet