List all tasks under user stories that are under epic

[Olafur Johannsson]

Structure is:

Epic -> user stories -> tasks or bugs 

How can I list all tasks / bugs that belong to 2 or more epics.

[Mikael Sandberg · Accepted solution]

You could either search for all issues that have the epics in question in epic link, but you would have to manually enter the keys for the epics (if you are linking your tasks/bugs to the epic). Another option is to use an app, ScriptRunner and JQL Tricks can be used for nested JQLs.

[Olafur Johannsson]

I have scriptrunner but I have never used it.
Can you give me an example?
Lets say I have epic-123 which has 3 user stories and under each user story are 5 tasks. So I need to get a list of those 15 tasks.

[Mikael Sandberg]

To do it in ScriptRunner you would have to create a filter that gets the stories associated with the epic, something like this:

issuesInEpics("issuekey = epic-123")

Save that filter (in the example the filter is named Stories in Epic), and then use it in another query:

filter = 'Stories in Epic' or issueFunction in linkedIssuesOf("filter = 'Stories in Epic'")

[Ethan Foulkes]

Hi Olafur,

I do not know how in ScriptRunner but if helpful you can do this using the Power Scripts add-on.

There is a video tutorial walking you through in detail here.

The code is simple:

string [] tasks;
string [] stories;
string [] epics = selectIssues("issueType = 'Epic' AND project = " + argv[0]);
for(string e in epics) {
    string [] stry = allLinkedIssues(e, "Epic-Story Link");
    for(string s in stry) {
        string [] tsk = allLinkedIssues(s, "jira_subtask_link", 1);
        tasks += tsk;
    }
    stories += stry;
}
string [] results;
results = arrayUnion(epics, stories);
results = arrayUnion(results, tasks);
return results;

Hope this helps!

[Nebojsa Ristic]

If epic id is for example "MYPROJECT-1234" you can find all subtasks under that epic using JQL filter query on Jira Advanced Search page:

parentEpic = MYPROJECT-1234

 if you want to filter only issues that are not epics or stories use:

parentEpic = MYPROJECT-1234 and type NOT IN (story, epic)

[Jeroen Vandeweghe]

This doesn't work on stock Jira, probably you have ScriptRunner or something installed?

[Mikael Sandberg]

@Jeroen Vandeweghe parentEpic is one of the JQL functions if you are using Jira Cloud, see Advanced searching functions reference. For Jira Server you need an app like Scriptrunner or JQL Tricks. There is a request to have parentEpic added to Jira Server, see JRASERVER-59181. If you would like to see that function added, I would recommend that you go and vote for it and add yourself as a watcher on the issue.