Herzum Approval Documentation
Page tree
Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 5 Current »

Overview

The routine is able to delete existing Approval Data exception made for data kept on the Global Config table.

The routine allows to clean Approval Data before to perform an import in order to overwrite Approval Configurations.

Notice that the capability to export Approval Configuration doesn't include 

  • Herzum Approval History
  • Herzum Approval Approval Configuration for Single Issue
  • Pending approval requests.

So, on performing an Approval Data export and running the Delete Approval Data, the data mentioned above will be definitely lose.

Notice that the procedure  will not delete the Herzum Approval Mail handler, Services, Validators and Post Functions.

Delete Option

You are able to delete All Approval Database or a part of it.

You are able to check the following option in order to delete them in addition to the Approval Configurations:

  • Herzum Approval History
  • Global Configurations. (info) To be restored to Default




How to delete Approval Data

On clicking the Delete button, a popup appears asking confirm:

On confirming,  the following code will run:

DELETE FROM "AO_D195E9_LANG_PACK_KEY_VAL";
DELETE FROM "AO_D195E9_LANGUAGE_PACK";
DELETE FROM "AO_D195E9_APPROVAL_HISTORY";
DELETE FROM "AO_D195E9_NTF_SCHEME_DETAIL";
DELETE FROM "AO_D195E9_NTF_SCHEME";
DELETE FROM "AO_D195E9_ISSUE_APPROVAL";
DELETE FROM "AO_D195E9_APPROVAL_DEFINERS";
DELETE FROM "AO_D195E9_APPROVAL_DELEGATED";
DELETE FROM "AO_D195E9_APPROVAL_MENU_PERM";
DELETE FROM "AO_D195E9_APPROVAL_MRA";
DELETE FROM "AO_D195E9_APPROVAL_NOT_NOTIFY";
DELETE FROM "AO_D195E9_APPROVAL_PROJECTS";
DELETE FROM "AO_D195E9_APPROVAL_RECIPIENTS";
DELETE FROM "AO_D195E9_APPROVAL_REQUESTERS";
DELETE FROM "AO_D195E9_APPROVAL_SEQUENCE";
DELETE FROM "AO_D195E9_AUTO_TRANSITION";
DELETE FROM "AO_D195E9_CONFIG_PROPERTIES";
DELETE FROM "AO_D195E9_APPROVAL_MAPPING_REL";
DELETE FROM "AO_D195E9_APPROVAL_MAPPING";
drop table "AO_D195E9_APPROVAL";
DELETE FROM "AO_D195E9_FIELDS_TEMPLATE";
DELETE FROM "AO_D195E9_CUSTOM_MAIL_TEMPLATE";
DELETE FROM "AO_D195E9_ICON";
DELETE FROM "AO_D195E9_CONDITIONAL_RULE";

At the end, the procedure delete any Approval Condition (Workflow cleaning).


  • No labels