Jira JQL

From NovaOrdis Knowledge Base
Jump to navigation Jump to search

External

Internal

Overview

Fields

Fields

Functions

Functions Reference

Time Functions

Also see Time Format.

startOfDay()

endOfDay()

startOfWeek()

startOfMonth()

startOfYear()

Sprint-related Functions

closedSprints()

futureSprints()

openSprints()

Specific Sprint

A way to identify the numeric ID of a Sprint is to click on the sprint link of an issue. The URL generated contains the sprint ID as "https://....?...&sprint=873", then:

... sprint = 873 ...

An alternative is to compose the query and wait for autocompletion after sprint =, while typing the first letters of the name of the sprint.

Other way:

... sprint = "Sprint 8, 1/4" ...

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)

Search for epics with a certain name

type = EPIC and project = BLUE and summary ~ serialization