problem solved. Forgot to add "*list:*reference auth_group" regards António
Em qua., 12 de fev. de 2020 às 11:31, António Ramos <ramstei...@gmail.com> escreveu: > any help ? > thank you > > Em qua., 12 de fev. de 2020 às 11:31, António Ramos <ramstei...@gmail.com> > escreveu: > >> 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) >> >> Em qua., 12 de fev. de 2020 às 11:30, António Ramos <ramstei...@gmail.com> >> escreveu: >> >>> 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: 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') >>> ) >>> >> -- 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. To view this discussion on the web visit https://groups.google.com/d/msgid/web2py/CAEM0BxNkiap2CHw7SCR-HH_YqShWYYsYuAfN2nSvmVYaXcHQPQ%40mail.gmail.com.