12-20-2013 09:36 AM
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
Solved! Go to Solution.
12-20-2013 10:39 AM
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'
(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.)