The default search widget does not support list:reference fields. You can create a custom search widget via the "search_widget" argument, and also specify a custom search query generator via the "searchable" argument. See the SQLFORM.search_menu and SQLFORM.build_query static methods to see how the built-in widget and query generator work.
Anthony On Monday, June 25, 2018 at 9:02:19 AM UTC-4, Paulo wrote: > > I have the exact same question and can't find an easy solution in the web > :/ > > Fields of the type list:reference with multiple choices don't show up in > the smartgrid search engine. Any easy fix for this? > > Example in: http://cehum.ilch.uminho.pt/microrrelatos_xaquinnunez > (The "Repertorio" field is a reference of the table with the same name, > with multiple choices, but dont show up if we expand the search). > > Thanks in advance > > > > > sábado, 21 de Abril de 2018 às 18:32:44 UTC+1, Yoel Benitez Fonseca > escreveu: >> >> Is the grid search not working witch list:reference ? >> >> for example: >> >> db.define_table('thing', Field('name', 'string')) >> db.define_table('person', Field('name', 'string'), Field('things', >> 'list:reference thing')) >> db.person.things.requires = IS_IN_DB(db, 'thing.id', '%(name)s', >> multiple=True) >> >> The things fild can't be search by the grid console ? >> > -- 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.