Actually that solution was not quite correct. The one below is.
if form.process(formname='form').accepted:
rows = db(db.auth_user.location_id ==
auth.user.location_id).select(db.auth_user.id)
db(db.shift_availability.created_by.belongs(rows)).delete()
On Thu, Feb 23, 2017 at 12:57 PM, Mat Miles <matjmi...@gmail.com> wrote:
> Thanks that worked. I have a shift_availability table and the auth_user
> table. The auth_user table contains a location. I want to clear all the
> rows in the shift_availability table but by location. Below is the solution:
>
> if form.process(formname='form').accepted:
> rows = db((db.shift_availability.created_by == db.auth_user.id)
> & (db.auth_user.location_id ==
> auth.user.location_id)).select(db.shift_availability.id)
>
> db(db.shift_availability.id.belongs(rows)).delete()
>
>
> On Wed, Feb 22, 2017 at 5:14 PM, Dave S <snidely....@gmail.com> wrote:
>
>> On Wednesday, February 22, 2017 at 4:03:00 PM UTC-8, Mat Miles wrote:
>>>
>>> I need to create a join to limit the rows to be deleted. Is it possible
>>> to delete a row from one table when a query joins two tables?
>>>
>>
>> Not sure about the full answer, but a partial answer would be to use the
>> join in a SELECT ( db(...).select(), frex) and obtain the row ids, then do
>> a seperate DELETE using those row ids.
>>
>> /dps
>>
>>
>> --
>> Resources:
>> - http://web2py.com
>> - http://web2py.com/book (Documentation)
>> - http://github.com/web2py/web2py (Source code)
>> - https://code.google.com/p/web2py/issues/list (Report Issues)
>> ---
>> You received this message because you are subscribed to a topic in the
>> Google Groups "web2py-users" group.
>> To unsubscribe from this topic, visit https://groups.google.com/d/to
>> pic/web2py/6V2skxjxNG0/unsubscribe.
>> To unsubscribe from this group and all its topics, send an email to
>> web2py+unsubscr...@googlegroups.com.
>> For more options, visit https://groups.google.com/d/optout.
>>
>
>
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
---
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
