correct
On Apr 22, 8:36 am, villas <villa...@gmail.com> wrote:
> My guess is that IS_IN_DB doesn't like joins because it needs to
> identify one table to display.
>
> On Apr 22, 5:31 am, niknok <nikolai...@gmail.com> wrote:
>
>
>
>
>
>
>
> > I still couldn't find out how to do it with IS_IN_DB and a DAL Set.
>
> > But using IS_IN_SET works:
>
> > mp_list=gdb(gdb.municipality.province==gdb.province.id)\
> > .select(gdb.municipality.psgc_m,gdb.municipality.name,\
> >
> > gdb.province.name,orderby=gdb.municipality.name).as_list()
> > mp_dd2=[(i['municipality']['psgc_m'],\
> > i['municipality']['name']+' ('+i['province']['name']+')')\
> > for i in mp_list if i]
>
> > Field('muni',requires=IS_IN_SET(mp_dd2,zero='None')
>
> > On Apr 22, 11:02 am, niknok <nikolai...@gmail.com> wrote:
>
> > > I have a set
>
> > > mp_list=gdb(gdb.municipality.province==gdb.province.id)
>
> > > which I'm trying to use it in a select field but causes an error:
>
> > > Field('municipality',requires=IS_IN_DB(mp_list,'municipality.psgc_m',
> > > '%(municipality.name)s
> > > (%(province.name)s)'))
>
> > > I'm trying to get it to show in the dropdown like this: municipal_name
> > > (province_name). How do I format the field names from a set?
>
> > > I tried and can generate a query of the rows I'd like to have :
>
> > > mp_list=gdb(gdb.municipality.province==gdb.province.id)\
> > > .select(gdb.municipality.psgc_m,gdb.municipality.name,\
> > > gdb.province.name,orderby=gdb.municipality.name)
> > > for x in mp_list: print x['municipality']['name']+'
> > > ('+x['province']['name']+')'
