...
Examples of custom deletions (e.g. via DBVisualizer)
| Info |
|---|
Always make sure you are connected to the correct database schema first. |
| Info |
|---|
Before deletion, always do a select of the data to delete. If possible inquire whether a recent backup of the database is available. |
Bulk deletion of workflowmappings
The MCRecoveryTool -clear_config_all option is available to clear all configuration and will also remove the workflowmappings. But in some cases, a custom delete statement can be quicker to clear all the workflowmappings for non- MC workflows without the need for uploading the configuration again.
Before deleting workflowmappings, it can be beneficial to download the current configuration first via the AdminInterface.
| Code Block |
|---|
DELETE FROM WorkflowTargetFSSs WHERE workflowId NOT LIKE 'MC:%' AND workflowId NOT LIKE 'MC_:%' |