Epics
The examples on this page describe how to build a JQL search using JQL Search Extensions.
Epics JQL functions
JQL functions are accessible from the Extended Search page or 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 were 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 a particular version, component, and label
Epics JQL keywords
The following table summarizes the JQL keywords 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 the To Do status.
issuesInEpicInProgressCount
Search for epics with a particular number of child issues in the In Progress status.
issuesInEpicDoneCount
Search for epics with a particular number of child issues in the Done status.
bugsInEpicToDoCount
Search for epics with a particular number of bugs in the To Do status.
bugsInEpicInProgressCount
Search for epics with a particular number of bugs in the In Progress status.
bugsInEpicDoneCount
Search for epics with a particular number of bugs in the Done status.
storiesInEpicToDoCount
Search for epics with a particular number of stories in the To Do status.
storiesInEpicInProgressCount
Search for epics with a particular number of stories in the In Progress status.
storiesInEpicDoneCount
Search for epics with a particular number of stories in the Done status.