cannot reference db.auth_group in model ?

30 views
Skip to first unread message

António Ramos

unread,
Feb 12, 2020, 6:31:12 AM2/12/20
to web...@googlegroups.com
Hello all i have a problem relating a record to auth_group records

creating in admin a new record in table menus, referencing one or more auth_group record results in a record with None in visibleTo field. 
Why ?
image.png
db.define_table("apps",
    Field("title"),
    Field("icon"),
    Field("bg"),
    Field("url"),
    format='%(title)s'
    )
db.define_table('menus',
            Field("visibleTo",'reference auth_group'),
            Field("app",'reference apps'),
            Field('content','list:string'),
            Field('icon'),
            Field('href'),
            Field('indice')
)
db.menus.visibleTo.requires=IS_IN_DB(db,db.auth_group.id,'%(role)s',multiple=True)
            Field('href'),
            Field('indice')
)

António Ramos

unread,
Feb 12, 2020, 6:31:44 AM2/12/20
to web...@googlegroups.com
correct model
db.define_table("apps",
    Field("title"),
    Field("icon"),
    Field("bg"),
    Field("url"),
    format='%(title)s'
    )
db.define_table('menus',
            Field("visibleTo",'reference auth_group'),
            Field("app",'reference apps'),
            Field('content','list:string'),
            Field('icon'),
            Field('href'),
            Field('indice')
)
db.menus.visibleTo.requires=IS_IN_DB(db,db.auth_group.id,'%(role)s',multiple=True)

António Ramos

unread,
Feb 12, 2020, 6:32:02 AM2/12/20
to web...@googlegroups.com
any help ?
thank you

António Ramos

unread,
Feb 12, 2020, 6:55:19 AM2/12/20
to web...@googlegroups.com
problem solved.
Forgot to add "list:reference auth_group"

regards
António
Reply all
Reply to author
Forward
0 new messages