Hi Annet,
I recently encountered this.
You can do this:
IS_IN_DB(db(db.nav.parentID==0),'nav.id','%(name)s', zero=T('select a value'
))
the first argument can take a db(query)
On Friday, August 31, 2012 2:24:26 PM UTC+8, Annet wrote:
>
> I defined the following table:
>
> db.define_table('nav',
> Field('name',length=32),
> ...
> Field('parentID','reference
> nav',requires=IS_IN_DB(db,'nav.id','%(name)s',zero=T('select
> a value'))))
>
> In the form I'd like to have a drop box which only contains the navs that
> have a parentID==0
>
> I guess the following comes close to what I need?
>
> IS_IN_DB(db,'nav.id','%(name)s',lambda parentID, row:
> db(db.nav.parentID==0).select(),zero=T('select a value'))
>
>
> Kind regards,
>
> Annet
>
--
