Forums

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

Feeding filter results into another Filter

Lukas Niechziol
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!
February 9, 2024

Hey, 

I have an issue regarding efficiently writing a filter. I have two different projects (A and B). Project B includes test cases which tests features (tickettype) in project A. The features are referring to one milestone on project B. I would like to have a filter which results in all test cases which are linked to features which are liked to a specific milestone. 

What I did so far is the following: 

project = B AND issue in (Linkedissues("B-27"), Linkedissues("B-28"), Linkedissues("B-21"), Linkedissues("B-35"), Linkedissues("B-41"), Linkedissues("B-24"), Linkedissues("B-38"), Linkedissues("B-37"), Linkedissues("B-36"))

 

Here I included all the features (B-XX) "by hand" into the query. 

However, the following query results in all the features I included "by hand" above. 

project = B AND issue in linkedIssues(B-19)

 

Is there any possibility to feed the output of the first filter into the second one ?

 

Thanks in advance :)

Lukas

1 answer

0 votes
Bill Sheboy
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.
February 9, 2024

Hi @Lukas Niechziol -- Welcome to the Atlassian Community!

JQL is not a SQL, and so does not have many features like joining queries.

With saved filters, they can be combined with AND or OR using their saved identifiers, such as:

filter=12345 AND filter=67890

There are marketplace addons which extend the features of JQL.  If you often need such queries, please investigate those addons: https://marketplace.atlassian.com/

Kind regards,
Bill

Suggest an answer

Log in or Sign up to answer