I'm trying to recover cases deleted in Sugar and make a trace of which user I delete them. I'm not sure if the data still exists. I found this information, but so far it has not been very helpful:
I have also tried to understand how the deletion is done and I have treated this, which returns certain results, but not what I am interested in yet:
SELECT cases.id, cases.name, users.first_name, users.title, cases.date_modified
FROM cases
INNER JOIN users ON users.id = cases.modified_user_id
WHERE cases.deleted=1 ORDER BY cases.name ASC;
I see that the sugar has a configuration to purge tables every month (in my case).
I would like to know if someone knows how to find the cases deleted, with traceability of the person who did it or if in the case that I expose, definitely the cases no longer exist, so they could not be recovered.