Any hint on why only one field is missing in the search drop down smartgrid ? Is there a way to find a "special" attribute about a field that would prevent it to be visible in the drop down list ?
ps: I can search on this field (writing the query manualy ) What I've tried so farwithout results # add "redefine = True" in the table creation # specify readable and writable = True just before the grid = ......... # list all the fields in the smartgrid # list of all searchable fields in smartgrid The table: db.define_table('achat', Field('quand' ,'date' , label='Date'), Field('qui' ,'reference qui' , label='Qui' ), Field('typ' ,'reference typ' , label='Type'), Field('fam_id' ,'reference fam' , label='Fam'), Field('det_id' ,'reference det' , label='Det'), Field('montant' ,'float' , label='Montant'), # this is the field that is not showing in smartgrid automatic drop down list from smartgrid Field('famdet_id' ,'reference famdet' , label='Famdet'), Field('commun' ,'boolean' , label='Commun'), Field('cash' ,'boolean' , label='Cash'), Field('dcc' ,'boolean' , label='Payer ce mois'), Field('note' ,'string' , label='Note',length=60)) The test controller: def t(): # this is a simple controler to test different solution grid = SQLFORM.smartgrid(db.achat) return dict(grid=grid) -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.