Are "deleted" records in a SQL database customarily reported with active data?
Posted on 2013-06-14
I run a third-party CRM that has been giving us "unexpected" results in our searches. I've tracked this down to the vendor including RECYCLE data in those search results. Specifically, if a record is deleted it is put into Recycle bin. If record remains in Recycle bin, it then is included in query results. The "recycle records" aren't marked as pending deletion which wouldn't make it right but would make it "explainable" to my users who think delete means GONE.
Vendor argues this is normal. I don't think so... do you? I welcome both developer-level and regular-end-user perspective. Brisk, direct and simple replies especially prized.
I cannot turn off Recycle feature nor is there an "auto-empty Recycle bin" option, nor is there a "Delete=Recycle/Keep Active" or "Delete=Delete I Really Mean It" option for users.
I would like some community feedback on whether or not I am correct that the occasional opportunity to restore a record is not worth having inaccurate search results and this feature should be eliminated or better controlled.
Thanks! I'd like to split points like this:
First response = 200
Second and Third response = 150 each
Everybody else who chimes in: thanks and many good graces.