what is the Jira query to list the execution status in a jira test execution

[Eugene Simon]

I have a list of tests executed within a test execution issue type.  I need to write a query to list all the tests executed in the test execution along with their current execution status (Pass, Fail, Blocked or Aborted)

[Nikola Perisic]

Welcome @Eugene Simon 

Are you using an app like Xray or are you doing this out-of-the-box?

[Eugene Simon]

Thanks Nikola, I'm using Xray.

[Nikola Perisic]

You should refer to this documentation here: https://docs.getxray.app/display/XRAY/Enhanced+querying+with+JQL

and also here: https://docs.getxray.app/display/XRAY/Tutorial+for+querying+with+JQL

[Eugene Simon]

This jquery gives me the tests that have passed:
project in (xyz) AND issue in testExecutionTests("test execution id", 'fail')

Then I export the data in .csv and manually update the status to Fail since there is no column heading in Jira that lists the test execution status (from the test execution issue type).

I hope I'm making sense :)