How to find stories in a set of epics?

Hi all,

In JIRA 5.1.3 /GH 6.2.4.1, I would like to find "all stories linked to the epics assigned to me" or as another example "all stories linked to the epics within a component".
In this scenario, we are using the GH provided Epic Link field and not the standard jira linked issues functionality.

I started writing this out as:

project = code AND "Epic Link" in (project = code AND type = epic and assignee=currentuser())

This fails with the following error:

Error in the JQL Query: Expecting ',' or ')' but got '='. (line 1, character 44)

Looking at the Epic Link field, it happily takes the IN operator and am able to manually build a set of epics or use a function like votedIssues() or watchedIssues() but no way to pass another query or filter.

Has anyone solved this in JQL or with add-ons?

6 answers

1 accepted

3 votes

Try reading Nicholas Muldoon's post here...http://www.nicholasmuldoon.com/2013/06/using-the-epic-workflow-in-greenhopper/

For a first step, you can get the stories of unresolved epics with:

issueFunction in linkedIssuesOf("issuetype = Epic and resolution is empty", "is epic of")

(linkedIssuesOf docs).

Thanks Jamie!

I wasn't aware of the "is epic of" relationship type and figured i was just limited to the jira relationships, causes, blocks etc.

First you create a filter for your epics as desired --> My Epic Filter

You can then use the issuefunction. Because the filter contains whitespace, you have to quote the name and because it is used within double quotes you have to use single quotes.

issueFunction in linkedIssuesOf("filter = 'My Epic Filter'", "is epic of") OR filter = "My Epic Filter"

With the OR-part you will get the epics as well.

 

This works for me too! Thanks !! 

1 vote
Timothy Chin Community Champion Jul 21, 2013

"Epic Link" takes a list of values. It can't take another JQL.

You could try:

project = GreenHopper AND "Epic Link" = GHS-9520 and issuetype = "Stories" and assignee=currentuser()

Timothy,

I see that "Epic Link" will take a single issue or a list of issues but i'm looking for a way to generate that list based on a filter, JQL or function.

The way i'm doing this for now is to manually build out the set for EPIC LINK to accept:

project = code AND type=story AND "Epic Link" in (CP-123, CP-1234, CP-12345)

Depending on how often we have to do this, I may put together an excel workbook that gets the list of issue ids via the REST ws but I expect that the copy & paste approach will win out for a while.

Addendum:

This would be similar to the view that one gets in the Agile Board, Plan View when clicking an Epic Name.

I am trying to get the items that are shown in the Sprints or Backlog in JQL.

This worked for me:

issueFunction in linkedIssuesOf("issuetype = Epic and component IN (MyComponent)", "is epic of")

...now if I can just figure out how to pull in the subtasks for the stories in those epics...

Suggest an answer

Log in or Sign up to answer
How to earn badges on the Atlassian Community

How to earn badges on the Atlassian Community

Badges are a great way to show off community activity, whether you’re a newbie or a Champion.

Learn more
Community showcase
Posted Wednesday in Jira

Join our webinar: How 1B+ feature flag events helped us build the new Jira

Every time you release software, there's a bit of risk – that there's a bug, that something breaks, or that the feature doesn't resonate with customers. Feature flagging helps make high stakes s...

111 views 0 3
Join discussion

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you