Nested query to list tickets only if they are linked to tickets in another project

[Tobbe Wilson]

Hi,
Can anyone tell me if it's possible, and if so, how to create a nested query to list tickets from "Project 1" only if they are linked with a certain issuelink, to a ticket in "Project 2" where the tickets in "Project 2" has a certain value in a custom field?

Not sure i'm making myself clear here, but let's see.

Thanks in advance!

[Prosper Agwegiokhe]

Hi @Tobbe Wilson,

Welcome to the Atlassian Community!

My name is Prosper, and I’m a Support Engineer at Appfire. I’m here to assist you.

If you’re open to trying a plugin suggestion, I recommend our app JQL Search Extension for Jira.

Here’s a sample query based on your use case:

project=1 AND issue IN linkedIssuesOfQuery("project=2 AND {customfield} = value")  

You can modify this query by replacing placeholders like project=1, project=2, and {customfield=value} with your actual project keys and field values.

For more details about this query, you can refer to our documentation here. Please feel free to contact our support team if you have any further questions or need additional assistance.

We’re happy to help!

Best regards,
Prosper

[Davide Cascapera]

Hi @Tobbe Wilson ,

if you are using the Clud Version, you need a plugin that extends the JQL function as enanched search by Script Runner.

here https://support.atlassian.com/jira-software-cloud/docs/jql-functions/ you can find the list of function that you can use without any plugin

I'l hope this answer can be usefull

Regards