Table of Contents

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.

...

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;

Related Links

https://dev.joget.org/community/display/DX8/Process+Data+Collector

...