Tracking History in HP QC(Quality Center)

hp-quality-center
hinling picture hinling · Aug 23, 2010 · Viewed 15.2k times · Source

Is there a way to tracking a bug's history in QC? What I am trying to get is how many bugs are being reopened over a release and how many times it got reopened. From the QC, I can only see the "status" as "closed" but it won't give me the information about have many times it changed from "closed" to "reopen" then "fixed" then "reopen" then "closed".

Thanks in advance!

Answer

Shambu picture Shambu · Apr 30, 2012

Audit history table of QC has information stored for every change in the QC element(here the Bug). So you can write a SQL query that retrieve reopen defects. I call them as first time fix failures and they provide good evidence on why there is more testing happening when you got more of them

Below is the blog link which has this information and tells how to extract with an example of SQL query

First time failures

Related questions

Exporting HP QC defect data to Excel

At work a colleague copies and pastes defect data from hp qc to excel and it takes her ages...it drives me mad! Is there anyway to export data to excel from hp qc? It's only required to dump lists …

Read More
Integrating Selenium with HP ALM

We have a requirement to understand if Selenium could be integrated with HP ALM. The requirement is to execute the Selenium scripts from ALM and to update back the results in ALM. From the research done till now we have …

Read More
Automating HP Quality Center with Python or Java

We have a project that uses HP Quality Center and one of the regular issues we face is people not updating comments on the defect. So I was thinkingif we could come up with a small script or tool that …

Read More