Is there a way to show epics that have no linked Issues?

Question

We often add an Epic to a project as a reminder and want to build a filter of all epics that have no Issues associated to them.

I was thinking of a few ways to do this in a cross tab, but having trouble building the query. Seemed like linkedIssue is Empty would be a good way to go, but JQL doesnt seem to like that.

Any thoughts or ideas? Thanks!

Jay Smith · Answer

Is there a solution for Jira Cloud?

Sneha Sheth · Answer

Hi Larry,

The query that can be used is this (requires the script runner plugin):

issuetype=Epic and issueFunction not in hasLinkType("Epic-Story Link")

This will show all the epics that don't have any issues associated to them.

Thanks,

Sneha