nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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

Accepted answers

Daniel Ebers

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.

Bill Sheboy

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

All comments

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 P 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.

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.

Daniel Ebers

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

@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

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

Artyom Surzhikov

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

Jack Brickey

there is not an OOTB solution for this.

Bill Sheboy

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

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

cloud

jira-software

jira-software-cloud