Difference between revisions of "Jira JQL"

From NovaOrdis Knowledge Base
Jump to: navigation, search
(ORDER BY)
(ORDER BY)
Line 43: Line 43:
  
 
<syntaxhighlight lang='text'>
 
<syntaxhighlight lang='text'>
[...] ORDER BY updatedDate
+
[...] ORDER BY [...] DESC|ASC
 
</syntaxhighlight>
 
</syntaxhighlight>
 +
* created
 +
* updatedDate
 +
* priority
 +
* assignee
  
 
=Examples=
 
=Examples=

Revision as of 20:39, 29 June 2020

External

Internal

Overview

Fields

Fields

Functions

Functions Reference

Time Functions

Also see Time Format.

startOfDay()

endOfDay()

startOfWeek()

startOfMonth()

startOfYear()

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