how to filter test cases in zephyr based on status changed during a period

[Leena Sharma]

This is the query that I am using to filter out test cases for which status is changed to Pass during a time span. 

project = XYZ and status changed to Passed during ("2019/12/10", "2020/01/16")

This query is working fine but not showing me any result. even-though there are many test cases which have been set to pass during this duration. 

[Lenin Raj]

Hi @Leena Sharma 

One suggestion is to try the same query with BEFORE or AFTER to narrow down your results and identify where the results are not being returned.

project = XYZ AND status changed to Passed AFTER "2019/12/10"

[Leena Sharma]

Thanks @Lenin Raj 

I tried using AFTER. But it is also showing me no result. 

I have figured out the query. It will be as follows - 

project = "XYZ" and executionStatus = Pass and executionDate > '2020/01/01'

[Lenin Raj]

Glad you got it sorted.