Help with a JQL query

[Brian Andrade]

I'm doing some backlog cleanup on a project I inherited and there are a large number of Epics with only 1 or 2 Open issues associated with the Epic. I want to identify these Epics so that I can validate whether they need to exist or not.

I'd like to create a JQL query that will filter out all the Epics in my backlog with less than 10 associated issues. Is that something that's even possible in JQL? If not, does anyone have any recommendations to quickly identify these without having to click through each Epic individually?

[Nguyen Tran]

Hi Brian,

I don't think this is possible using JQL. I would suggest doing this:

• Create a filter that show all the issues in projects that you need to do Epic cleanup
• Use a "Two dimensional Filter statistic" gadget on your dashboards. 
• 1 Axis would be project and the other is Epic Link

It can show you the number of links that goes into an Epic so you can quickly see which Epic has less than 10 associated issues.

Regards,