Exist anyway to know, how many times a defect id has changed of status and when it happens?
In History of Defect Details I can check it but i need to downloado to excel using excel reports.
You mean, you need to export the details from the defect history table for a defect into an excel sheet..??
you would have to use OTA for this.
Below is a script whihc will retrive the defect information and store into an excel.
You would have to write similar code to work with the defect history table.
'Retreive Defect properties
'Connect to QC
td.ConnectProjectEx "Domain", "Project", "UID", "PWD"
'Retrieve all defects and display the summary of the defects.
Set bfact = td.BugFactory
Set bList = bfact.NewList("")
i = 0
For Each Bug In bList
intSev = Bug.Field("BG_SEVERITY")
If intSev = "4-Tolerable" Then
Id(i) = Bug.Field("BG_BUG_ID")
Sev(i) = Bug.Field("BG_SEVERITY")
openDate(i) = Bug.Field("BG_DETECTION_DATE")
closeDate(i) = Bug.Field("BG_CLOSING_DATE")
i = i + 1
objXL.Selection.Font.Bold = True
objXL.Selection.Interior.ColorIndex = 1
objXL.Selection.Interior.Pattern = 1
objXL.Selection.Font.ColorIndex = 2
objXL.Application.Visible = True
r = 2
For z = 0 to i
For x = 1 to 4
Select Case x
objXL.Cells(r, 1).Value = Id(z)
objXL.Cells(r, x).Value = Sev(z)
objXL.Cells(r, x).Value = openDate(z)
objXL.Cells(r, x).Value = closeDate(z)
r = r + 1
Set objXL = Nothing
Set bList = Nothing
Set bfact = Nothing
Set td = Nothing