Introduction

This article is about how to cleanse the data in the process collector table. To maintain optimal performance and storage efficiency, it may be necessary to cleanse or archive old records from the table periodically. This guide outlines the steps, considerations, and example SQL queries to safely remove outdated entries from the Process Data Collector table in a Joget environment.

Important Notes before cleansing the table:

Database activities outside of the Joget Platform are not part of the official support scope (http://www.joget.org/services/support/). We are not responsible for any data loss or data corruption arising from your database activities.
Always perform comprehensive backups of your Joget database before any database activity, and test the backups accordingly.
Run the database activities only after office hours.
Run the database activities after stopping the Joget Apache Tomcat;
1. Stop all background processes.
2. Prevent users from logging into Joget.
Please test all your queries on a test database before implementing them on the actual database.

Getting Started

To delete the Process Data Collector database tables in MySQL, use the following SQL script:

Data Cleansing Query for Process Data Collector Table:

set foreign_key_checks=0;
truncate app_report_activity_instance;
truncate app_report_package;
truncate app_report_app;
truncate app_report_process_instance;
truncate app_report_activity;
truncate app_report_process;
set foreign_key_checks=1;

Introduction

Important Notes before cleansing the table:

Getting Started

Data Cleansing Query for Process Data Collector Table:

Related Links