How to get list of Test Executions that are not associated with any Test Plan in XRAY?

[Ashim Upadhyaya]

I am trying to get the list of Test Executions in a given project which are Orphan in nature, i.e. Test Executions that are not associated or linked to any Test Plan. Can you please help me if there is a standard JQL that can be used for the same? 

[Simon Tost _TNG_]

Okay, I tried to solve the corresponding question for Tests (instead of 'Test Plans').

Here is what I came up with:
1 auxiliary stored filter "All test plans", with sth. like

project = ABC AND issuetype = "Test Plan"

and then the actual query

project = ABC AND issuetype = "Test Execution" AND NOT issue in testPlanTestExecutions("All test plans")

(see also XRAY Docu/Enhanced querying with JQL )

[Stefan Salzl]

Hi @Ashim Upadhyaya and welcome to the community,

I really tried all different places and sections in xray to figure this one out - unfortunately and really surprisingly (I was convinced this is possible) I wasn´t able to find a solution (at least not with jira inside possibilities --> I guess there are more advanced possibilities with advanced JQL, scriptrunner,...).

Please don´t hesitate to contact vendor support for detailed help.

I´m sorry I couldn´t solve the problem completly but I still hope that this was helpful.

Best
Stefan

[Ashim Upadhyaya]

Thank you Stefan for taking the time to dig deep into this. I will contact the vendor support as per your suggestion, and come back to update this post if I get any solution. Fingers crossed. Have a good day!

[Simon Tost _TNG_]

Hi @Ashim Upadhyaya

Did you get an answer from the colleagues at Xray?