JQL for missing initiative issue type

Scott Federman April 28, 2023

Is there a JQL that would allow me to identify which issues (epics, stories) do not have an initiative type issue listed in the linked issues field?

1 answer

0 votes
Clark Everson
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
April 28, 2023

Hi Scott,

This JQL should work, but keep in mind this will only work for epics because stories should be tied to epics

issuetype = Epic AND "Parent Link" is EMPTY

 

you can further restrict this to specific projects as well with an AND project in (x,y,z)

Best,
Clark

Scott Federman April 30, 2023

understood. and yes at the epic level we use parent link to tie to initiatives. However at the story level we used linked issues ("related to") link type to tie stories to initiatives. We want to be able to search through the linked issues on a story and pull a list of all stories that do not have an initiative type ticked linked to to it.

Suggest an answer

Log in or Sign up to answer