Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Is it possible to query issues from multiple projects and then use the result in another jql?

Abe
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!
March 10, 2023

Hello every one!

 

I made a JQL filter that joins issues from four projects (Project 1, Project 2, Project 3 and Project 4) and then I use the result to generate a multi-project board in Project A. Here everything is working fine.

 

Now I’m trying to join issues from multiple projects (Project B, Project C, Project D AND Project A) but the JQL is not showing the results from projects 1, 2, 3 and 4 (actually is not showing any result from those projects).

 

The reason why I’m trying to do that is to show in a single board multiple projects, grouped in swimlines by project AND one of those projects grouping issues from other projects.

 

Is that possible? Is there any kind of restrictions to do this kind of nested querys?

 

Thanks in advance for your answers!!

E102BB07-A8F0-4FB5-A37F-FCA2B2D6BFF2.jpeg

2 answers

2 votes
Mikael Sandberg
Community Champion
March 10, 2023

Hi Abe,

It is only possible if you have an app that extends JQL, out-of-the-box JQL does not support nested queries. I know from experience that you can do this with Enhanced Search/Scriptrunner and JQL Tricks, but there are other apps in the Marketplace that can do this too.

1 vote
Kristopher Perez
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
March 10, 2023

Hey @Abe ,

it might help if you show us the JQL that works as expected and the one that doesn’t. We may be able to guide you with a little more clarity then.

 

My initial instinct, would be. In the second JQL to start with

filter = $filterId and …

This was you are working with a known good filter, but let’s see where you are getting stuck.

Kris

Suggest an answer

Log in or Sign up to answer