Skip to content

Instantly share code, notes, and snippets.

@daniel0397

daniel0397/Remove stage

Created September 19, 2019 10:01
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save daniel0397/281d62b7481c4b858b49589ab1d12b41 to your computer and use it in GitHub Desktop.
Save daniel0397/281d62b7481c4b858b49589ab1d12b41 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
Remove stage
UPDATE `QED_1_CaseVersions` SET `StageId` = "entities" WHERE `StageId` = "filedaccounts";
UPDATE `QED_1_CaseVersions` SET `StageId` = "entities" WHERE `StageId` = "bankverification";
UPDATE `QED_1_CaseVersions` SET `StageId` = "entities" WHERE `StageId` = "securemeet";
UPDATE `QED_1_CaseVersions` SET `StageId` = "entities" WHERE `StageId` = "idu";
DELETE FROM `QED_Workflow_Stage` WHERE `StageId` = "filedaccounts";
DELETE FROM `QED_Workflow_Stage` WHERE `StageId` = "bankverification";
DELETE FROM `QED_Workflow_Stage` WHERE `StageId` = "securemeet";
DELETE FROM `QED_Workflow_Stage` WHERE `StageId` = "idu";
DELETE FROM `QED_1_CaseVersion_Stage` WHERE `StageId` = "filedaccounts";
DELETE FROM `QED_1_CaseVersion_Stage` WHERE `StageId` = "bankverification";
DELETE FROM `QED_1_CaseVersion_Stage` WHERE `StageId` = "securemeet";
DELETE FROM `QED_1_CaseVersion_Stage` WHERE `StageId` = "idu";
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment