Versions Compared

Old Version 2

changes.mady.by.user Selvavignesh Perumal

Saved on

compared with

New Version Current

changes.mady.by.user Debanraj Ravindran

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Important Notes before cleansing the table:

Warning
titleWarning
  1. 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.
  2. Always perform comprehensive backups of your Joget database before any database activity, and test the backups accordingly.
  3. Run the database activities only after office hours.
  4. Run the database activities after stopping the Joget Apache Tomcat;.
    1.  Stop all background processes.
    2. Prevent users from logging into Joget.
  5. Please test all your queries on a test database before implementing them on the actual database.

Getting Started

The Process Data Collector information is stored in the app_report_* tables. Truncating these tables is sufficient to clean up the data associated with this plugin. To delete the Process Data Collector database tables in MySQL, use the following SQL script:

Data Cleansing Query for Process Data Collector Table:

Code Block
languagesql
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

...

...

...