Cron Job: Delete old or orphaned page history entries

1 Initial Problem

For the very large tables "mail" and "obj_stat" there are tools in Ilias. The "mail" table can be cleaned up with a cronjob ("Administration > System Settings and Maintenance > General Settings > CronJobs > Mail"). E.g. this deletes entries which are older than x-days. Records of the table "obj_stat" can be deleted via "Administration > Achievements > Statistics and Learning Progress => Statistics => Data management".

2 Conceptual Summary

We want to introduce a similar tool for cleaning up the "page_history" table. Requirements for such a cron job would be:

• Operable via the user interface (see cron job as for mail).
• Deletion of dependent objects/files etc. (no remaining obsolete files/data).
• Configurations:
  • It should be possible to activate/deactivate the cron job.
  • The time period should be configurable, e.g. "Delete all older than x days".
  • Optional: Configurable threshold, which specifies how many history entries per object should be kept. E.g. at least x history objects per object should be kept (even if the entries are older than x days).

3 User Interface Modifications

3.1 List of Affected Views

• Administration > System Settings and Maintenance > General Settings > CronJobs
• Every Page History

3.2 User Interface Details

3.3 New User Interface Concepts

none

4 Technical Information

Performance should improve, especially for installations that make heavily use of page editor content (e.g. large wikis).

5 Privacy Information

Since this allows to automatically delete historical data, it should improve the situation when personal data (e.g. names) are part of page content.

6 Security Implications

No security implications.

7 Contact

• Author of the Request: Hörcher, Sascha (Bonn-Rhine-Sieg University), Zenzen, Enrico [ezenzen]
• Maintainer: Killing, Alexander [alex]
• Implementation of the feature is done by: {The maintainer must add the name of the implementing developer.}

8 Funding

If you are interest in funding this feature, please add your name and institution to this list.

• …

9 Discussion

Killing, Alexander [alex], 15 Apr 2021: I fully support this request.

JourFixe, ILIAS [jourfixe], 03 MAY 2021: We highly appreciate this suggestion and schedule the feature for ILIAS 8.

10 Implementation

Test Cases

Test cases completed at 31 MAR 2022 by Zenzen, Enrico [ezenzen]

• C49858: Seiteneditor Verlaufsbereinigung

Approval

Approved at 2022/25/04 by