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?
>>
>
