Make sure your app uses the latest appadmin.py from welcome. The new one ignores filters. The old one does not because filters did not exist.
On Tuesday, 10 July 2012 02:37:42 UTC-5, simon wrote: > > Thanks. I saw the is_active column in admin but they were all true! Would > be useful to have a way of turning off these filters in admin. If not then > why have a columnn for is_active where all the contents are "true"? > > On Monday, 9 July 2012 23:46:11 UTC+1, Massimo Di Pierro wrote: >> >> 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? >>> >> > On Monday, 9 July 2012 23:46:11 UTC+1, Massimo Di Pierro wrote: >> >> 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? >>> >> > On Monday, 9 July 2012 23:46:11 UTC+1, Massimo Di Pierro wrote: >> >> 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? >>> >> > On Monday, 9 July 2012 23:46:11 UTC+1, Massimo Di Pierro wrote: >> >> 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? >>> >>
