Jira JQL: Difference between revisions
Jump to navigation
Jump to search
(4 intermediate revisions by the same user not shown) | |||
Line 40: | Line 40: | ||
==ORDER BY== | ==ORDER BY== | ||
{{https://www.atlassian.com/blog/jira-software/jql-the-most-flexible-way-to-search-jira-24}} | {{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 53: | Line 57: | ||
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 |
Revision as of 00:49, 26 August 2020
External
- https://confluence.atlassian.com/jiracorecloud/searching-for-issues-765593657.html
- Advanced searching
Internal
Overview
Fields
Functions
Time Functions
Also see Time Format.
startOfDay()
endOfDay()
startOfWeek()
startOfMonth()
startOfYear()
Relative Time Comparison
updated >= "-1d"
Operators
~
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
[...] 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