Auto Delete Event: Technical Detail

The Auto Delete event is an event that physically deletes old records in the database from specific tables. To trigger this, the event needs to be Active and the field AUTO_DELETE_AGE_FW is required to be greater than 0 on the target table's Table Schema record.

For help around record navigation, please see the article FleetWave Navigation

There is additional information under the FleetWave Core help guide Archiving & Deleting

The Auto Delete event is initially created by FWUpdate with the following default values:

Client_data_events.aspx

• When the option parameter is AUTODELETE, the process will interrogate TABLE_SCHEMA_FW and will fetch a list of tables where AUTO_DELETE_AGE_FW is greater than 0.
• It will go through each table and delete records that are older than AUTO_DELETE_AGE_FW.
• A record’s age is calculated using the difference between Today's date and the record’s CREATE_DATE_FW value.
• The number of records deleted for each table is logged in the Activity Log.

Table specific logic

• ACTIVITY_LOG_FW
  • Only records where importance (IMPORTANCE_FW) is 0 will be deleted.
  • Any records with higher importance value will be kept until manually deleted.
• FWTIMINGS_FW
  • This table has its own delete function, but the behaviour is the same as the default.

Configure Auto Delete Age

To change a table’s Auto Delete Age:

1. Go to TABLE_SCHEMA_FW
2. Search for the table name
3. Edit record
4. Go to Management tab
5. Update the field AUTO_DELETE_AGE_FW
6. Save