Without an add-on, need epics with their stories and other story data in a filter

[Nick van der Net]

Hello Community,

Without using an add-on, I would like to be able to product a filter on ALL Epics, with ALL their associated stories, and other story-based field data please.

For example, 

We are an applications migration project. Our Applications are Epics, and the individual deployment and deployment types of the apps are stories.

I need to see a filter that for each Epic, I need their child stories and some associated data, so I can extract that to Excel.

Thanks guys!

[Pramodh M · Accepted solution]

Hi @Nick van der Net 

It is a bit difficult to get requirement done, but here is my solution, 

First, find the Epic issues by running the following query

project = "projectKey" and issuetype = "Epic"

Now that you have got the Epics, find the issues linked to Epic by running the following query

project = "projectKey" AND "Epic Link" in (epicKey-1, epicKey-2, epicKey-3,...) OR project = "projectKey" and issuetype = Epic

epicKey-1, epicKey-2, epicKey-3... are the keys that resulted from 1st query

Thanks,
Pramodh

[Nick van der Net]

Hi Pramodh, that seems like a two-step process? And given we have about 70 Epics, quite a significant query. Might be better to develop the query externally and then copy/paste into Jira.

Is it possible to have "epiclink = all" or some such?

[Pramodh M]

Hi @Nick van der Net 

You will get the Epics in CSV Format in the first result, which you can append in the second one.

There is no such way we can search like "epiclink = all"

Thanks,
Pramodh