Creatio development guide
PDF
This documentation is valid for Creatio version 7.16.0. We recommend using the newest version of Creatio documentation.

Deleting a section

Glossary Item Box

Introduction

If a section was created based on the object that must be deleted, this section must be deleted first.

To delete a custom section in Creatio, you need access to the system configuration tools and its database.

Before you delete a custom section, unlock the corresponding section in the SVN storage.

First, delete the database records. Use the following script to delete a section:

DECLARE @UId UNIQUEIDENTIFIER
DECLARE @ModuleEntityUID UNIQUEIDENTIFIER;
DECLARE @ModuleID UNIQUEIDENTIFIER;
DECLARE @Name NVARCHAR(max) = 'ToDelete';
select @UId = UId from SysSchema where Name Like @Name
select @ModuleEntityUID = Id from SysModuleEntity where
SysEntitySchemaUId = @UId
select @ModuleID = Id from SysModule where SysModuleEntityId = @ModuleEntityUID;
delete from SysModuleInWorkplace where SysModuleId = @ModuleID;
delete from SysModule where Id = @ModuleID;
delete from SysModuleEdit where SysModuleEntityId = @ModuleEntityUID;
delete from SysModuleEntity where Id = @ModuleEntityUID;
delete from SysDetail where EntitySchemaUId = @UId;
delete from SysLookup where SysEntitySchemaUId = @UId;
delete from [Lookup] where SysEntitySchemaUId = @UId;

Please note that the “ToDelete” value must be replaced with the custom section schema name. After deleting database records, delete section custom schemas in the [Configuration] section (located under [Advanced settings]) in the following order:

  1. ToDeleteFile
  2. ToDeleteInFolder
  3. ToDeleteInTag
  4. ToDeleteTag
  5. ToDeleteFolder
  6. ToDelete
© Creatio 2002-2020.

Did you find this information useful?

How can we improve it?