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

Question

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.

kajaljena01 · Answer

I tried with filter=TestExecutionkey but it still not working as expected.

For some unknown reason, it returned any previous execution where Test is attached to a defect, even though the defect itself has been closed already. Not picking the correct Test execution status.

JM Perrot · Answer

Re

Did you try to replace issue in testExecutionTests('TestExecutionKey') by filter = TestExecutionKey ?

kajaljena01 · Answer

Im using a similar query to get test executions.

Project in( X1, X,2) AND fixversion = vNext AND issuetype = Test AND sprint in openSprints() AND updated > startOfDay()

The report with Test execution is overall status and not daily basis. That's why I'm trying to get a list of tests executed on a daily basis and their status.

Normally team creates test execution for the environment with no test on sprint planning day itself.

Also, added a label in Test to identify failed tests so that filter will exclude if it rerun.

The query filter issuetype = Test AND issue in testExecutionTests(filterId) looked ok until I spot the failed test which failed last Oct but report shows for today.

I tried with different optional parameters for testExecutionTests but still, it didn't work.

Is there any other query to retrieve the test list from test executions