Jira JQL: Difference between revisions
Jump to navigation
Jump to search
| Line 18: | Line 18: | ||
==Time Functions== | ==Time Functions== | ||
Also see [[#Time_Format|Time Format]]. | Also see [[#Time_Format|Time Format]]. | ||
===<tt>startOfDay()</tt>=== | |||
===startOfDay()=== | ===<tt>endOfDay()</tt>=== | ||
===endOfDay()=== | ===<tt>startOfWeek()</tt>=== | ||
===startOfWeek()=== | ===<tt>startOfMonth()</tt>=== | ||
===startOfMonth()=== | ===<tt>startOfYear()</tt>=== | ||
===startOfYear()=== | ==Sprint-related Functions== | ||
===<tt>closedSprints()</tt>=== | |||
===<tt>futureSprints()</tt>=== | |||
===<tt>openSprints()</tt>=== | |||
===Specific Sprint=== | |||
<syntaxhighlight lang='groovy'> | |||
... sprint in '' ... | |||
</syntaxhighlight> | |||
==Relative Time Comparison== | ==Relative Time Comparison== | ||
Revision as of 02:47, 24 June 2021
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()
closedSprints()
futureSprints()
openSprints()
Specific Sprint
... sprint in '' ...
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