Forum Discussion

Bob_C's avatar
Bob_C
Contributor
6 months ago

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...
  • Bob_C's avatar
    6 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.

    1. project = MGS and issue in coveredByTestCasesHavingField("estimatedTime", "00:00" , "00:05")
    2. 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.