CODEWITHSUNDEEP
jirajql
Raaz
Raaz

Reputation: 23

JQL Selecting all Epics that have no stories

I'm trying to figure out how to create a select that would bring up all empty epics (those that have no stories in them) so I could easily tell which ones need filling.

Selecting stories that have or do NOT have an epic link is easy. I can not seem to find a way to search the other way around.

This is where I am right now:

issuetype = Epic AND project = projectname AND Issues in Epic is EMPTY

The part after the last AND is what I need the code to do and can not seem to figure out.

Upvotes: 2

Views: 7013

Answers (1)

GlennV
GlennV

Reputation: 3670

This is not support with JQL out of the box, but there are a few add-ons that do provide support for this.

The most common one is the Script Runner add-on which comes with a number of additional JQL functions like hasLinkType, that you can use for your scenario in a query like this:

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

Upvotes: 1

Related Questions