deleting issues

Topics: General
Sep 22, 2014 at 4:03 PM
We have been doing training on using BugNet and are getting ready to "go live". I would like to clear out the issues that have been entered during the training period and start with a clean slate. Is there anyway to do this using BugNet itself (I could not find a way to delete an issue), or by using a stored procedure in the BugNet database. I saw the procedure BugNet_Issue_Delete, but it looks like that just sets the issue to disabled, and does not removed it from the issue table, which is what I would like to do.

Thanks!
Coordinator
Sep 23, 2014 at 3:05 PM
Edited Sep 23, 2014 at 3:06 PM
asudman wrote:
We have been doing training on using BugNet and are getting ready to "go live". I would like to clear out the issues that have been entered during the training period and start with a clean slate. Is there anyway to do this using BugNet itself (I could not find a way to delete an issue), or by using a stored procedure in the BugNet database. I saw the procedure BugNet_Issue_Delete, but it looks like that just sets the issue to disabled, and does not removed it from the issue table, which is what I would like to do.

Thanks!
You would have to delete them from the database directly and best to use the truncate command to reset the issue id column , TRUNCATE TABLE BugNet_Issues
Marked as answer by asudman on 9/24/2014 at 7:14 AM
Sep 23, 2014 at 4:13 PM
Is BugNet_Issues the only table that needs to be truncated, or are there others that I need to clean up as well such as BugNet_IssueNotifications, BugNet_IssueAttachments, etc?