Try it free: ☁Cloud 🖥Data Center
| Info |
|---|
The instructions on this page describe how to execute a JQL search using JQL Search Extensions. |
| Table of Contents | ||||||
|---|---|---|---|---|---|---|
|
Epics JQL functions
| Info |
|---|
JQL functions are accessible from Extended Search screen or via Extended Search filters in Jira advanced search. |
EpicsOfChildrenInQuery
For a given JQL subquery it finds the epics of the resulting issues.
Examples:
issue in epicsOfChildrenInQuery("'Team Name'='My great team'") and status='To Do' finds my team’s epics that are still in progressissue in epicsOfChildrenInQuery("assignee=currentUser() AND updated>-1d") finds epics of my issues that where updated over the last day
ChildrenOfEpicsInQuery
For a given JQL subquery it finds the children of the resulting epics.
Examples:
issue in childrenOfEpicsInQuery("resolution is not empty") AND resolution is empty finds issues in progress that belong to an epic which has finishedissue in childrenOfEpicsInQuery("fixVersion='21.0.1' AND component=UI AND labels='review'") finds children of epics with particular version, component and label
Epics JQL Aliases
| Info |
|---|
The following table summarizes the JQL aliases for ticket counts in the epic. Counts are based on the issue type and status. |
Status \ Issue type | Any status | TO DO | IN PROGRESS | DONE |
|---|---|---|---|---|
Any issue type | issuesInEpicCount | issuesInEpicToDoCount | issuesInEpicInProgressCount | issuesInEpicDoneCount |
Story | storiesInEpicCount | storiesInEpicToDoCount | storiesInEpicInProgressCount | storiesInEpicDoneCount |
Bug | bugsInEpicCount | bugsInEpicToDoCount | bugsInEpicInProgressCount | bugsInEpicDoneCount |
issuesInEpicCount
Search for epics with a particular number of child issues regardless of issue type
bugsInEpicCount
Search for epics with a particular number of bugs
storiesInEpicCount
Search for epics with a particular number of stories
issuesInEpicToDoCount
Search for epics with a particular number of child issues in "To Do" status category
issuesInEpicInProgressCount
Search for epics with a particular number of child issues in "In Progress" status category
issuesInEpicDoneCount
Search for epics with a particular number of child issues in "Done" status category
bugsInEpicToDoCount
Search for epics with a particular number of bugs in "To Do" status category
bugsInEpicInProgressCount
Search for epics with a particular number of bugs in "In Progress" status category
bugsInEpicDoneCount
Search for epics with a particular number of bugs in "Done" status category
storiesInEpicToDoCount
Search for epics with a particular number of stories in "To Do" status category
storiesInEpicInProgressCount
Search for epics with a particular number of stories in "in Progress" status category
storiesInEpicDoneCount
Search for epics with a particular number of stories in "Done" status category