How do I write a query to show if an X-ray test is not linked to a Test execution?

[Cherylwyn Stephenson]

X-ray tests can't be parented to a story or Feature and therefore, we link our x-ray tests to test executions which in turn are then parented to stories/bugs. So, how can a run a sql query to check all unlinked x-ray tests?

[Vinubabu _Vinu_]

Hello @Cherylwyn Stephenson 

If done correctly Tests cover the story and do not exist as a parent <> child relation. Any test that do not cover a story will be your standalone tests which you can retrieve from your Xray reports.

https://docs.getxray.app/display/XRAYCLOUD/Quick+Guide+for+Testers

https://docs.getxray.app/display/XRAYCLOUD/Built-in+Reports

Hope this helps

[Marc - Devoteam]

Hi @Cherylwyn Stephenson 

Welcome to the community.

You are probably not referring to issue linking ootb in Jria but the relation between test and test sets.

This can't be queried via JQL, Xray has no options for this.