Find all Epics which are under a certain set of epics that contain a story with a specific label

[Anton Huber]

Hello Community,

I have a rather hard nut to crack here I think.

• I have  set of epics, lets just call them "W-Epics"
• They are blocked by a second set of epics, lets just call them "X-Epics"
• Those X-Epics have a related Story, let's call it "Y-Story". 
• The Z-Story either has a label ("Z-Label") or doesnt have a label

Now I would like to run the following queries within my project:

Show me all W-Epics, that are blocked by a X-Epic and have a related Y-Story which has the Z-Label.

and

Show me all W-Epics, that are blocked by a X-Epic where the X-Epic has the description text "XYZ".

I unfortunately wasn't able to advance further than the following, displaying all Epics without attached stories:

project = XXX AND issuetype = Epic AND issueFunction not in epicsOf("project = XXX") AND summary ~ W

Anyone able to help me with this query? :-)

Thanks in advance!

[Jack Nolddor _Sweet Bananas_ · Accepted solution]

Hi Anton,

Sadly you cannot achieve the desired search using standard features on Jira, you must go for a third-party app instead. Using i.e. JQL Booster Pack if you are on Server / DataCenter, you can type the following:

1) The Z-Story either has a label ("Z-Label") or doesnt have a label

project = MyProject AND type = Story AND (labels = Z-label OR labels is EMPTY )

* Save this as a filter with an meaningful name,... i.e. Z-Stories

2) Those X-Epics have a related Story, let's call it "Y-Story".

project = MyEpicProjects AND issue IN epicsOf(' filter = Z-Stories  ')

* Save this as a filter with an meaningful name,... i.e. X-Epics

3) I have  set of epics, lets just call them "W-Epics", they are blocked by a second set of epics, lets just call them "X-Epics"

type = Epic AND issue IN linkedIssuesOf(' filter = X-Epics ', 'blocks')

(*) Note that this is just an example, you must tune above query to fit your needs.

Using this app you can also query other issues relations, check:

• epicsOf()
• hasSubtasks()
• issuesInEpics()
• linkedIssuesOf()
• parentsOf()
• portfolioChildOf()
• portfolioParentOf()
• subtasksOf()

References:

• Official documentation