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.

[Dave Rosenlund _Trundl_]

Julien, is correct, Gregory. This is a fairly common use case for Structure.  If this is something you’d like to discuss or see feel free to reach out to us via structure@almworks.com. 

In either case, best of luck to you.

-dave [ALM Works]

[jndeverteuil]

This could actually work as you can use JQL queries to build your swimlanes. However, you would need to update your queries everytime... Columns in the board would be your issue aggregation by status.

Maybe you could have a look at Structure for JIRA or Portfolio for JIRA if you need a higher level visibility?