Retreving Deleted Data

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

1 Like

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

Is this still the case that there is no way to retrieve deleted data? I just accidently deleted a couple of records I’d rather not have to re-enter? Seems likes a basic piece of functionality to include?
Thanks

Hi Jonathan, yes this is still the case unfortunately. It is a topic that is currently under some discussion, but no decisions have been made at this point. Should it change we will be sure to let everyone know.

Regards - MP