Sure! Custom : You create a form (with SQLFORM) to get what the user want to know that gonna be the parameters of your search... Then you make a query (db(db.table.field_in_which_you_search == the_parameters_you_get_by_your_form).select(db.table.ALL), you create a grid with the results of the search...
Web2py built-in with SQLFORM.grid() You can also use SQLFORM.grid() that will display a grid with a few records (inline) and there is a built-in query builder and search field... If you input your creteria in the field something like "db.table.field_you_want_to_search_in == your_creteria you" will get the records that correspond to you creteria if any. If you only want a list of ids for internal use in another function the custom way is maybe more what you want... But if you build this list just to get the record and want to display them latter you should think to use SQLFORM.grid that provide all what you want as far as I understand what you need. Richard On Tue, Apr 29, 2014 at 9:27 AM, LoveWeb2py <[email protected]> wrote: > > Hello, > > I'm trying to create a search function that allows users to search the > database without accessing the SQLFORM. > > Is there a good way to display multiple results based on the record id? > Could I create a unique SQLFORM view just on the record IDs that are > retrieved? > > Basically my search goes through and checks their search against a huge > database. If their search hits on something in the database I append the > record ID to a list. > > Records = [1,2,5,7,204] > > Is there a way for me to only show those records to them? > > -- > 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 [email protected]. > For more options, visit https://groups.google.com/d/optout. > -- 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 [email protected]. For more options, visit https://groups.google.com/d/optout.
