How to write JQL to filter the Xray tests included in a Xray Text Execution or Xray Test Plan?

[Yang Wu]

I want to filter all the test cases of one or more Xray Test Execution or Xray Test Plan, how can I write the JQL in this case?

Thank you!

[Francisco Fonseca _Xray_]

Hi @Yang Wu

Welcome to the community!

You can't achieve that using JQL, but you can using Document Generator. 

Since it's a very tailored code snipet, our Support Manager suggested you open a ticket here: https://jira.getxray.app/servicedesk/customer/portal/2 so we can understand the output you want and help you with it.

Best, Francisco

[Yang Wu]

Hi @Francisco Fonseca _Xray_ ,

Thank you for the reply!

I tried the link you mentioned, but failed to create a ticket without providing the Xray SEN ( (I don’t have admin permission to check the SEN).

I'm going to give more details requirement, and please have a look. Any help is welcome!

Our Jira URI: https://gm-sdv.atlassian.net/

We are using Jira Xray to build test cases (Xray Test and Test Set), and record the case execution result (Xray Test Execution/Plan). So we created many Xay Test Execution/Plan for different test activity.

My question is how to write a JQL to filter all the tests in a specific Xray Test Set/Execution/Plan?

For example there are 200 Xray Tests in total. (TST-1 to TST-200).

Xray Test Plan A TST-201 includes TST1-TST100;

Xray Test Plan B TST-202 includes TST1-TST200.

All the tests are assigned to 3 testers.

So now if I want to know how many tests are assigned to tester #1 in Plan A or Plan B, how to write a JQL?

project = “TST“ and assignee = tester #1 and “how to list all tests in Plan A“

We need this function to create Dashboard, to show each Xray Test Execution/Plan status, and tester workload in a specific Plan.