How can I find the deleted records when using versioning? When I delete a record it is deleted from the table and appears in the archive table. Now I can run a query that looks for all records in the archive table that are not in the table. However is there a better way of identifying the deleted records?
I note that there is an is_active field but this does not seem to be used?
