delete records | Community Creatio

Idea

Discussion

folders

delete records

Ideas

Separate Folder Options from the rest of the Actions menu

Lisa Clarke

18:09 Oct 30, 2019

It would be great if there were a separate menu for Folder options, either distinct from the current Actions menu or as a distinct menu option under the list of actions. When using static folders, my users often use the Delete option in the Actions menu, when they really want to exclude a contact from a folder. It can get kind of confusing and can lead to data loss for contact records.

Do you like this idea?

1 comments

Angela Reyes

15:37 Oct 31, 2019

Dear Lisa,

Thank you for your idea! We will pass it to our R&D department so they could consider enhancing the following functionality in the upcoming releases.

Best regards,

Angela

Show all comments

Question

How to delete records in Process Log

Janine White

19:45 Sep 09, 2019

We have over 300,000 records in our Process Log. We'd like to delete records that are not Running or Error that are over one month old. They are supposed to be archived, but there are records from months ago that have not been archived. When I select a record, there is no option to delete it or archive it. How do I delete or archive records from the Process Log?

4 comments

Dennis Hudson

02:13 Sep 10, 2019

Dear Janine,

Process log gradually gets cleared by the archivation process. We don't recommend to delete data from Process Log yourself. However, if you really need to delete that data we recommend to send a request to the support@bpmonline.com if your instance is in cloud as it requires very resource heavy sql operations that would not be possible to track with sql executor.

If your instance is on-site you can take the instruction below as an example to adapt it based on your needs:

1) Register SQL procedures tsp_DeleteSysProcessLog.sql and tsp_DeleteSysProcessLogByStartDate.sql (procedures themselves below)

2) Execute the procedure.

Example: EXEC [dbo].[tsp_DeleteSysProcessLogByStartDate] 'Error', '2017-09-22', -1,

Where 'Error' is the status of processes, '2017-09-22' by which start date to delete processes, '-1' how many processes to delete, -1 means all processes.

Please note that the operation is very resource heavy and time consuming and we don't recommend doing that during business hours.

Best regards,

Dennis

IF NOT OBJECT_ID('[dbo].[tsp_DeleteSysProcessLogByStartDate]') IS NULL

BEGIN

DROP PROCEDURE [dbo].[tsp_DeleteSysProcessLogByStartDate]

END

GO

CREATE PROCEDURE [dbo].[tsp_DeleteSysProcessLogByStartDate]

   @Status nvarchar(max),

   @StartDate date,

   @RowsCountToDelete int

AS

BEGIN

SET NOCOUNT ON

   IF NOT OBJECT_ID('#SysProcessLogId') IS NULL

   BEGIN

       DROP TABLE #SysProcessLogId

   END



   CREATE TABLE #SysProcessLogId (Id uniqueidentifier)

   IF @RowsCountToDelete > -1

       INSERT INTO #SysProcessLogId ([Id])

       SELECT Top (@RowsCountToDelete)

           SysProcessLog.Id

       FROM SysProcessLog

       JOIN SysProcessStatus ON SysProcessStatus.Id = SysProcessLog.StatusId

       WHERE

           SysProcessLog.ParentId IS NULL AND

           SysProcessLog.StartDate < @StartDate AND

           SysProcessStatus.[Name] = @Status

   ELSE

       INSERT INTO #SysProcessLogId ([Id])

       SELECT

           SysProcessLog.Id

       FROM SysProcessLog

       JOIN SysProcessStatus ON SysProcessStatus.Id = SysProcessLog.StatusId

       WHERE

           SysProcessLog.ParentId IS NULL AND

           SysProcessLog.StartDate < @StartDate AND

           SysProcessStatus.[Name] = @Status

EXEC [dbo].[tsp_DeleteSysProcessLog]

END

GO

CREATE OR REPLACE PROCEDURE "tsp_DeleteSysProcessLogById" (id VARCHAR2)

IS

   TYPE IdSet IS TABLE OF VARCHAR2(38);

   input_ids IdSet;

   i NUMBER;

BEGIN

   SELECT

       "Id"

       BULK COLLECT INTO input_ids

   FROM "SysProcessLog"

   WHERE "ParentId" = id;

   IF input_ids.COUNT() > 0 THEN

   FOR i IN input_ids.FIRST .. input_ids.LAST

   LOOP

       BEGIN

       "tsp_DeleteSysProcessLogById"(input_ids(i));

       END;

   END LOOP;

   END IF;

DELETE FROM "SysProcessElementLog"

WHERE "SysProcessId" = id;

DELETE FROM "SysProcessLog"

WHERE "Id" = id;

END;

/

CREATE OR REPLACE PROCEDURE "tsp_DeleteSysProcessLog" (inputRowsCountToDelete IN INT, status IN VARCHAR2)

   IS

   TYPE IdSet IS TABLE OF VARCHAR2(38);

   input_ids IdSet;

   i NUMBER;

   step INT := 1000;

   startDate TIMESTAMP;

   rowsCountToDelete INT := inputRowsCountToDelete;

   allRowsCount INT;

   rowsLeft INT;

BEGIN

   DBMS_OUTPUT.PUT_LINE('Database: ' || USER);

   startDate := CURRENT_TIMESTAMP;

   IF (inputRowsCountToDelete <= 0) THEN

           SELECT COUNT("Id") INTO rowsCountToDelete FROM "SysProcessLog";

   END IF;

   SELECT

       "SysProcessLog"."Id"

       BULK COLLECT INTO input_ids

   FROM "SysProcessLog"

   WHERE

   "SysProcessLog"."ParentId" IS NULL

   AND "SysProcessLog"."StatusId" IN

       (SELECT

           "SysProcessStatus"."Id"

       FROM "SysProcessStatus"

       WHERE INSTR(status, "SysProcessStatus"."Value") > 0)

   AND NOT EXISTS(SELECT "SysProcessData"."Id" FROM "SysProcessData" WHERE "SysProcessData"."Id" = "SysProcessLog"."Id")

   AND ROWNUM <= rowsCountToDelete;

allRowsCount := input_ids.COUNT();

DBMS_OUTPUT.PUT_LINE('Number of records to process: ' || rowsCountToDelete);

   IF allRowsCount > 0 THEN

       rowsLeft := allRowsCount;

       FOR i IN input_ids.FIRST .. input_ids.LAST

           LOOP

               BEGIN

                   IF MOD(i, step) = 0 THEN

                       DBMS_OUTPUT.PUT_LINE('Step ready: ' || TO_CHAR(CURRENT_TIMESTAMP, 'DD-MM-YYYY HH24:MI:SS.FF2'));

                       DBMS_OUTPUT.PUT_LINE('Rows left: ' || rowsLeft);

                   END IF;

                   "tsp_DeleteSysProcessLogById"(input_ids(i));

                   rowsLeft := rowsLeft - 1;

               END;

           END LOOP;

       END IF;

   DBMS_OUTPUT.PUT_LINE('Number of records processed: ' || allRowsCount);

   DBMS_OUTPUT.PUT_LINE('---------------------------------------------------------------');

   DBMS_OUTPUT.PUT_LINE('Execution time: ' || TO_CHAR((CURRENT_TIMESTAMP - startDate), 'DD-MM-YYYY HH24:MI:SS.FF2'));

END;

/

--CALL "tsp_DeleteSysProcessLog"(10000, '2,4');

Janine White

02:21 Sep 10, 2019

Thanks, I have reported it to Support since there are records even from April that haven't been archived.

Van Ly

06:50 Sep 10, 2019

I found Beesender tried to delete process log by a process to delete items from Process log (actual). Is that correct or is there any risk of doing that way?

Dennis Hudson

06:54 Sep 10, 2019

Van Ly,

Process log is connected to several other tables so there is a risk of not deleting all necessary records or possibly corrupting some necessary data.

Best regards,

Dennis

Show all comments

Question

Process Element Delete Signal - Retrieve not only the unique identifier of the deleted record but also the parent foreign key of the deleted record

Fulgen Ninofranco

08:27 Jun 17, 2019

Hi Community,

Any Idea, how can I retrieve not only the unique identifier of the deleted record but also the parent foreign key of the deleted record on delete signal?

My scenario is:

On deletion of a child record, I want to create a business process that will be triggered on delete signal. Then do the re computation of the total amount on parent record after the deletion of the child record. But the problem is on delete signal I can only retrieve unique identifier of the deleted record, I need also to retrieve the parent foreign key of the deleted record for me to re compute and update to total amount of the parent record.

Thanks,

6 comments

Angela Reyes

09:19 Jun 17, 2019

Dear Fulgen,

If a process that starts on record deletion is started not in the background you can simply add "read data" element that will read all data needed from a record that is deleted.

Best regards,

Angela

Fulgen Ninofranco

09:24 Jun 17, 2019

Angela Reyes,

Hi Angela,

Thanks for the reply.

Can you show me example how can i design this logic on business process.

Angela Reyes

09:40 Jun 17, 2019

Fulgen Ninofranco,

Just uncheck "Run following elements in the background"

checkbox (http://prntscr.com/o2rt5q) and read all data from the record with this Id.

Fulgen Ninofranco

11:06 Jun 17, 2019

Thank you Angela, this solves my problem

Julio.Falcon_Nodos

00:48 Sep 29, 2021

Hello colleagues,

In 7.18.3.1241 it didn't works, please see on https://prnt.sc/1tzz9qp, I have configured, but cannot recover data from deleted record to update detail totals

Oleg Drobina

17:22 Sep 29, 2021

Hello Julio,

Please provide more details on this object from which records are deleted and how exactly you've deleted them? The simple process that triggers upon deleting one contact works perfectly in 7.18.3 full bundle on my end.

Best regards,

Oscar

Show all comments

Question

Deleting the data in the instance

aaykay

03:17 Mar 19, 2019

Hi,

Is there a way to delete all of the data from any of the sections, say I want to delete all the accounts? I am looking for a way to delete all the records in the instance i.e. all the leads, accounts, contacts, any cases etc.

One way is to select all the records in particular section and then delete but when I do that, it brings out all the dependencies and therefore have to go into the records, or more dependencies to delete those records and it literally takes ages to delete them.

So I am looking for ways to refresh the instance, but not damaging or changing the packages and other settings in any fashion but just delete the records from the instance.

Regards,

2 comments

Dennis Hudson

03:13 Mar 20, 2019

Hello!

Unfortunately, for now the only option is deleting records by selecting them all, deleting and dealing with the dependencies. You also can delete records using SQL Executor, however you would need to manually deal with the dependencies as well in this case.

Best regards,

Dennis