cancel

History of defects

SOLVED
Go to solution
Highlighted
qc_naive
Respected Contributor.

History of defects

Hi,

 

I need to get the history of "Assigned To " for each and every defect logged in QC.

 

Is it possible to get that by using Excel Query Report ? Please advise

 

 

2 REPLIES
Trudy Claspill
Acclaimed Contributor.
Solution

Re: History of defects

Yes. Here is a query that can be used in an Excel Report in the dashboard.

 

SELECT  
  AU_USER, 
  AU_TIME, 
  AU_ENTITY_TYPE, 
  AU_ENTITY_ID,
  AP_FIELD_NAME, 
  AP_PROPERTY_NAME, 
  AP_OLD_VALUE, 
  AP_NEW_VALUE
FROM     
  AUDIT_LOG
JOIN 
  AUDIT_PROPERTIES ON AP_ACTION_ID=AU_ACTION_ID
WHERE 
  AU_ACTION='UPDATE' AND 
  AU_ENTITY_TYPE='BUG' and 
  AP_FIELD_NAME='BG_RESPONSIBLE'

 

[If this post solves or helps solve your issue, mark the thread as solved and give KUDOS to the author for their assistance.]

(Opinions expressed in my postings are mine alone, and do not reflect the opinions of my employer.No warranties express or implied for any solution/suggestion posted.)
qc_naive
Respected Contributor.

Re: History of defects

Thanks Trudy . This more or less solves my issue .