It's all about the answers!

Ask a question

Use custom expression in IBM Engineering Report Builder /rs to find Defect Density.


Derm Phongninlaarphon (151) | asked May 11, 5:45 a.m.

 Hi Jazz Forum.


Defect Density report that we want to achieve is

Dividend = Query only defect that we considered as valid (We have multiple type for defect, only few that considered as 'valid defect')


Divider = Query only test case execution record that has result with Pass and Fail (Test result can be Pass, Fail, NA, In-progress, Blocked. We want to sum only Pass and Fail)


Quotient = Defect Density as percentage


Now we use build the report to count the defect and TCER but we have to do an extra work to calculate it outside ELM.

============


Could you please give me an advise on how to achieve this.


I have told to use SQL Query in Advance option and given this link

"Data dictionary for test artifacts"

https://www.ibm.com/docs/en/elm/7.0.2?topic=reporting-quality-management-data-dictionary


I've looked at it and it really confusing, for example.


SQL Query in report builder.

WHERE T4.PROJECT_ID IN (0, 2) AND (T4.TESTPLAN_NAME = 'SIT_P2020-00269 E-Withholding Tax e-WHT' ) AND T4.ISSOFTDELETED = 0 AND (T4.EXECWORKITEM_ID <> -1 AND T4.EXECWORKITEM_ID IS NOT NULL)GROUP BY T4.TESTPLAN_NAME ) U1 ORDER BY U1.REQUEST_STATE asc, U1.CURRENT_RESULT_VERDICT asc


But in Data dictionary for Defect / Work item https://www.ibm.com/docs/en/elm/7.0.2?topic=dictionary-defect-work-item

They look completely difference.


How am I suppose to know how to edit my own report on SQL Query via this document?


============

Answer from this post https://jazz.net/forum/questions/237669/how-to-create-defect-density-report-in-jrs

is to ask IBM support


But I came here because IBM support told me and he link this post https://jazz.net/forum/questions/243369/custom-expressions-in-jazz-report-builder to use as a reference.


Regards,

Derm Phongninlarphon

One answer



Your answer


Register or to post your answer.