Feeding filter results into another Filter

Question

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

Bill Sheboy · Answer

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