Epics

• Epics JQL Functions

  • epicsOfChildrenInQuery()

  • childrenOfEpicsInQuery()

• Epics JQL Keywords

  • issuesInEpicCount

  • bugsInEpicCount

  • storiesInEpicCount

  • issuesInEpicToDoCount

  • issuesInEpicInProgressCount

  • issuesInEpicDoneCount

  • bugsInEpicToDoCount

  • bugsInEpicInProgressCount

  • bugsInEpicDoneCount

  • storiesInEpicToDoCount

  • storiesInEpicInProgressCount

  • storiesInEpicDoneCount

Epics JQL Functions

EpicsOfChildrenInQuery

Retrieves the epics of issues that match a specified JQL subquery.

Examples:

• issue in epicsOfChildrenInQuery("'Team Name' = 'My great team'") and status='To Do' finds epics associated with your team that are still in ‘To Do’ status.

• issue in epicsOfChildrenInQuery("assignee = currentUser() AND updated > -1d") retrieves epics of your issues that have been updated in the last day.

ChildrenOfEpicsInQuery

Finds the child issues of epics that match a given JQL subquery.

Examples:

• issue in childrenOfEpicsInQuery("resolution is not empty") AND resolution is empty identifies unresolved issues that belong to resolved epics.

• issue in childrenOfEpicsInQuery("fixVersion = '21.0.1' AND component = UI AND labels = 'review'") finds child issues of epics with the specified fix version, component, and label.

Epics JQL Keywords

IssuesInEpicCount

Searches for epics with a specific number of child issues, regardless of issue type.

Example:

• issuesInEpicCount > 5 finds epics that have more than five child issues.

BugsInEpicCount

Searches for epics that contain a particular number of bugs.

Example:

• bugsInEpicCount = 2 retrieves epics with exactly two bugs.

StoriesInEpicCount

Searches for epics with a specific number of stories.

Example:

• storiesInEpicCount >= 3 finds epics that have three or more stories.

IssuesInEpicToDoCount

Finds epics with a certain number of child issues in the “To Do” status category.

Example:

• issuesInEpicToDoCount > 0 identifies epics that have child issues awaiting action.

IssuesInEpicInProgressCount

Searches for epics with a specific number of child issues in the “In Progress” status category.

Example:

• issuesInEpicInProgressCount = 1 retrieves epics with exactly one child issue currently in progress.

IssuesInEpicDoneCount

Finds epics with a certain number of child issues in the “Done” status category.

Example:

• issuesInEpicDoneCount < 5 identifies epics with fewer than five completed child issues.

BugsInEpicToDoCount

Searches for epics that have a specific number of bugs in the “To Do” status category.

Example:

• bugsInEpicToDoCount >= 1 finds epics with at least one bug yet to be addressed.

BugsInEpicInProgressCount

Finds epics with a certain number of bugs in the “In Progress” status category.

Example:

• bugsInEpicInProgressCount = 0 retrieves epics with no bugs currently being worked on.

BugsInEpicDoneCount

Searches for epics that have a specific number of bugs in the “Done” status category.

Example:

• bugsInEpicDoneCount > 0 identifies epics where at least one bug has been resolved.

StoriesInEpicToDoCount

Finds epics with a certain number of stories in the “To Do” status category.

Example:

• storiesInEpicToDoCount = 2 retrieves epics with two stories waiting to be started.

StoriesInEpicInProgressCount

Searches for epics with a specific number of stories in the “In Progress” status category.

Example:

• storiesInEpicInProgressCount > 1 identifies epics with more than one story currently in progress.

StoriesInEpicDoneCount

Finds epics with a certain number of stories in the “Done” status category.

Example:

• storiesInEpicDoneCount = 0 retrieves epics where no stories have been completed yet.