Details about this thread
  • State Not Answered
  • Replies 3 replies
  • Subscribers 309 subscribers
  • Views 2970 views
  • Users 0 members are here
Related content from around SugarClub

Is there a way to restore deleted leads?

Robert White

User deleted several leads that should not have been deleted - is there a way to recover them.  As an example, SalesForce.com has a wastebasket area where deleted records can be restored.  Anything like this in Sugar?

Parents
  • 0

    If a user deleted them only via the Graphical User Interface, then all it did was set a deleted flag to 1 in the database (aka soft-deleting). Depending on your database clean-up schedule, those records may still exist in the database, you simply need to do a query like:

    UPDATE leads SET deleted = 0 WHERE <condition>;

    Where <condition> in your query would depend on you knowing some condition that can figure out what records are missing.

    However, if the clean-up schedule to delete 'soft-deleted records' has already been ran since, then your only option would be to restore the data from a backup.

Reply
  • 0

    If a user deleted them only via the Graphical User Interface, then all it did was set a deleted flag to 1 in the database (aka soft-deleting). Depending on your database clean-up schedule, those records may still exist in the database, you simply need to do a query like:

    UPDATE leads SET deleted = 0 WHERE <condition>;

    Where <condition> in your query would depend on you knowing some condition that can figure out what records are missing.

    However, if the clean-up schedule to delete 'soft-deleted records' has already been ran since, then your only option would be to restore the data from a backup.

Children
No Data