Jira JQL

External

• https://confluence.atlassian.com/jiracorecloud/searching-for-issues-765593657.html
• Advanced searching

Internal

• Jira Concepts

Fields

Fields

Functions

Functions Reference

Time Functions

Also see Time Format.

Relative Time Comparison

updated >= "-1d"

Operators

Operators Reference

~

The "~" operator is used to search for issues where the value of the specified field matches the specified value in either an exact match or a "fuzzy" match. The operator can be used with text fields only.

ORDER BY

https://www.atlassian.com/blog/jira-software/jql-the-most-flexible-way-to-search-jira-24

[...] ORDER BY [...] DESC|ASC

• created
• updatedDate
• priority
• assignee

Examples

status = Closed AND assignee = currentUser() ORDER BY updated DESC

updated > startOfDay(-1d) AND timeSpent > 0 AND assignee = ofeodorov ORDER BY updatedDate ASC

project = FDIS AND assignee = currentUser() AND resolution = Unresolved AND sprint = "Sprint 8, 1/4" ORDER BY updated DESC

Mid-Sprint Addition Query

assignee = 00000000 AND Sprint = 111 AND "Mid-Sprint Addition?" = Yes AND (status = CLOSED OR status = Closed-Verified)