By: Jonathan Powell
I was recently asked by my Technical Lead to supply some information about each of the QC tickets I had worked on for a project. This included tickets currently in my queue, as well as tickets I had assigned back to QA Engineers for retesting. I needed a quick way to get some information out of QC about each of these tickets. I used the Analysis View of QC 11 to generate a new Excel report for me and used the following query as the basis of the report:
DateAssigned, BG_BUG_ID, BG_SUMMARY, AP.AP_NEW_VALUE
Bug B, Audit_Log AL, Audit_Properties AP
AL.AU_ENTITY_ID = B.BG_BUG_ID
AP.AP_ACTION_ID = AL.AU_ACTION_ID
This query finds some general information about each defect that had ever been assigned to me. Now, let’s take a more in-depth look at how to do this.
Generating Excel Reports Yourself
Click on the Analysis View under the Dashboard option on the left in QC 11.
Hover over the green plus sign and click the little drop down list that appears. Choose to create a new Excel report and give the report a name. The right pane switches to the query view that allows you to enter a query.
Unless you know the query you want to use, it’s easier to use the Query Builder. Clicking on that menu option brings you to a window that shows you all of the tables and columns you can query against.
From there, it’s as easy as clicking the columns or tables you want to query against and testing the query. As a note, you may not see the full results returned from this query if you click on the “Test Query” or “Run Query” buttons, but you will see if your query is returning the type of data you’d like to analyze. After you’re happy with your query, click OK on the Excel Report Query Builder window. You’re brought back to the query view, but now your query should be displayed. Click “Generate”, choose a file name, and your excel workbook with the results of the report will be generated. Based on the query I showed above, the excel workbook would look similar to this:
And that’s all there is to it. Enjoy generating your own reports!