Get the Jiras which belong to epics with a specific label

[Marios K]

Hello,

I would like to have a JQL query which returns the list of JIRAs which are under epics that contain a specific label.

Assuming...

• Epic: PROJ-123
  • STORY: PROJ-1230
  • STORY: PROJ-1231
• Epic: PROJ-124
  • STORY: PROJ-1240
  • STORY: PROJ-1241

PROJ-123 and PROJ-124 have the label: 'CoolFeature'

...the result should be:

• PROJ-1230
• PROJ-1231
• PROJ-1240
• PROJ-1241

[Lucas Modzelewski _Lumo_ · Accepted solution]

@Marios K Welcome to the community!

It seems that there was almost an exact question here: https://community.atlassian.com/t5/Jira-questions/How-to-get-stories-linked-to-epics-that-have-a-specific-label/qaq-p/1322917 

[Marios K]

Hello Lukasz,

Thank you. The link you've shared was perfect and found the solution there.

For completeness, here is my final query:

project = <Project name> AND labels in (<label>) OR (issueFunction in linkedIssuesOf("labels = <label>", "is epic of")) AND (resolution = Unresolved) order by priority