JQL: How to filter by issue link value?

[Shay Yadid Erez]

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]

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

[Hannes Obweger - JXL for Jira]

... 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!

[Bharat Kalia]

Hi @Shay Yadid Erez - Welcome to the community. Can you please try something like this - 

JQL - 

project = SUP  AND issueFunction not in linkedIssuesOf("Text ~"RDV"") and type = BUG

This will give you tickets that doesnot have "RDV"  in their linked tickets..but you will need scriptrunner for this. 

Thanks,

Bharat

[Shay Yadid Erez]

Hi and thank you!
I've got the following error:
"Expecting ')' or ',' but got 'RDV'. (line 1, character 64)"

[Bharat Kalia]

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

Please see below -