List all EPICs and all their children (without using ScriptRunner)

Question

I don't have ScriptRunner, so please don't show solutions using ScriptRunner.

I want to show all EPICS in my project and all child issues of those EPICs in the search results for a major bulk edit operation.    In my previous job I had ScriptRunner and it was easy with ScriptRunner.  I've tried a multitude of statements including trying to get parentEpic to work for a "filter" of the EPICS.    Any help would be appreciated.

Jack Nolddor [Sweet Bananas] · Answer

Hi Dave,

As @Radek Janata already commented if issues under your project are not linked to others epics outside the project you can use the JQL suggested on their answer.

Otherwise, you must go for a third-party app instead. Using i.e. JQL Booster Pack you can type the following:

1) Show all EPICS in my project and all child issues of those EPICs

(project = XXXX AND type = Epic) OR issue IN issuesInEpics( 'project = XXXX AND type = Epic' )

(*) Note that this is just an example, you must tune above query to fit your needs.

Using this app you can also query other issues relations, check:

* epicsOf()
* hasSubtasks()
* issuesInEpics()
* linkedIssuesOf()
* parentsOf()
* portfolioChildOf()
* portfolioParentOf()
* subtasksOf()

References:

* Official documentation

Hope this helps you to create awesome queries <3

Radek Janata · Answer

Hi Dave,

try this JQL query:

project = XXX AND (issuetype = Epic OR "Epic Link" is not EMPTY)

There's only one slight problem. It may also find issues in your project (XXX) that are linked to Epics in different project (YYY). If this is not your case or a problem, then the JQL above should help.

Regards,
Radek