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; } } }

EPIC without links / issues

Roger_mko8im

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

Accepted answers

All comments

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

Roger_mko8im

It total means NOT with the standard JQL possible

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.

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_mko8im

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

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.

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-cloud