I finally found out that "equals" don't work but using "contain" does.
It's counter-intuitive but at least there's a workaround.
On Jul 1, 7:24 pm, niknok <nikolai...@gmail.com> wrote:
> I have field "gender" that is defined like so:
>
> Field('gender','reference aux_gender',notnull=True,widget=radio_h)
>
> The aux_gender table data were inserted from:
>
> db.aux_gender.insert(code='F',concept='Female')
> db.aux_gender.insert(code='M',concept='Male')
>
> I have a view that uses crud.search but couldn't search for records on
> gender field. Tried using record id (since they're saved as integers in
> database) but it doesn't produce any search results. Also tried "M", and
> "F" to no avail.
>
> What am I doing wrong here?
>
> /r
> Nik
>
> w2p gender bender.png
> 134KViewDownload
>
> w2p gender bender results.png
> 59KViewDownload
