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/OR    Field to search  Wich type of constrainer   Searched value  Add
createria button
                Drop box          =, <, >, etc.                     User
input         + button
Dropbox    New row

Query completed (button)

What about that?!

jQuery UI dialog

Richard


On Thu, Oct 6, 2011 at 3:17 PM, Richard Vézina
<[email protected]>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 <
> [email protected]> 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 <
>> [email protected]> 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
>>
>>
>>
>

Reply via email to