JQL filtering tickets that have linked issue of a specific issue type

[Bastien Delourmel (FMX)]

Good morning,

We are looking for a JQL to find the tickets that have linked issue of a specific issue type.

We need that to prevent (with an automation) creation of a linkedissue, if a ticket type "problem" is already linked to an incident. 

Thanks a lot for your help!

[Bastien Delourmel (FMX) · Accepted solution]

Thank you all for your answers!

A way has been found with automation:

[Marc - Devoteam]

Hi @Bastien Delourmel (FMX) 

Welcome to the community

I'm not part of vendor, but I quite like the app JQL search extensions for jira 

We have made a lot of use of this app and really helped us out.

But the Enhanced search from Adaptavist will also help you out with your current issue, but your request will require an app.

[Deepak Jain]

Hi @Bastien Delourmel (FMX) ,

Welcome to the Atlassian Community.

You can try with the below JQL:

issuefunction in linkedIssuesOf("Project = ABC and issuetype = Problem")

Regards,

Deepak

[Bastien Delourmel (FMX)]

Hi @Deepak Jain , 

Thanks, however we do not have scriptrunner :/

Is it only disponible with scriptrunner?

Regards

[Deepak Jain]

Hi @Bastien Delourmel (FMX) ,

Yes, I believe it is not possible without third party plugin.

Regards,

Deepak

[Nic Brough -Adaptavist-]

Enhanced search (either as part of Scriptrunner, or on its own) is probably your only option, I can't find anything in the marketplace that can do this.

[Reece Smith]

Hi there @Bastien Delourmel (FMX) 

If you don't have/want the ScriptRunner app and you're looking for extended search capabilities, you can install Enhanced Search from the marketplace.

https://marketplace.atlassian.com/apps/1221331/enhanced-search-jql-subqueries?hosting=cloud&tab=overview

Kind regards,

Reece Smith
Product Marketing Manager for Enhanced Search