Hello guys, is that possible to archive records somehow? Example: we have a database with 35k+ records. The problem is that when we do a report, the system is slowly loading all records. We want to archive (but do not delete) old records to speed-up the reporting flow.
You could go the route of having a checkbox field “Archived?” then filtering in the report to only take entities where Archived = False.
Then some kind of automation logic to auto mark things as archived when something happens, or a button to “Archive”, also possible.
Do you mean a custom checkbox field? If yes, how does it help when we create a report? The system collects data from all records as I understand.
This has all the info :))
Edit, it actually doesn’t show where it is…
This filter button will limit the entities that get put into the report. Then there’s the filtering you can do on the data after that, but as you mentioned, that wouldn’t make it run faster.
1 Like
For purely archival needs, one solution is to export the entities - this could be relatively easy using the API.
However if you need to maintain all references/links to other entities, or be able to resurrect “archived” entities, this approach might not be practical.
It works for us, thank you!
Yes, that’s what we were thinking as well. Ideally, it should serve as a mechanism to cache unchanged records in order to speed up the reporting process.