Search for cases without PASS executions

Question

Hi,&nbsp;we have a lot of test cases that have been executed more than one time if the first execution was FAIL or BLOCKED. Is it possible to search only for cases that do not have a PASS execution?

murphyra · Answer

I think I see what you mean. I could do something like that in SQL with a nested query or a join. It seems to be a bit more tricky in JQL. There's mention of it here...

https://community.atlassian.com/t5/Jira-Software-questions/How-to-write-a-nested-query/qaq-p/988781

murphyra · Answer

Can you not just check/uncheck the execution status values that are of interest to you?&nbsp;

jaknudsen · Answer

Thanks for the reply,&nbsp;MurphyRA&nbsp;!&nbsp;If a case has both a FAIL and a PASS execution, I don't want it to be returned when I search for FAIL executions.

sonya_m · Answer

Thanks a lot&nbsp;MurphyRA&nbsp;!&nbsp;
&nbsp;
jaknudsen&nbsp;does the advice help? Please share your progress with the Community.

jaknudsen · Answer

Thanks for your suggestion,&nbsp;MurphyRA&nbsp;, but I have not been able to find out if this is possible with JQL.&nbsp;sonya_m&nbsp;, I would love some further input on this issue.

Forum Discussion

Search for cases without PASS executions

Related Content

Search by Execution Assignee

Website Search

Advanced search object for complex model

Zephyr Scale - Test Case Label Search

Execution Plan

Recent Discussions

Zephyr Squad & Test Complete

Duplicate Test Cases When Uploading Results

Where is the gadget "Test Execution Progress" in Zephyr Squad Cloud?

Zyphr SQUAD

Consequences of removing Zyphyr from Jira software