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']+')'
