| || |
Excel Report - Engineer Report
I need help generating an engineer report through the excel report generator in QC. The report will have the engineer responsible for the defect, defect description/ID, and the number of hours a day this person has spent on this specific defect.
Below is my SQL query that I am using to get the information I need:
BG_RESPONSIBLE as "Responsible",
BG_BUG_ID as "Bug Id",
BG_SUMMARY as "Summary"
FROM BUG, AUDIT_LOG
WHERE AU_ENTITY_ID = BG_BUG_ID
AND BG_RESPONSIBLE = 'dasarir' -- input engineer to generate report for
AND AU_ENTITY_TYPE = 'BUG'
-- 60 day history
and au_time <= dateadd(dd,0, datediff(dd,0, getDate()))
and au_time >= dateadd(dd,0, datediff(dd,0, getDate())) - 60
1) How can I get the full name of the person responsible for the BUG/Defect? (Need the SQL query because I have not been able to figure it out)
2) Is there any way that I can get the number of hours this specific engineer has put daily into the specific defect? (I was told that "Actual Fix Time" under the BUG table will keep track of the hours... (so 0-3 first input, then 3-5 second input etc.)
Thank you for your help.