History of defects (299 Views)
Reply
Advisor
Raghav24
Posts: 34
Registered: ‎08-09-2012
Message 1 of 3 (299 Views)
Accepted Solution

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

 

 

Honored Contributor
Trudy Claspill
Posts: 3,779
Registered: ‎09-09-2010
Message 2 of 3 (287 Views)

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.)
Advisor
Raghav24
Posts: 34
Registered: ‎08-09-2012
Message 3 of 3 (247 Views)

Re: History of defects

Thanks Trudy . This more or less solves my issue . 

The opinions expressed above are the personal opinions of the authors, not of HP. By using this site, you accept the Terms of Use and Rules of Participation.