PROBLEM SOLVED
I might be wrong but common filter can be an expression that refers ONLY to
the filtered table so it is not a general DAL query.
(please correct me if I am wrong).
Solution:
Create a function that returns an expression with only the filtered table
and assign this function name to the common filter
The function:
def filter_person(query):
avail_groups=db((db.person_group.id==auth_user_person_group.person_group)&(
db.auth_user_person_group.auth_user==auth.user.id))._select(db.person_group.id)
return db.person.person_group.belongs(avail_groups)
Now assign it to the common filter:
db.person._common_filter = filter_person
On Wednesday, November 28, 2018 at 5:54:31 PM UTC+1, icodk wrote:
>
> Getting the following error when setting a common filter on a table:
>
> *Query Not Supported: current transaction is aborted, commands ignored
>> until end of transaction block*
>
>
> Looking in the database log i can see an error on a missing table name in
> a query:
>
> *ERROR: missing FROM-clause entry for table "auth_user_person_group" at
>> character ...*
>
>
> Table definitions:
> db.define_table('person_group',
> Field('name'))
>
> db.define_table('person',
> Field('name'),
> Field('group', 'reference person_group'),
>
>
> The following table is the standard auth_user table and is not part of
> the issue. Mentioned here just for completeness
> db.define_table('auth_user',
> ...
> )
>
> The following table is a many to many that connects personal groups to
> auth_user:
> db.define_table('auth_user_person_group',
> Field('auth_user', 'reference auth_user'),
> Field('group', 'reference person_group'),
> )
>
> ..And this is the common filter I try to use (that gives the above
> mentioned error)
> It's propose is to limit the persons from the person table to those
> belongs to groups that the current auth.user is connected through the many
> to m many table above (auth_user_person_group)
> db.person._common_filter = lambda query: (db.person.person_group ==
> db.auth_user_person_group.person_group)&
> (db.auth_user_person_group.auth_user == auth.user.id)
>
> The query that reaches the database is missing the auth_user_person_group
> table in the FROM part
>
> Help will be greatly appreciated
>
>
>
>
>
--
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 [email protected].
For more options, visit https://groups.google.com/d/optout.
