Overview

You might want to delete or archive Wikis in bulk. For example:

As FogBugz On-Demand customer you have no access to your wiki, not even administrators. You have quite a few wiki entries that you do not need anymore, but you can not delete, edit or restrict them. You want them to be removed or hidden from your FogBugz.
As FogBugz On-Premises customer you want to quickly hide or archive multiple Wikis.

Solution

Wikis can be quickly marked as deleted using a SQL database script. They will not get actually deleted from the database, but they will get hidden from the FogBugz UI, including all their pages.

On-Demand Customers

Since administrators do not have access to your wikis, deleting or archiving the wikis will not work either using the FogBugz API (it needs a token created by somebody having the proper rights and subscription).

For On-Demand accounts, please contact our Support Team to have your wikis deleted (or hidden).

On-Premises Customers

Use the following SQL statement to list all your wikis:
```
USE trial1

SELECT ixWiki, sWiki, fDeleted
	FROM dbo.Wiki
```
Replace trial1 with the name of your trial database.
Take note of the ixWiki ID of the wikis you would like to delete. If you would like to delete all of them, skip this step.

Delete the selected wikis using the following SQL statement:

USE trial1

UPDATE dbo.Wiki
    SET fDeleted = 1
    WHERE fDeleted = 0
    	AND ixWiki IN (1,2) -- remove this line if you want to remove all Wikis

The ixWiki IN () statement filters the ixWiki IDs of the wikis to be deleted. If you remove this statement, all of your wikis will be deleted.

Back to the top

Testing

Check your FogBugz. The desired Wikis should not be available anymore, nor their sub-pages should be accessible.

Back to the top