Export list of projects from all issues inside Epics within a project?

Question

Hi Guys

Bit of a complicated scenario I need help with.

I have a Roadmap Kanban Project which has about 30 Epics on it.

Each Epic has a component on it related to a programme of work.

Also, Each Epic on this board has issues from 8 other projects.

Is there a way to export a list of all projects that are assigned an Epic on this Roadmap board, and see which programme they relate to?

Example end result:

Project ROADMAP has 5 Epics tagged with component PROG-A with tickets from Projects (PROJECT-A, PROJECT-C, PROJECT-D)

Thanks

Ste Wright · Answer

Hi Umer,

I believe ScriptRunner for Jira Cloud comes with a separate search - see this wiki page for more details :)

Ste

Umer Saeed_eny21w · Answer

Hi Ste

Thank you for the detailed recommendations! I will give this a shot and see how it goes. Ultimately, I was hoping there would be an add-on or some tool that could automate this, rather than this manual process, because it is something that I would have to do monthly and the Epics can be updated/changed/new ones created at any time - so the excel could be outdated week after week.

We have ScriptRunner for Jira Cloud, but issueFunction doesn't seem to be one of the queries compatible with the cloud instance.

Thanks again

Umer

Ste Wright · Answer

Hi @Umer Saeed

To confirm I understand you want:

* All issues under your 30 Epics
* The Epics they're associated with
* The Component attached to those Epics

You could pull this in one query but I wouldn't - I'd do two and join them in Excel.

So, to get the Epics:

component in (PROG-A, PROG-B, PROG-C) and issuetype = Epic

^ This will give you a list of Epics. If you need the project name, key, etc included in the export - ensure you include the field "Project" on your issue search list view (select it from Columns).

Next, get your list of Issues:

"Epic Link" in (ABC-1, ABC-2, ABC-3)

^ This might seem arduous over 30 Epics - what I would do is use Excel to create the list inbetween the brackets - to do this:

* Take the list of Epic Jira Keys from the first export and copy into a new sheet, Column A
* Add a comma in B1
* Concatenate A1 and B1 together in C1 - then copy this down all rows
* In D1, enter "=C1"
* In D2, concatenate D1 and C2 - then copy this down all rows - the final cell will have a comma separated list you can enter into this query.

Include Epic Link on your export - and then you can use VLOOKUP to pull the Program component from the first list into the second. Remember to also include "Project" like above if you want this also.

----------------------------

You can simplify your search queries if you use an add-on - for example, if you use ScriptRunner you could use their epicsOf / issuesInEpics sub-queries - for example to find the child issues you could use:

issueFunction in issuesinEpics ("components in (PROG-A, PROG-B)")

Ste