Let me explain something here. The current system provides a syntax to build a general query client side and send it to the server which will parse it, in a safe way.
How you build that query string is up to you. Nothing prevents you from building a JS widget that writes the query client side. Actually I would like to see many such solutions. You can probably steal the JS from some of the other solutions posted in this thread and use them with web2py with minimal work. If you do you may want to package then as a plugin. SQLFORM.grid will do the job for you server side. Massimo On Sep 23, 9:42 am, António Ramos <[email protected]> wrote: > Allow me to show you how this is done in Lotus Notes > > http://www.youtube.com/watch?v=jMYP_RNdZf4 > > Its a built in functionality for every Lotus Notes view. It also search > inside File Attachments. :) > The *fill out example form* is a good idea for regular users. > > António > > 2011/9/23 Massimo Di Pierro <[email protected]> > > > > > > > > > I agree. > > > On Sep 23, 6:50 am, Ross Peoples <[email protected]> wrote: > > > This is a very cool feature! However, I don't think regular users will > > know > > > how to use this. For one, you have to know the field names. You have to > > know > > > that "First Name" is actually "first_name" and that "E-mail" is actually > > > "email". Is there a way to make these queries easier for users? Maybe a > > help > > > button or something that gives field names and explains the other > > operators > > > (contains, is, etc). Or even doing per-field filtering like explained > > > here:http://code.google.com/p/web2py/issues/detail?id=424
