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

[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 -