JQL for missing initiative issue type

[Scott Federman]

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?

[Clark Everson]

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]

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.