I need help with JQL query to filter out test report from Test Executions for current sprint

[kajaljena01]

I need help with a JQL query that can filter out my Test Executions based on the environment they are run on a daily report basis. Also, the report needs to exclude test execution for any retest.

The query that I'm using is 

issuetype = Test AND issue in testExecutionTests('TestExecutionKey') AND updated > startOfDay() AND updated < now()

TestExecutionKey filter: 

issuetype = "Test Execution" AND project=XX AND fixVersion = vNext AND sprint in openSprints()

It returns the previous execution test run status rather than current execution, 

Can someone help me with it? any help would be appreciated.

[Jobin Kuruvilla [Adaptavist]]

You can add any JIRA gadget into Confluence after you register that gadget in Confluence. See https://confluence.atlassian.com/confkb/how-to-bring-jira-and-jira-agile-reports-into-confluence-779163801.html for the steps.

However, you cannot show reports that are not available as gadgets. You might have to give the direct url to those reports from Confluence.