Bob_C
7 months agoContributor
JQL Search for Estimated Time is NULL / BLANK
Is there a way to do a query/filter on estimatedTime that has not yet been entered? I was able to find this information: https://support.smartbear.com/zephyr-scale-server/docs/en/jql-functions.html...
- 7 months ago
I was able to talk to a coworker and he helped figure this out. Wanted to let other's know the solution.
I found out that you can find estimated time ranges within the query.
- project = MGS and issue in coveredByTestCasesHavingField("estimatedTime", "00:00" , "00:05")
- project = MGS and issue in coveredByTestCasesHavingField("estimatedTime", "00:05" , "99:59")
Query 1 will give estimated times <= 5 minutes, and Query 2 will give estimated times >= 5 minutes.
Armed with this knowledge, we realized we can find empty estimated times by finding anything outside the 0 to 99 hour range.
project = MGS and issue NOT IN coveredByTestCasesHavingField("estimatedTime", "00:00" , "99:59")
This method requires that a test case is linked to an issue. There may be another way to do this, I am interested to hear if there are other solutions, or better yet if there is a way to do this within Zephyr without needing to be linked to an issue.