We need a way to understand how much data (not what data, but how much) users have on the system to understand how that affects performance.
Under settings we will create an option “Usage Diagnostic” that will generate a CSV file (for download downloads) that shows as rows every section and subsection of eramba (policy, policy review, user management, groups, etc) and the counter for each section as follow:
- number of items
- number of items on trash
- number of (total) notifications
- number of (total) custom fields
- number of Dynamic Status (not system, only those added by user)
- number of filters
- if you have question please ask, the csv does not have to have pretty names on the sections as its going to be mostly for support purposes
This will be used to understand how many items are on the system.
We also need to publish trash functionalities as many people has many things there that could be deleted for once.
We might need an archive functionality … this means that for every section the user will define a period of time by which all functionalities will work (filters, notifications, status calculations, charts, etc) … this would be done from the settings menu as another option on database called “Data Archiving Settings”
For each section we’ll show the number of items grouped by year … then at the last column we need a drop down where the user selects the amount of months to keep as archiving: 1-60 (5 Years). once the user saves settings we need to recalculate things for this to take effect … of course this affects all users on the system.
The archive setting will be clearly shown on the filter output by showing a red label with the counter of items not shown on the filter due archiving settings:
For example: Show 156 Items hidden due Archiving
When the user clicks on the red label you show the items on a new tab … this is in case someone wants to still see the archived data.
Int ref: https://github.com/eramba/eramba_v2/issues/2482