Happy new Year!
I understand the platform holds deleted records for a specific number of day’s (Default 365) before permanently deleting them.
However how can I retrieve lost data before it is permanently deleted. Luckily this is a test environment.
Regards
Andy
I’m resurrecting this old topic.
@Andy_Harris did you get an answer for this?
Is data only recovered by a full application rollback? or can the deleted record data be requested from the database and provided as csv for example?
Hi Craig (and Andy),
Yes, restoring a backup from the Controller would return your record data to the state at the time of backup.
We have had in mind (for a long time) to provide the means to recover specific deleted records. But (perhaps surprisingly) we haven’t sensed the demand for that to-date.
Opinions welcome on the usefulness of implementing this.
Currently, deleted records can be recovered manually by Netcall (though charges might apply for this service).
Paul
Hi Craig,
Another option - although not trivial!. If you set up an ODBC view on the object, you can get all records both deleted and active. You can include the Status attribute in the view to see which is which.
Give me a call if you need any help setting this up. The one caveat I would give is that you will need a MySQL driver on the system you are reading the data on, as well as setting the IP address in the ODBC database settings.
Richard