How to find a failed test executions in Xray with no defect

Hi @all

I' struggling by getting test executions in Xray (JIRA) wich failed and have no defect created/linked

I've tried to find something usefull at the JQL Queries site from xpandit - but nothing what helps me. Also I tried to  combine somthing from the ScriptRunner JQL's with the xray JQL's - no succes.
Maybe I'm to blind, hope somebody can help.


Best regards André

1 answer

1 accepted

1 vote
Answer accepted

Hi André,

Are you trying to get Test Execution issues or Test Runs (an execution of a Test)? In version 2.0 of Xray, we will provide features for searching Test Runs. With this new view it will be easy to see all Test Runs that have failed but do not have defects created:

Currently, you can use the "TestRunStatus" custom field provided by Xray and to filter for failed Tests (always based in the latest final execution result for a specific version) and then use issue link JQL functions to check if the Test issue contains defect links. Something like:

issuetype = Test and TestRunStatus = FAIL and issue not in hasLinks("creates")

Best Regards,

Bruno Conde.

thanks for your input what exactly helped for me:

issuetype = Test and TestRunStatus = FAIL AND issueFunction not in hasLinks("created by")


I came across this question in my search, and I'm experiencing a similar issue. I found a list of Xray functions used for searching Xray issues in JIRA (one of which TestRunStatus). However, when I try searching, it doesn't recognize the function: 

Capture.JPGI've tried changing the parameters various ways and I'm sure I have permission to view the issues. Note: issuetype = Test finds the tests and I'm able to query everything JIRA related. I'm trying to use 

TestRunStatus in ("FAILED", "TODO", "PASSED")

in my search to make a pie chart in Confluence of the current status in my test plan. 

Any tips will be helpful. 




Suggest an answer

Log in or Sign up to answer
Community showcase
Posted yesterday in United States

Confluence Security Advisory

Good morning Members, Not sure if you are aware. Please read the following: More details: https://co...

29 views 1 0
View post

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you