JQL to find items on Jira board NOT linked to JPD

[Tami King]

Hi all,

I am trying to clean up the boards/backlogs at my company and want to try and filter for only those  that have not yet been linked to Jira Product Discovery Idea

So far I've been unsuccessful in figuring out the query that will produce the results I'm looking for

Does anyone have any idea how I can figure this one out, please?

Thanks!

[Bill Sheboy · Accepted solution]

Hi @Tami King 

Do you mean the "Delivery Ticket" linking in JPD?

If so, that uses a special link type which has a generic and a specific name.  The specific name is needed to confirm only JPD Delivery Ticket items.  (When only the generic name of "Implements" is used, that could find other work items not linked to JPD Ideas.)

For example, this would find the work items which have no link to a JPD idea or no links at all:

project = myProject
 AND ( issueLinkType != "Polaris work item link"
       OR issueLinkType IS EMPTY )

Thus, you could use such a filter as a Quick Filter (company-managed project) or a Custom Filter (team-managed project).

Kind regards,
Bill

[Tami King]

Ah!  thanks so much!