History of defects (176 Views)
Reply
Advisor
Raghav24
Posts: 34
Registered: ‎08-09-2012
Message 1 of 3 (176 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

 

 

Please use plain text.
Honored Contributor
Trudy Claspill
Posts: 3,379
Registered: ‎09-09-2010
Message 2 of 3 (164 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.)
Please use plain text.
Advisor
Raghav24
Posts: 34
Registered: ‎08-09-2012
Message 3 of 3 (124 Views)

Re: History of defects

Thanks Trudy . This more or less solves my issue . 

Please use plain text.
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