I don't think virtual fields can be used for searching. You might need to use a computed field instead.
Anthony On Sunday, December 25, 2011 1:45:29 AM UTC-5, ニコノコ wrote: > > Thanks to Anthony for correcting my virtual field definition from > geo.ad1.vname=Field.Virtual(lambda r: "%s, %s" % (r.name, > geo.country(r.id_un).iso3_0)) > to: > geo.ad1.vname=Field.Virtual(lambda r: "%s, %s" % (r.ad1.name, > geo.country(r.ad1.id_un).iso3_0)) #table name specified > > However, it seems that virtual fields don't work with the autocomplete > widget and i get a keyerror 'vname'. > db.address.state.widget=SQLFORM.widgets.autocomplete(request, > geo.ad2.vname, limitby=(0,10), min_length=2) > > Perhaps it's only my mistake, but could someone confirm that autocomplete > don't work with virtual fields ? > >
