Forums

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

Can each output entry of one JQL query used as input of another JQL query?

Tanuj Sinha
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 8, 2019

Hello,

I am trying to create JQL that should itself use another JQL. From the output of the first, I want to check a specific field and then show data is it even possible?

For Example :

Xray Test Set contains multiple tests.

My first query is on test sets which fetches me multiple test sets and then I want to iterate over each test present inside each test set.

Please let me know what could be the solution to this.

Thanks in advance.

 

Regards,

Tanuj

 

1 answer

0 votes
Petter Gonçalves
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
February 8, 2019

Hello Tanuj,

Welcome to Atlassian Community!

You can reference other filter queries in a JQL query by using the parameter filter. Let me give you an example:

- You created a filter called "Epics" and saved it with the following query:

Issuetype = Epic

- Then, you decided that you would like to return in a JQL Query all the issues returned from "Epics" filter there are in the project "TST". You just need to perform the query below:

project = TST and filter = Epics

Let me know if this is the option you are looking for.

Narasimha murthy
Contributor
May 16, 2019

i created one filter "filter name"and tried to use it another query but when i say "filter = ' filter name'" i didnt get that filter as an option

Petter Gonçalves
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
May 17, 2019

Hello Narasimha,

Are you adding two quotation marks with the apostrophe as you mentioned or you just added it to reference in the community message? 

"filter = 'filter name'"

You should search with the two quotation marks only in the filter name. Like this:

filter = "filter name"

Additionally, make sure you are not running the filter over the same filter since it will cause a cyclical reference. Explaining better:

Ensure that you are not running the filter query when editing the same filter referenced in the query, like in the screenshot below:

Screen Shot 2019-05-17 at 10.57.12.png

That been said, ensure you clicked on Search Issues option to perform your search, and not in the filter itself.

Let us know if it helps.

Narasimha murthy
Contributor
May 17, 2019

Thanks Petterson, its quotation issue only. :-)

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events