Web-server: Data Deletion

🔍 Purpose

The Data Deletion by Date form is used for safe and controlled deletion of records from the database based on a selected date range. This is useful for removing outdated entries, reducing storage size, or meeting data retention policy requirements.

🧭 Location

This panel is available under O&K Print Watch web-interface Setting → Database → Storage Settings.

📋 Form Elements

🗓️ Date Range

• Select the start and end date using the calendar picker.
• Date format: DD MMMM YYYY (e.g., 01 January 2024).
• Only records created within the selected date range will be affected.

✅ Deletion Options

• Delete all data – Deletes both print job records and associated document images.
• Delete only document images – Only document images will be deleted.
  Print job data will remain in the database.

🔒 Deletion Confirmation

Before performing the deletion, a confirmation dialog will appear with a warning about the irreversible nature of this action. The user must manually confirm the operation.

⚠️ Important Notes

• Deleted data cannot be recovered.
• Recovery is only possible from a previously created database backup.
• If no matching records are found for the selected date range, the system will notify the user.

🧪 Usage Examples

Example 1: Delete all records for the year 2023

• Date range: 01 January 2023 – 31 December 2023
• Option: Delete all data
• Result: All print jobs and images from that period will be deleted

Example 2: Delete only document images from the last 90 days

• Date range: Last 3 months
• Option: Delete only document images
• Result: All job data will remain; only associated images will be deleted

✅ Recommended Practices

• Regularly delete outdated records (e.g., quarterly) to maintain database efficiency.
• Always create a database backup before deleting data.
• Carefully review the selected date range before confirming the operation.