How to get stories linked to epics that have a specific label?

[Todd_Underwood]

Hi, 

We are running a project that has multiple epics associated with an overarching feature. We are labeling the epics with a label that denotes which feature it is a part of. 

As an example: 

1. Epic 1 - label = foo
   1. Story 1
   2. Story 2
   3. Story 3
2. Epic 2 - label = foo
   1. Story 4
   2. Story 5. 

I'm hoping we can write a query that looks something like this: 

epicLink is in (issueType =Epic & label is in (foo))

This would ideally return

• Story 1
• Story 2
• Story 3
• Story 4
• Story 5

Is something like this possible?

Thanks

[Christos Fousteris]

Hello,

i've come around this problem myself and the solution I found that seems to be working is the following:

issuetype = story and issueFunction in linkedIssuesOf("labels = foo", "is epic of")

This should return all Stories that are linked with issues having foo as label and their link type to the Story is Epic link.

I haven't tested this excessively but with a couple of alternative queries that looked like this...

issuetype = story and "Epic Link" in (Epic-1, Epic-2, Epic-x)

...where I had to specify the Epics with the right label one by one i got the same Stories so it should do the job indeed.

br, Christos

[AT]

Thank you. I had the same question and I could compile the list of stories/bugs based on epic link instead of using label. 

[Jack Nolddor _Sweet Bananas_]

Hi Paul,

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 you can type the following:

Search for issues within Epics having a given label 'foo' :

issue IN issuesInEpics("labels = foo")

Search Stories within Epics having a given label 'foo' :

type = Story AND issue IN issuesInEpics("labels = foo")

Note that these are just an exaple, you must tune your 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

Hope this helps you to create awesome queries <3

[Muhammad Ramzan_Atlassian Certified Master_]

As described by Bharatha, if you want to achieve without any plugin , please follow his steps.

But what you want to can only be possible by plugins who provides built in jql queries like : 

JQL Search Extensions for Jira & reports 

if you use above plugin you can get your results as below

following query will return all stories, their subtasks part of epics where epic label=foo.

issue in allIssuesInEpic("labels=foo")

following query will only return stories part of epic where epic lable=foo

issue in allIssuesInEpic("labels=foo") and type=story

[Bharath Kumar Kappala]

@Todd_Underwood If this is plain Jira without any add-on I am afraid the only possible way might be something like adding another label called foo-story to all the Issues liked to Epics in that project and add a JQL 

Project= "Project Name" and label = foo-story