To add a new step or delete/cancellation reason, just run the following script and replace the ? parameters with the relevant values:
INSERT INTO MO_WORKFLOW_CANCELLATION_TYPES (SUBJECT_RESTRICTION_CODE, DESCRIPTION, CONTEXT_CODE, IS_AVAILABLE, CANCELLATION_TYPE_CODE) VALUES (?, ?, ?, ?, ?);
Person/group step example
INSERT INTO MO_WORKFLOW_CANCELLATION_TYPES (SUBJECT_RESTRICTION_CODE, DESCRIPTION, CONTEXT_CODE, IS_AVAILABLE, CANCELLATION_TYPE_CODE) VALUES ('P', 'Other Reason', 'A', 'N', 'CODE');Organisation step example
INSERT INTO MO_WORKFLOW_CANCELLATION_TYPES (SUBJECT_RESTRICTION_CODE, DESCRIPTION, CONTEXT_CODE, IS_AVAILABLE, CANCELLATION_TYPE_CODE) VALUES ('O', 'Other', 'N', 'Y', 'N/A');📌Note: For organisational steps the value for IS_AVAILABLE should be set to Y
Ending Reasons
To end an existing reason run the below script updating <id> to be the id of the reason you wish to end:
update MO_WORKFLOW_CANCELLATION_TYPES set IS_AVAILABLE = 'N' where WORKFLOW_CANCELLATION_TYPE_ID = <id>;