JQL to filter tickets that do not have a JPD idea linked

[Liam Kelly]

Does anyone know how to create a filter that I can apply to my kanban board that will show me only tickets that do not have any associated Idea in my product discovery ideas list? There is a parentEpic and parentProject, but I'm looking for something like 'parentIdea is EMPTY' or some equivalent.

[Liam Kelly · Accepted solution]

I solved this for myself, adding it here in case anyone else can find this useful because it took me forever to get it working and was very painful having never heard of scriptrunner.

What I ended up with is a filter that shows me tickets that do not have a relationship to an idea, or have a parent that does not have a relationship to an idea. The latter half of that is important if you create an epic as a delivery ticket in an idea and then want to consider its tasks/stories/bugs as also being linked to the idea.

Some downsides:

• if you create a 2nd layer of separation between the idea and the ticket it will not be captured in this, so Idea -> Epic -> Task -> Sub-Task will mean the sub-task falls through the cracks.
• if you have any other tickets that "implements" as a link type to another ticket they get caught up in this filter. I don't use that so it isn't an issue for me.
• this won't work in a team-managed project. It needs to be company-managed for scriptrunner to work.

Steps

Install:

• ScriptRunner Enhanced Search
• ScriptRunner for Jira
• Sync your tickets in ScriptRunner

1. Go to your board, if you're using the new UI, while in your project click on "ScriptRunner Enhanced Search" on the top nav bar, it should be on the far right.

2. Paste in the following JQL - this gives you all tickets with an idea linked

issuelinktype = "implements" OR issueFunction in subtasksOf("issuelinktype = 'implements'") OR issueFunction in issuesInEpics("issuelinktype = 'implements'")

3. Save the filter, give it a name like "tickets linked to ideas"

4. Go to your backlog, click 'Manage Quick Filters', and add this as a quick filter with the following JQL:

filter = "FILTER_NAME"

5. On the same page add a new filter called "No idea linked" Use the following JQL: 

project = YOUR_PROJECT AND filter != "FILTER_NAME"

This will be used to show tickets that don't have an idea linked. 

[Gary Spross]

You should be able to utilize the following in your JQL:

issueLinkType != "is implemented by"

[Liam Kelly]

Thanks! this got me on the right path.