JQl Query to identify missing Epics in a project, exclude in the Backlog section

[Jeff Murray]

I have created a query to show missing Epics in a project. I want to exclude issues that are in the backlog section. I want to include current sprint, groomed and ready, ready for grooming and support backlog sections in the project, thanks.

[said kouzibry · Accepted solution]

HI @Jeff Murray

Can you please provide more information about what you need,

• What do you mean by "Missing Epics", is it Epic that are no linked to any issues ?
• What do the terms "groomed and ready" and "ready for grooming" refer to ? are these statuses ?

It's important for us to properly understand your requirements and how your project is setup to provide accurate answers.

However assuming you want issues without Epic links that are in the statuses "groomed and ready" and "ready for grooming" in the current sprint, the JQL query would look something like this : 

project = "your project key" and sprint in openSprints() and status in ("ready for grooming","groomed and ready") and "Epic Link" is EMPTY

Hope this helps

[Jeff Murray]

Hello -

1) Missing Epics. Our Product team creates issues (Stories and Tasks) and at times leaves the Epic field blank. I (scrum master / PM) uses queries to have Product populate the Epic field.

2) Per the screen shot below (doesn't show current sprint), I want to have the query look through these (not sure what they are called) and exclude the "Backlog" section that is missing Epics.

[said kouzibry]

These are Sprints.

If sprints are not started you can refer to them as "futureSprints()" in your query.
This means that your final query would look something like this : 

project = "your project key" and ( sprint in openSprints() OR sprint in futureSprints() )and status in ("ready for grooming","groomed and ready") and "Epic Link" is EMPTY

It's also important to note that you should consider whether you want to take into consideration your Board filter, as it affects what you see on you backlog.