JQL: How to filter by issue link value?

Question

Hi, 
I'm using filters to locate tickets that have issues,
for example:
"Tickets that aren't linked to other tickets that contain "RDV" in their name".

So far the only thing I could create was a filter that locates tickets that have no linked issues...

I have tickets that linked to issues contain "SUP" and issues contain "RDV".
I want to locate all the tickets that has no linked issues that contain "RDV".
Tried to use !~ but it didn't work. any suggestions?
Can I filter for specific values?

Thanks

project = "SUP" AND type = Bug AND issueLink !~ RDV

Hannes Obweger - JXL for Jira · Answer

... and to expand on my last point: If you're open to solutions from the Atlassian Marketplace, I believe that this would be easy to do using the app that my team and I are working on: JXL for Jira.

JXL is a full-fledged spreadsheet/table view for your issues that allows viewing, inline-editing, sorting, and filtering by all your issue fields - including your issues' linked issues - much like you’d do in e.g. Excel or Google Sheets.

One of the column filtering techniques that is available for all columns is text filtering, which supports logical operators such as AND, OR, or NOT.

With this, you should be able to find the required issues in just a couple of clicks:

Once you've narrowed down your list of issues, you can work on your issues directly in JXL, trigger various operations in Jira, or export your issues with just one click.

I should also add that JXL can do much more than the above: From support for configurable issue hierarchies, to issue grouping by any issue field(s), sum-ups, or conditional formatting.

Any questions just let me know!

Hannes Obweger - JXL for Jira · Answer

Hi @Shay Yadid Erez

welcome to the community!

To the best of my knowledge, this isn't natively supported in Jira/JQL - you'll need extra tooling. You probably know that you can always export your data and perform some kind of external search. Alternatively, if you're open to solutions from the Atlassian Marketplace, there's a number of apps available that either extend JQL by additional functions, or provide their own, more powerful search mechanisms.

I'll provide more information below.

Hope this helps,

Best,

Hannes

Bharat Kalia · Answer

@Shay Yadid Erez - If you have "Scriptrunner" plugin installed, then only this query will work.

Please see below -