How to get a list of Epics that have issues from a particular project tied to them?

[samir koirala]

We are moving stories from one project to another. Before doing so, we need to move parent Epics first. 
is there a JQL to list out all the Epics that stories from Project A are tied to? 

[Florian Bonniec · Accepted solution]

Hi @samir koirala 

You cannot do that with JQL but you can from the one from apps such as Scriptrunner.

issueFunction in epicsOf("project = A and type = Story")

 You can also do it with multiple search

project = A and type = Story, then export all stories (including at least the "Epic Link" field)

Then in excel remove duplicate of the column "Epic Link" then copy all remaining value and run a JQL such

key in (list of epics keys)

Note that you shoud have add a comma to seperate the keys.

Regards

[mauricio.groth · Accepted solution]

Hi @samir koirala

As you're on Jira Server, the correct answer is to get an app that provides JQL extensions you're looking for.

With standard JQL, you can only get a list of issues and export them to Excel for further processing. This works if you want to do a one-off analysis. If your use case is more dynamic than that, look beyond standard Jira.

Standard JQL doesn't easily allow it, but you can quickly find the results using our professional indexing service JQL Search Extensions

You can use this function to find all epics that have a story from project A

issue in epicOf("issuetype = Story and Project = A”)

Check out the documentation for more examples. 

If you have any other questions, please contact our support. We’ll be happy to help you!
Best regards,
Maurício

[Hannes Obweger - JXL for Jira · Accepted solution]

Hi @samir koirala

just to add to Florian's answer, another option is to go with one of the hierarchy-focused apps from the Atlassian Marketplace. These apps often have more powerful ways of navigating and searching through issue hierarchies.

As an example, your use case would be trivial to solve in the app that my team is working on, JXL for Jira. You would simply,

• Create a sheet that contains a.), all your epics, and b.) all relevant stories from project "A", e.g. with a JQL statement like issueType = "Epic" OR (project = "A" and issueType = "Story"). Don't worry about the parent/child relationships; JXL will sort this out for you.
• In your sheet, enable the default hierarchy. That's a one-click operation.
• In your sheet, switch on the option to hide all empty top-level issues. That's again a one-click operation.

The resulting list of epics is exactly what you're looking for. You can now operate on these issues directly in JXL, trigger various Jira operations, or export your issues to e.g. Excel or Google Sheets.

This is how this looks in action:

(Just a note, as it seems like you're on Jira Server: While new apps can no longer be listed for Server on the Marketplace, JXL is perfectly compatible with Server; it's just that we need to generate a license for you. If you're interested in JXL, just let me know, I'm happy to create a free trial license.)

Best,

Hannes

[Madhu_RVS]

Hi @samir koirala 

Welcome to the community !!

If you are fine with a mktplace app, you can try out our plugin to view complete hierarchy of your cross project linked issues

Agile Tools : Epic Tree, Links Tree, Time in Status & Worklogs

Disclaimer : I am part of the team which developed this app