...
Examples of custom deletions
Bulk deletion of workflowmappings
The While the MCRecoveryTool -clear_config_all option removes the workflowmappings, sometimesis available to clear all configuration and will also remove the workflowmappings. But in some cases, a custom delete statement can be used quicker to clear all the (workflowmappings for non- MC ) workflowsworkflows without the need for uploading the configuration again.
| Code Block |
|---|
DELETE FROM WorkflowTargetFSSs WHERE workflowId NOT LIKE 'MC:%' AND workflowId NOT LIKE 'MC_:%' |