EPIC without links / issues

[Roger]

Hello

Targe ist to find alle EPIC which have not linkedIssues, means Empty EPIC.

I try to find a solution (there many entries here but not find the right solution)

a) project = ABC and issueType = EPIC and parent is EMPTY and issuetype not in (Epic,Subtask)

=> parent with EMPTY not allowed in my jira

b) project = ABC and isseuTpye = EPIC and hasLinkType("Epic-Story Link")))

=> hasLinkType not existing in my jira

c) project ABC AND issuetype = EPIC AND numberOfLinks = 0

=> numberOfLInks not exist in my jira

Same with IssueFunction ... 

=> IssueFunction not exist in my jira

[Roger]

It total means NOT with the standard JQL possible

[Jehan Bhathena]

Hey @Roger 

You're right on the part that isn't feasible with JQL directly, but I would hihgly recommend trying out the Jira Cloud for Excel method

(Mentioned here https://community.atlassian.com/t5/Jira-questions/Re-EPIC-without-links-issues/qaq-p/2745049/comment-id/1031079#M1031079), this is one of the most flexible methods available for use with Jira, that lets you filter out data with Excel's capabilities.

[Prosper Agwegiokhe]

Hi @Roger,

I’m Prosper, a support engineer at Appfire, and I’m here to help you.
Sadly, natively, you’ll not be able to find epics without links or issues.

However, the app my team works, JQL Search Extensions for Jira, you can use the query below to get your desired results:
issuesInEpicCount = 0 and issueLinkType is EMPTY

Please contact our support if you have any other questions about this query.
We’ll be happy to help you!

Best regards.

[Roger]

Thanks ... i am disappointed that this simply JQL are not able to get out of the box as standard from Atlassian

[Jehan Bhathena]

Hi @Roger 

The functions mentioned are mostly part of plugins like script runners or something else.

You can leverage Jira Cloud for Excel  https://marketplace.atlassian.com/apps/1221301/jira-cloud-for-excel-official?tab=overview&hosting=cloud

This come bundled with any Jira instance and can be very flexible for such use cases.

Let us know how it goes.

[Jehan Bhathena]

If you don't have a excel license https://marketplace.atlassian.com/apps/1220382/jira-cloud-for-google-sheets-official?tab=overview&hosting=cloud use this instead.

[Magdalena Zhisheva]

Hi @Roger , 

You may take a look here: https://community.atlassian.com/t5/Jira-questions/In-JQL-how-do-I-query-for-Epics-with-no-child-Issue-Links/qaq-p/1563646