I became QC Admin recently. In one of the projects, the requirement is that the 'Severity' has to show '1-Minor' instead of '1-Low'. I can 'Customize' the 'Severity' option to show 'Minor', but for all the existing defect's I have to change the Severity from 'Low' to 'Minor'. There are around 200 defects.
Is there any way where in I can change all 'Low' to 'Minor' in one step?
[ QUOTE ]
Tony's suggestion is the easiest. Just use the QC Site Admin tool to run a query like the following:
UPDATE bug SET bg_severity = '1-Minor' WHERE bg_severity = '1-Low'
[/ QUOTE ]
Thanks for posting the SQL commands ,Boyd. I no longer have access to the SiteAdmin section at my new place of employment and still working on the request for direct query access to the data base behind the projects I am working on (for custom reporting).
I was afraid to try to come up with it off the top of my head with only the help file as a guide [img]/images/graemlins/smile.gif[/img]