Find ideas without delivery tickets

Tom Pennick
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
July 10, 2023

I would like to create a filter or a dashboard that shows all Idea type tickets that do not have delivery tickets linked to them.

I intend to use the same method to identify tickets within a specific Project (our UX & Design) that do not have associated ideas.

Is this possible to do with JQL?

1 answer

2 votes
Ted
Contributor
July 10, 2023

To get all the ideas that do not have linked delivery tickets, the JQL you are looking for is: 

project = "discovery project" AND issueLinkType not in ("is implemented by")

For the opposite, you can also narrow down to the specific project and use "implements" instead of "is implemented by". 

You might need to add another condition wherein you state issuetype = Idea if you have for example stories in your UX project that use the implements condition in relation to epics in that same project

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events