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
>>>
>>
>>
>
