This site is moving soon to become part of an integrated Appfire documentation and information site for our apps. This site will remain available during the transition to our new and improved site. Once this site is moved over, this banner will be updated with the new site link for easy access.
Take a look here! If you have any questions please email support@appfire.com
Epics JQL Functions
- Daniel Turczanski
- Deborah Scott
Try it free: ☁Cloud 🖥Data Center
The instructions on this page describe how to execute a JQL search using JQL Search Extensions.
- 1 Epics JQL functions
- 2 Epics JQL Aliases
- 2.1 issuesInEpicCount
- 2.2 bugsInEpicCount
- 2.3 storiesInEpicCount
- 2.4 issuesInEpicToDoCount
- 2.5 issuesInEpicInProgressCount
- 2.6 issuesInEpicDoneCount
- 2.7 bugsInEpicToDoCount
- 2.8 bugsInEpicInProgressCount
- 2.9 bugsInEpicDoneCount
- 2.10 storiesInEpicToDoCount
- 2.11 storiesInEpicInProgressCount
- 2.12 storiesInEpicDoneCount
Epics JQL functions
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
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