Query for items in Backlog not in sprint - list where EPIC is missing

Billie Jez

Hi All,

I'm trying to build a query where I can search all the hundreds of items that are missing and EPIC value ? I have the following checking in open sprint or future sprint, is there a way to search the entire backlog list ?

 

project = CS1 AND issuetype in (Bug, Epic, Feature, Issue, Risk, Story, Task, Test) AND sprint in (opensprints(), futureSprints()) AND "Epic Link" = EMPTY AND issuetype in (Bug, Epic, Feature, Issue, Risk, Story, Task, Test) AND status not in (done, cancelled)

Trudy P Claspill

Hello @Billie Jez 

Welcome to the community.

Are you working with a Team Managed project or a Company Managed project?

You have criteria to check the Sprints, the Issue Type, the Epic Link, and the Status.

Looking first at the Issue Type criteria, are you wanting to find all issues that are not linked to an Epic? This would exclude Epics themselves and Sub-tasks, because neither of those can be a child of an Epic.

Assuming that you are working with a Company Managed project the simple query would be

project=CS1 and issuetype != Epic and issuetype not in (subTaskIssueTypes()) and "Epic Link" is empty

The above query won't work if you are working with a Team Managed project.

What does it matter if the issue was ever in a sprint or is in a sprint currently, or what the status of the issue is? 

What problem are you trying to solve by getting this list?