[web2py] new feature - need help
There is a new feature in trunk. When you make a searchable grid, it will now show a button before the search input field. It says "Query". Hover over it and it will create a popup menu so that you can build the query with the mouse. It works but the css is horrible and I could use some help fixing it. The code is generated by a single function in sqlhtml.py build_search() Massimo
Re: [web2py] new feature - need help
A la Access?! Great... I will try to give a ride to the new smartgrid to see that... Do you have a test app or do the code you publish earlier to try the new smartgrid enable automatically the searhcable function?... I try anyway. Richard On Thu, Oct 6, 2011 at 12:01 AM, Massimo Di Pierro < massimo.dipie...@gmail.com> wrote: > There is a new feature in trunk. When you make a searchable grid, it will > now show a button before the search input field. It says "Query". Hover over > it and it will create a popup menu so that you can build the query with the > mouse. > > It works but the css is horrible and I could use some help fixing it. > The code is generated by a single function in sqlhtml.py build_search() > > Massimo
Re: [web2py] new feature - need help
Ok, not exactly a la access... Pretty good I notice this : "=" create : "name = 'something'" should be "name == 'something'" I don't think about to much about the background complexity of what you try to achieve, but I don't understand why menu is an appropriate way to display this query building thing. Richard On Thu, Oct 6, 2011 at 2:30 PM, Richard Vézina wrote: > A la Access?! Great... > > I will try to give a ride to the new smartgrid to see that... Do you have a > test app or do the code you publish earlier to try the new smartgrid enable > automatically the searhcable function?... > > I try anyway. > > Richard > > > On Thu, Oct 6, 2011 at 12:01 AM, Massimo Di Pierro < > massimo.dipie...@gmail.com> wrote: > >> There is a new feature in trunk. When you make a searchable grid, it will >> now show a button before the search input field. It says "Query". Hover over >> it and it will create a popup menu so that you can build the query with the >> mouse. >> >> It works but the css is horrible and I could use some help fixing it. >> The code is generated by a single function in sqlhtml.py build_search() >> >> Massimo > > >
Re: [web2py] new feature - need help
I just think for 2 min about it... A popup grid seems to me the appropriate display for this query builder... Grid : Field to search Wich type of constrainer Searched value Add createria button Drop box =, <, >, etc. User input + button New row Maybe a 'AND' or 'OR' is needed for createria (between line) Maybe the table should just add a column at the begining when more then one creteria is entered user has to specify the AND or OR... So... AND/ORField to search Wich type of constrainer Searched value Add createria button Drop box =, <, >, etc. User input + button DropboxNew row Query completed (button) What about that?! jQuery UI dialog Richard On Thu, Oct 6, 2011 at 3:17 PM, Richard Vézina wrote: > Ok, not exactly a la access... Pretty good I notice this : > > > "=" create : "name = 'something'" should be "name == 'something'" > > I don't think about to much about the background complexity of what you try > to achieve, but I don't understand why menu is an appropriate way to display > this query building thing. > > Richard > > > On Thu, Oct 6, 2011 at 2:30 PM, Richard Vézina < > ml.richard.vez...@gmail.com> wrote: > >> A la Access?! Great... >> >> I will try to give a ride to the new smartgrid to see that... Do you have >> a test app or do the code you publish earlier to try the new smartgrid >> enable automatically the searhcable function?... >> >> I try anyway. >> >> Richard >> >> >> On Thu, Oct 6, 2011 at 12:01 AM, Massimo Di Pierro < >> massimo.dipie...@gmail.com> wrote: >> >>> There is a new feature in trunk. When you make a searchable grid, it will >>> now show a button before the search input field. It says "Query". Hover over >>> it and it will create a popup menu so that you can build the query with the >>> mouse. >>> >>> It works but the css is horrible and I could use some help fixing it. >>> The code is generated by a single function in sqlhtml.py build_search() >>> >>> Massimo >> >> >> >