Get all issues which have Epics in a specified project

[Artyom Surzhikov]

Hey, is there any chance to get all issues which have in Epic Link, Epics from a specific project? 

Ideally I'd have something like this

"Epic Link" in (project = XXX and issuetype = Epic)

Which I'd expect to return the list of Epics in XXX project, and after which jira would return the list of tickets which have Epic Link in the returned list, can anyone come up with a simple solution for that? 

Thanks in advance 

[Bill Sheboy · Accepted solution]

Hi @Artyom Surzhikov 

How often do you need this issue list, and how much work do you want to do?

As many noted, if you need this often and want it easy, a marketplace add-on is the way to go.

If this is needed less frequently, and/or you are managing add-on costs, here is a free (out of the box) solution:

• Run a query for all epics in your project: 

  project = XXX and issuetype = Epic

• Export the results
• Open with your favorite spreadsheet tool or editor, and save just the keys as a CSV list

KEY-1, KEY-2, KEY-3...

• Run another query using the resulting list

key IN (KEY-1, KEY-2, KEY-3...) OR parentEpic IN (KEY-1, KEY-2, KEY-3...)

Best regards,

Bill

[Artyom Surzhikov]

THanks @Bill Sheboy I've got it done exactly like that, but amount of the Epics can change within the time. So you probably understand the problem raising from this, but thanks for suggesting 

[Daniel Ebers · Accepted solution]

With the following suggestion I received issues of several types (here: bug, request, story) ONLY when they have the project "DEMO", which I am interested in, in "Epic Link".

issueFunction in issuesInEpics("project in (DEMO)")

This also means I received results from other projects, like TODO, BUG and REP - all of them certainly having an Epic Link to DEMO.

Please double check if this is what you are looking for. This implementation, like Taranjeet mentioned, is also using Script Runner.

[Artyom Surzhikov]

Thank you @Daniel Ebers will see if I can find an out-of-the-box solution first 

[Taranjeet Singh]

Hi @Artyom Surzhikov , I am not 100% sure, but as far as I remember, there is a JQL function in ScriptRunner add-on, which is EpicsOf(), which can help you in your query.

The JQL query may be something of the below nature:

"Epic Link" in (issueFunction in EpicsOf("project=XXX"))

Please give it a try if you have ScriptRunner add-on in your Jira instance.

[Artyom Surzhikov]

Hi @Taranjeet Singh I don't have a ScriptRunner before I go into a payed solution I'm looking to find an out of the box one, but thanks a lot for suggesting 

[Jack Brickey]

there is not an OOTB solution for this.

[Jack Brickey]

project = xxx and (type = epic or (type in (story, task) and "epic link" is not empty)

the above will exclude sub-tasks

[Trudy Claspill]

I'm not sure that will get what was requested.

That will return the Epics and Stories/Tasks that have an Epic Link value that are all in the same project (XXX). 

@Artyom Surzhikov are your Epics and Stories/Tasks in the same project?

[Jack Brickey]

sorry...misunderstood your request. :-(

i think you are going to need an addon e.g. Scriptrunner. this isn't possible OOTB.

[Artyom Surzhikov]

@Trudy Claspill My tasks (linked to an epic) can be scattered across different project, but my initial Epics are in one Project. So basically, I want to get all Epic of a project, and then find all tasks, stories and sub tasks which have Epic link in the obtained list of the Epics. Hope that's clear enough ? 

[Artyom Surzhikov]

@Jack Brickey That one actually as mentioned brings back only Epics and would look like this

project = XXX AND (type = Epic OR (type in (Story, Task)) AND "Epic Link" is not EMPTY)

 And, @Trudy Claspill is right it does not give me what was requested 

[Jack Brickey]

yes that is why my last response conveyed that I misunderstood and you cannot get where you want OOTB. Look to Scriptrunner or other addon solution.