Does anyone know if it's possible to query soft-deleted items to find items in the DB that have been deleted? When setting up a query on an object that can be soft-deleted, the attribute for "Soft-Deletion" is there but when you use it as a criteria and set it to true, nothing comes up. It would be useful to be able to query these and run bulk-actions on things to either undelete items or to edit certain parts of it.
The reason I ask is that end users when deleted sometimes come back and get assigned the same username so they need to be undeleted. Currently the only way is by script. Even if it were not possible to restore deleted items this way (due to other linked objects), we could edit the IsName attribute using a bulk action so that we could import the user again.
If there is a way of doing this I would be grateful to know as presently the only way I can think of is to edit the DB directly and I don't think that should be necessary in this instance.