JQL query for finding the details - JIRA Story and associated tests and execution details

[Gullapalli Sudhir]

Hi,

I would like to have a JQL query to have below details.

JIRA story, story summary, overall requirement status, Associated test(s) key, Test status, Test Execution key, Test Execution status and Executed By

I have the filter for the JIRA stories.

project in ('<PROJECT>') and issuetype in ('story') and labels in ('<LABEL>')

Thanks and Regards,

Sudhir

[Kit Friend]

That sounds like a list of column titles not JQL conditions. Without knowing hosting details it's a bit different but you want https://confluence.atlassian.com/jirakb/merge-multiple-instances-of-jira-cloud-779160767.html