Oh forget to mention... It needs that we fork superfish.css and js and
rename every class in superfish.css and their call in superfish.js... It's
not pretty nice but it allow to play with the query builder...
I not convinced with a menu a proper ui for a query builder since when your
mice fall outside the menu everything unwrap and you have to start
everything over...
Richard
On Fri, Oct 7, 2011 at 12:50 PM, Richard Vézina <ml.richard.vez...@gmail.com
> wrote:
> Finally find a little fix so you can play with the query builder with a
> "correct" superfish display (pretty ugly) but...
>
> Add this to base.css :
>
> .web2py-menu-expand .sfHover {
> width: 275px;
> }
>
> .web2py-menu-vertical li a input {
> margin: 5px;
> }
>
> Change this in superfis.css :
>
> .sf-menu-query ul {
> width: *275px*; /* left offset of submenus need to match (see below) */
>
> ul.sf-menu-query li li.sfHover-query ul {
> left: *275px*; /* match ul width */
>
> ul.sf-menu-query li li li:hover ul,
> ul.sf-menu-query li li li.sfHover-query ul {
> left: *275px*; /* match ul width */
>
>
> It should make the each menu level 275px so the last level will be
> displaying the input and add button on the same line with the appropriate
> background.
>
> Hope I didn't forget anything...
>
> Richard
>
> On Fri, Oct 7, 2011 at 12:22 PM, Richard Vézina <
> ml.richard.vez...@gmail.com> wrote:
>
>> Massimo,
>>
>> I need a class somewhere here, but can't find how to insert it :
>>
>> for option in options:
>> menu[-1][-1].append((T(option),False,False,
>> [(SPAN(INPUT(_type=field.type),
>>
>> INPUT(_type="button",_value=T('add'),
>>
>> _onclick="w2p_build_search('"+field.name+" "+option+" ',this,event);")),
>> False,False)]), *_class='NEW
>> CLASS'*)
>>
>> I try this :
>> https://mail.google.com/mail/?shva=1#search/add+class+to+menu/12fc24f2a966a78c
>>
>> That works to rename menu class, but can't add a class to the li() that
>> contain the a() that contain the value to be search field and the add
>> button.
>>
>> Richard
>>
>> On Fri, Oct 7, 2011 at 9:44 AM, Richard Vézina <
>> ml.richard.vez...@gmail.com> wrote:
>>
>>> Yeah I tried it... I said that need == because at least with the
>>> yesterday trunk single = didn't returns any result...
>>>
>>> By a la Access I mean the query builder that let you write SQL query by
>>> not writing SQL (you pick the table, then cross check the field, etc.)... I
>>> think the only difference is that it is multitable.
>>>
>>> I can have a look to improve the actual CSS you drop on for now.
>>>
>>> I was asking myself if it could be possible to implement a kind of REGEX
>>> search functionnality like Datatables... With Datatables grid search field
>>> you can put any character and the records are filtered base on the presence
>>> absence of each group of character or single character (not sure exactly).
>>> So for example, you can filter like this :
>>>
>>> 7.49 2010-09-09
>>>
>>> That will return the rows that contain 7.49 value for the given date...
>>>
>>> It mays what you try to achieve with more power by allowing the
>>> possibility to the user to specify the exact columns he wants it value to be
>>> search.
>>>
>>> I try to improve the CSS.
>>>
>>> Ciao!
>>>
>>> Richard
>>>
>>>
>>> On Thu, Oct 6, 2011 at 5:19 PM, Massimo Di Pierro <
>>> massimo.dipie...@gmail.com> wrote:
>>>
>>>> My problem is the css. The rest we can discuss later.
>>>>
>>>> Anyway, field = value is correct.
>>>>
>>>> The search string is not DAL syntax, it is english. You can even write
>>>> "field equals value and otherfield starts with something" without =
>>>> and without quotes around values.
>>>>
>>>> We can add OR support later but AND is automatic. Did you try add two
>>>> queries?
>>>> I am not trying to copy Access. I am trying to create a pluggable and
>>>> customizable way to built the search strings.
>>>> Massimo
>>>>
>>>> On Oct 6, 2:28 pm, Richard Vézina <ml.richard.vez...@gmail.com> wrote:
>>>> > 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
>>>> > <ml.richard.vez...@gmail.com>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
>>>>
>>>
>>>
>>
>
