how to capture history in defects module ?
| ♥ 0 |
How can i capture history for a particular defect in the defects module ? can i generate a report ?
Marked as spam
|
Posted by |
Private answer
Here are some report definitions that can be used in QC11 Analysis to create excel reports of what changed Today, This Week, and Yesterday. It will query the project db and create a pivot table of the revisions. This is compatible with Office 2010 and QC 11, i haven't tested it anywhere else. However, there are some features used that are not compatible with anything less that Microsoft Office Excel 2010. You can import these definitions into your project and try them out in the Dashboard Analysis Module of QC 11. The heart of the report is this query: SELECT ('Bug: ' + CONVERT(varchar(5),td.BUG.BG_BUG_ID) + ' - ' + CONVERT(varchar(256),td.BUG.BG_SUMMARY,101)) As calcBUGNAME , FROM td.AUDIT_LOG The report definitions can be found here as well as a short video with audio that demonstrates importing them into Quality Center 11 and generating the report: [1]: http://ftporasi.com/EyeOnTesting/QC/Excel%20Reports/BugHistoryReport/BugsChangedReportDefinitions.zip Marked as spam
 Posted by Captain Mercury (Questions: 6, Answers: 167) Answered on December 30, 2011 11:13 am
|
|||
|
Private answer
There are 2 tables called Audit_Log and Audit_Properties that have a relation in the QC database for a particular project. Take a look particularly at the Audit_Properties table which lists all of the fields, type of entity (Bug, test etc...) and old and new values. You can run an excel report out of QC that queries this table. Based on your skills in SQL, you can export it out to a spreadsheet and either write some VBA to parse or organize it into whatever you want or you can utilize Excel formulas like pivot tables, formulas etc... to organize your data. If you join it with the Audit_Log table, you can sort it by userID, date, time, action. If you had some specifics on what your report needs to be, I can narrow it down for you and maybe even write the SQL for you. Dennis Stagliano Marked as spam
 Posted by dennis-stagliano (Questions: 0, Answers: 4) Answered on September 28, 2011 11:26 am
|
|||
|
Private answer
@TheKing you can modify the where clause of the query above like this: WHERE (td.AUDIT_LOG.AU_ENTITY_TYPE = 'BUG') Tip: Make sure in the project customization, the 'Defect Status' user-defined field is set to store history. Marked as spam
Posted by Captain Mercury (Questions: 6, Answers: 167) Answered on April 5, 2017 6:12 pm
|