HPQC Excel Report: Defects reopened

This Excel Report list defects with Status changed to Reopen.

Useful to see how many defects was not fixed properly and had to be reopened.

SELECT

BUG.BG_BUG_ID as “Defect Id”,

BG_SUMMARY as “Defect Summary”,

AP_OLD_VALUE as “Old value”, — Status prior to Reopen

AP_NEW_VALUE as “New value”, — Reopen

au_time as “Time changed”, — When it was reopened

au_user as “Changed by” — Who reopened it

 

FROM audit_log, audit_properties, bug

WHERE AUDIT_PROPERTIES.AP_NEW_VALUE = ‘Reopen’

and AU_Action_ID = AP_Action_ID

AND AU_ENTITY_ID = BG_BUG_ID

AND AU_ENTITY_TYPE = ‘BUG’

AND AP_FIELD_NAME = ‘BG_STATUS’

order by bg_bug_id 

About these ads