Versions Compared

Old Version 3

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.

...

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

...

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

...

...

...