How to manually delete a site in Bold BI?

While deleting a site in Bold BI, corresponding database and its resources will be deleted automatically. In any case if you would like to delete the site, keep the database and its resources, please follow the below steps.

Steps to Delete a Site Manually

1. Identify the client id for the site you want to delete. Here’s how to do it:

   • Navigate to the Sites page at <your_domain>/ums/sites.
   • Click on the name of the site you want to delete.
   • From the site detail page, copy the client id using the copy option.
     
     

2. Once you have the client id, use the following SQL scripts to delete the site:

MS SQL

update boldtc_tenant set modifieddate = GETDATE(), isactive = 0, isdeleted = 1 where id in (select tenantid from boldtc_tenantinfo where id = '<client_id>') 

update boldtc_tenantinfo set modifieddate = GETDATE(), tenantstatus = 22, isactive = 0, isdeleted = 1 where id = '<client_id>'

PostgreSQL

update boldtc_tenant set modifieddate = CURRENT_TIMESTAMP, isactive = false, isdeleted = true where id in (select tenantid from boldtc_tenantinfo where id = '<client_id>') 

update boldtc_tenantinfo set modifieddate = CURRENT_TIMESTAMP, tenantstatus = 22, isactive = false, isdeleted = true where id = '<client_id>'

MySQL

update boldtc_tenant set modifieddate = NOW(), isactive = 0, isdeleted = 1 where id in (select tenantid from boldtc_tenantinfo where id = '<client_id>') 

update boldtc_tenantinfo set modifieddate = NOW(), tenantstatus = 22, isactive = 0, isdeleted = 1 where id = '<client_id>'

Replace <client_id> with the id you copied in step 1.

By following these steps, you should be able to manually delete a site in UMS using MS SQL, PostgreSQL, and MySQL.

References

• MS SQL Server Documentation
• PostgreSQL Documentation
• MySQL Documentation
• UMS Documentation