It's all about the answers!

Ask a question
QuestionsTagsUsersBadges
Guidelines | FAQ
Follow this question
Question details

×12,011
×359

question asked: Jun 30 '17, 11:50 a.m.
question was seen: 1,594 times
last updated: Jun 30 '17, 12:41 p.m.

Related questions

How Can I gather "Not Run" TCER Verdicts Using JRS 5.0.2?

0
James Paulus (206●2●21●35) | asked Jun 30 '17, 11:50 a.m.

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,

One answer

Most liked answers ↑|Newest answers|Oldest answers

0
permanent link
James Paulus (206●2●21●35) | answered Jun 30 '17, 12:41 p.m.

We figured it out.
SUM(CASE WHEN LOWER(T1.CURRENT_RESULT_VERDICT) is null THEN 1 ELSE 0 END) AS NotRun,

Your answer

Register or to post your answer.


Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.