When versioning is on and you delete a record, the record is not actually deleted but is_active is set to False. All queries for tables for versioning automatically add a query is_active==True to filter them out and you no longer see deleted records. You do not need to look for them into the archive tables. You can simply do
db(db.table.is_active==False,ignore_common_filters=True).select() On Monday, 9 July 2012 15:54:10 UTC-5, simon wrote: > > 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? >
