CTS – Your Technology Partner

History of QC Tickets Assigned to a Developer

Written by Craig Butler on December 6, 2012

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:

SELECT AU_TIME as DateAssigned, BG_BUG_ID, BG_SUMMARY, AP.AP_NEW_VALUE as AssignedTo

FROM Bug B, Audit_Log AL, Audit_Properties AP

WHERE AL.AU_ENTITY_ID = B.BG_BUG_ID

AND AP.AP_ACTION_ID = AL.AU_ACTION_ID

AND AP.AP_FIELD_NAME = 'BG_RESPONSIBLE'

AND AP.AP_NEW_VALUE = 'qcUserName'

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.

image

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.

image

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.

image

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:

image

And that’s all there is to it. Enjoy generating your own reports!

Comments

comments