Versions Compared

Old Version 9

changes.mady.by.user Debanraj Ravindran

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.

...

This article features the Log Cleaner Plugin and sample app created by Mokxa Technologies, LLC. This plugin was created to add in a process tool or scheduler to clear the API logs, scheduler logs and Audit trail logs from Joget database with duration from 8 days to 90 days old. It is used to delete old log data from these tables to maintain the database size. This article showcases the functionality and capability of this plugin.

...

This plugin requires Joget DX Enterprise version.

Plugin Information

Plugins Available in the Bundle:

  1. Log Cleaner (Process Tool)

This plugin bundle is compatible with Joget

...

DX 8 and onwards.

To download this plugin, visit the Joget Marketplace.

...

Steps to install

  1. In the Joget App Center, Navigate navigate to Settings > Manage Plugins and click > Upload Plugin and click Choose File.
  2.  Select the Log Clearner jar file and click Add. Once the The plugin is listed in the Joget, create the process and tool in that process and select the plugin name in it.in the Installed Plugins tab once uploaded.
  3. In a new app or an existing app, create a new process in the App Composer page.
  4. In Process Builder, add a Tool component to the participant and connect it to the Start component. 
  5. Click the Tool component and in the Mapping tab, select Log Cleaner in the Tools drop-down list.

Image Added

Image Added

Usage

Log Cleaner Plugin Properties

Image Modified

NameDescription
Log Type

Select the logs from the Joget database that will be deleted.

  • API Logs: Deletes logs from the api_log table.
  • Schedule Logs: Deletes logs from the sch_job_log table.
  • Audit Logs: Deletes logs from the wf_audit_trail table.
Duration

Select the number of days before a log is deleted. The following are the options available:

  • 8 days
  • 15 days
  • 30 days
  • 60 days
  • 90 days

...

The Log Cleaner Plugin can also be used with the Scheduler Plugin to trigger the log cleaning process when a specific event occurs, for example, when system storage reaches 200GB clearing logs on the first day of each month. When configuring the Scheduler Plugin properties, select the app containing the Log Cleaner Plugin for the the App field and the Log Cleaner Plugin for the Plugin field.

Image Modified


NameDescription
Job NameSpecify a name for the scheduled job.
Cron Expression

A cron expression is a string comprising five or six fields separated by white space that represents a set of times, normally as a schedule to execute some routine.

App

Select the app containing the Log Cleaner Plugin

Plugin

Select the Log Cleaner Plugin.

Expected Outcome

The following image displays the logs that selected log type database table will be cleared after the expected duration elapses. This is reflected in the Web App Log Viewer as displayed in the image below.

Image Modified

Download Sample App

APP_Log_Cleaner_Pluginlogcleaner-1-20250207013847.jwa

Credits

This plugin, sample app and document is documentation are created by Mokxa Technologies, LLC. For more information, visit