Using SQL Utility to delete an unused defect

This topic contains information about the legacy SQL Utility, which is being phased out from GainSeeker Suite. It is still available for use in version 8.3, but is being replaced by the new GainSeeker SQL Utility function in the GainSeeker Utility module.

Deleting an unused defect example

If a defect is not assigned to any processes or referenced by any data, you can use the SQL Utility to remove it from the list of All Defects.

1. Launch the SQL Utility module and log in.

2. Log in as a user or group name with rights to access this utility.

3. In the System area, click DMS.

4. In the Change type list, click Process.

5. In the Field to change list, click Defect.

6. In the Current value list, click the defect you want to delete.
   
   

7. Click Run SQL.

8. At the prompt, click OK.
   
   
   
   The SQL Utility will now search all of your DMS process records and data records for this defect. If this defect is found, the SQL Utility will display a message like the one below. It will also use the New value list to display the DMS standards for which some data still contains this defect.
   
   

9. If this defect was not found in any DMS process records or data records, SQL Utility will display this prompt. Click Yes to continue.
   
   

10. At the prompt, click OK.
    
    

11. After SQL Utility has deleted this defect, SQL Utility displays another message. If anyone is running the Administration module, they must exit and re-start to update the list of All Defects.