How to create a report of defects that have changed between two status types
Question ID: 104919
1
0

My manager is trying to get a list of all the defects that have changed from two different status states, from "Reopen" to "Fixed" or from "Reopen" to "Closed". I am not able to do this using any of the default report filters, does anyone know a way to do this?

Marked as spam
Posted by (Questions: 100, Answers: 4)
Asked on March 22, 2013 2:08 pm
417 views
Answers (2)
2
Private answer

The only way to accomplish this is by sql and by looking at the history table and looking at what the status changed from, then joining back to the defects table on the entity id for that specific defect. Also the history needs to be enabled for the defect status field in customization.
Here is an example of how you could accomplish this in a QC excel report:

Note: This is just an example, you will need to modify this to fit your needs

SELECT BG_BUG_ID as 'Bug Number', BG_STATUS as 'Bug Status', BG_Responsible as 'Responsible', BG_SUMMARY as 'Bug Summary', BG_DETECTED_BY as 'Detected By'
FROM AUDIT_PROPERTIES
RIGHT JOIN AUDIT_LOG
ON AUDIT_PROPERTIES.AP_ACTION_ID=AUDIT_LOG.AU_ACTION_ID
Left Join BUG
On AUDIT_LOG.AU_ENTITY_ID=BUG.BG_BUG_ID
where ((AP_OLD_VALUE='Reopen' and AP_NEW_VALUE='Fixed') or (AP_OLD_VALUE='Reopen' and AP_NEW_VALUE='Closed')) and AU_ENTITY_TYPE='BUG' and AP_FIELD_NAME='BG_STATUS'

Marked as spam
Posted by (Questions: 0, Answers: 364)
Answered on March 22, 2013 2:11 pm
0
Private answer

Hi, I am searching for a query which gives the output in following format:

phase | #Defects Reopened | #Defects Rejected | #Total Defects Closed| # Total Defects
SIT XX XX XX XX
ST XX XX XX XX

Thanks
xylo

Marked as spam
Posted by (Questions: 0, Answers: 1)
Answered on December 18, 2013 4:15 am
EyeOnTesting

Welcome back to "EyeOnTesting" brought to you by Orasi Software, Inc.

X
Scroll to Top