Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

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,

0 votes



One answer

Permanent link

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

0 votes

Your answer

Register or log in 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.

Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details
× 12,025
× 360

Question asked: Jun 30 '17, 11:50 a.m.

Question was seen: 1,706 times

Last updated: Jun 30 '17, 12:41 p.m.

Confirmation Cancel Confirm