Removing Deleted Records Permanently

💬 General Discussion
1

Hi there,
I was looking on my scheduler list and cannot see any scheduler action to purge the database of records that have the field deleted=1 set.

So how do i get suitecrm to clean up the database and remove these old deleted records? or am i going to have to write some sql to do this for me?

thanks
Jamie

2

There is a scheduler called Prune Database. It deletes all records with deleted=1

1 Like
3

Hi Arsalan,
Thanks for replying, I found the scheduler prune database, and set the time to run every 5 minutes to test.
It is showing that it is running, but when i do a select * from accounts where deleted=1 it is still returning results.

Any ideas?
Thanks again
Jamie