How do I create a query to pull all unassigend Test Runs for the entire Test Plan

Question

Hi

As I will be assigning out TestRuns to the members which are infact linked to TestExecutions and Tests. I think test issue types will be not be assigned for execution but its related test runs will be assigned for execuction

I am currently struggling to write a query which provides a complete list for each test issue type as below:

1. Tests and its related test run for a particular test plan

2. Latest test runs assigned to User XXXX

3. Test runs not assigned which needs to be assigned

I will be looking at this report to identify which ones are not assigned and assign them out to the team.  Please let me know how I can achieve this

Manjunatha Jayakumar · Answer

Sure, Thanks

Andrew Makar · Answer

Ah..I don't use Xray...I am familiar with TestRail as the test management tool within JIRA.

Does Xray provide that type of reporting?  You may have to talk to a JIRA administrator to determine how you can pull that specific data into a Confluence report.

Manjunatha Jayakumar · Answer

Thanks but I am not following completely

I am actually referring to Xray test records where I have a multiple tests which are bundled into a test set.  Like this I have 3000 plus test cases and say which are combined into 500 unique test sets.  Now i have all these 500 test sets linked to a test plan in Xray and for the entire plan, I have one test execution record created for all test sets.

As per my undrstanding I will be assigning out individual test runs under test execution I created for all 3000 plus test cases.  So I need to report which should tell the list individual records of test runs assigned/unassigned.  Only when I have this report I can assign out the cases to the team.  Please let me know