How Can I gather "Not Run" TCER Verdicts Using JRS 5.0.2?
Hello,
We have built a custom SQL query to bring in test results across repositories. We have gotten the verdicts that we need with the exception of "Not Run". What is the term used for "Not Run" when basing on "Current Result Verdict"?
Here is how we have the other verdicts defined.
T1.TESTPLAN_NAME,
SUM(CASE WHEN LOWER(T1.CURRENT_RESULT_VERDICT) = 'passed' THEN 1 ELSE 0 END) AS PASSED,
SUM(CASE WHEN LOWER(T1.CURRENT_RESULT_VERDICT) = 'failed' THEN 1 ELSE 0 END) AS FAILED,
SUM(CASE WHEN LOWER(T1.CURRENT_RESULT_VERDICT) = 'blocked' THEN 1 ELSE 0 END) AS BLOCKED,
SUM(CASE WHEN LOWER(T1.CURRENT_RESULT_VERDICT) = 'inprogress' THEN 1 ELSE 0 END) AS InProgress,
SUM(CASE WHEN LOWER(T1.CURRENT_RESULT_VERDICT) = 'inconclusive' THEN 1 ELSE 0 END) AS Inconclusive,