Jira JQL: Difference between revisions

From NovaOrdis Knowledge Base
Jump to navigation Jump to search
 
(10 intermediate revisions by the same user not shown)
Line 18: Line 18:


==Time Functions==
==Time Functions==
Also see [[#Time_Format|Time Format]].
Also see [[#Time_Format|Time Format]].
===<tt>startOfDay()</tt>===
===<tt>endOfDay()</tt>===
===<tt>startOfWeek()</tt>===
===<tt>startOfMonth()</tt>===
===<tt>startOfYear()</tt>===
==Sprint-related Functions==
===<tt>closedSprints()</tt>===
===<tt>futureSprints()</tt>===
===<tt>openSprints()</tt>===
===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&#58;//....?...&sprint=873", then:
<syntaxhighlight lang='groovy'>
... sprint = 873 ...
</syntaxhighlight>
An alternative is to compose the query and wait for autocompletion after <code>sprint =</code>, while typing the first letters of the name of the sprint.


===startOfDay()===
Other way:
===endOfDay()===
<syntaxhighlight lang='groovy'>
===startOfWeek()===
... sprint = "Sprint 8, 1/4" ...
===startOfMonth()===
</syntaxhighlight>
===startOfYear()===


==Relative Time Comparison==
==Relative Time Comparison==
Line 40: Line 53:


==ORDER BY==
==ORDER BY==
{{External|https://www.atlassian.com/blog/jira-software/jql-the-most-flexible-way-to-search-jira-24}}


<syntaxhighlight lang='text'>
<syntaxhighlight lang='text'>
[...] ORDER BY  
[...] ORDER BY [...] DESC|ASC
</syntaxhighlight>
</syntaxhighlight>
* created
* updatedDate
* priority
* assignee


=Examples=
=Examples=
Line 52: Line 70:


  project = FDIS AND assignee = currentUser() AND resolution = Unresolved AND sprint = "Sprint 8, 1/4" ORDER BY updated DESC
  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

Latest revision as of 02:54, 24 June 2021

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