Need a JQL for Defects associated with failed Tests

Question

I currently have a JQL query  issue in testExecutionTests(ABC -333) AND TestRunStatus in (FAIL, PASS, TODO, EXECUTING, ABORTED) that displays All the Tests and their Test run status .I would like to query defects associated with the failed Tests. When we execute the Test , we add a defect , we associate the failed test with a defect. However I am not able to query in way that a defect is displayed for the failed test.

When I run the query I have Key, Test summary, Test status , Test run status , Affected version, Assignee,

I would like to add Defect column for those with Testrunstatus as failed. How do I query for the defects

Garden16__h3vuuz · Answer

The list of defects does not have any specific field for it. Let's say of I link the defect to the Test. when I added Column 'link.'  It shows the defects as well as other issue types linked to the test.

How do I exclusively show only defects that are linked to the Test. Show only defects (open defects) linked to the Test. Please advise.

Ram Kumar Aravindakshan _Adaptavist_ · Answer

Hi @Garden16_

In your last comment, you mentioned:-

However , I also need a list of defects that are associated with failed Tests in the execution. I would also like to display  one more column in the screen shot below that depicts the defects associated with the failed test case

Does the list of defects have a specific field for it?

If yes, are you able to include the field that you want to see using the Columns list as shown in the screenshot below:-

I am looking forward to your feedback and clarification.

Thank you and Kind regards,

Ram

Garden16__h3vuuz · Answer

The failed test 529 above screen shot has 3 defects associated with it. 
Out of them two are closed. I have used linked issue to create defects with the test .See below