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

Tobbe Wilson
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
December 6, 2024

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!

2 answers

0 votes
Prosper Agwegiokhe December 6, 2024

 

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

0 votes
Davide Cascapera
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
December 6, 2024

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

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PERMISSIONS LEVEL
Product Admin
TAGS
AUG Leaders

Atlassian Community Events