Here is an update on the search widget.
The solution above does not work if the found results spread over several
pages. The search is lost on the extra pages.
The solution to this is to change all occurrences of 'search_text' appear
in the request with 'keywords'
def search_form(self,url):
form = FORM('',
INPUT(_name='search_text',_value=request.get_vars.keywords,
_style='width:200px;',
_id='searchText'),
INPUT(_type='submit',_value=T('Search')),
INPUT(_type='submit',_value=T('Clear'),
_onclick="jQuery('#keywords').val('');"),
_method="GET",_action=url)
return form
def search_query(tableid,search_text,fields):
words= search_text.split(' ') if search_text else []
query=tableid<0#empty query
for field in fields:
new_query=tableid>0
for word in words:
new_query=new_query&field.contains(word)
query=query|new_query
return query
Then in the function that has the sqlform.grid call, before the call
add
search_text=request.get_vars.keywords
query=search_query(db.tablea.id,search_text,
[db.tablea.fielda,db.tablea.fieldb])
Peter
On Friday, 20 July 2012 22:12:10 UTC+1, Elcimar wrote:
>
> it works now =)
> thanks dude
> about the search query
> Found a hack somewhere in the here group telling to delete it directly
> like:
>
> del grid[0][2]
>
> Em sexta-feira, 20 de julho de 2012 05h29min27s UTC-3, peter escreveu:
>>
>> I think that there is an argument for incorporating my solution into the
>> standard sqlform grid and having a flag for switching between the query
>> system or my simple text search. If the table is being presented in a web
>> application for the great web public then they are going to expect searches
>> to be 'google like'.
>>
>> Peter
>>
>> On Thursday, 19 July 2012 16:22:21 UTC+1, Richard wrote:
>>>
>>> I think it will solve one of the issue I had with using sqlform.grid in
>>> place of sqltable + Datatables. Since Datatables has a pretty simple
>>> search/filter and my users knows how to use it than I would not remove this
>>> kind of easy search/filter functionality and leave them with only a harder
>>> more complex solution, so I stick with sqltable + Datatables even if
>>> sqlform.grid is much more interesting...
>>>
>>> Thank Peter.
>>>
>>> Richard
>>>
>>> On Thu, Jul 19, 2012 at 11:00 AM, peter <peterchu...@gmail.com<javascript:>
>>> > wrote:
>>>
>>>> Thanks for this I had not noticed that clear did not work, I guess I
>>>> never use it.
>>>>
>>>> The problem is a type in the search_form function
>>>>
>>>> The fifth line should read
>>>>
>>>> id = 'search_text'),
>>>>
>>>> not id='searchText'),
>>>>
>>>>
>>>> Does anyone know if I can edit the first message in this topic so as to
>>>> correct it?
>>>>
>>>> Peter
>>>>
>>>>
>>>>
>>>> On Wednesday, 18 July 2012 15:30:59 UTC+1, Elcimar wrote:
>>>>>
>>>>>
>>>>> Works like a charm, but the "Clear" button is working exactly like the
>>>>> "Search" one, without clearing 'search_text' before submit
>>>>> Is there another method to do that?
>>>>>
>>>>> Em segunda-feira, 16 de abril de 2012 23h32min49s UTC-3, Cliff
>>>>> Kachinske escreveu:
>>>>>>
>>>>>> Good one.
>>>>>>
>>>>>> You earned a browser bookmark.
>>>>>>
>>>>>> Thanks.
>>>>>>
>>>>>> On Wednesday, March 7, 2012 4:44:00 AM UTC-5, peter wrote:
>>>>>>>
>>>>>>> As I have commented before, sqlform.grid has a particular way of
>>>>>>> searching. Its combination of search and 'queries' is very powerful.
>>>>>>> However the search does not really work in the way a casual web user
>>>>>>> might expect. If entered - Bob Dylan - in the search box and clicked
>>>>>>> search, then one get 'invalid query'. I eventually worked out how to
>>>>>>> change the search widget, so as I believe this is currently
>>>>>>> undocumented I thought I would share it. The semantics I have chosen
>>>>>>> for search are that it will return records where any of the
>>>>>>> specified
>>>>>>> fields (fielda and fieldb in the example) contain all of the words
>>>>>>> in
>>>>>>> the search field. i.e if the search term is -Bob Dylan- it will
>>>>>>> return
>>>>>>> records that have both Bob and Dylan in the fieldA or both in
>>>>>>> fieldb.
>>>>>>>
>>>>>>> Define a search function that creates the form and a function that
>>>>>>> does the search
>>>>>>>
>>>>>>> def search_form(self,url):
>>>>>>> form = FORM('',
>>>>>>>
>>>>>>> INPUT(_name='search_text',_**value=request.get_vars.search_**text,
>>>>>>> _style='width:200px;',
>>>>>>> _id='searchText'),
>>>>>>> INPUT(_type='submit',_value=**T('Search')),
>>>>>>> INPUT(_type='submit',_value=**T('Clear'),
>>>>>>> _onclick="jQuery('#search_**text').val('');"),
>>>>>>> _method="GET",_action=url)
>>>>>>>
>>>>>>> return form
>>>>>>>
>>>>>>> def search_query(tableid,search_**text,fields):
>>>>>>> words= search_text.split(' ') if search_text else []
>>>>>>> query=tableid<0#empty query
>>>>>>> for field in fields:
>>>>>>> new_query=tableid>0
>>>>>>> for word in words:
>>>>>>> new_query=new_query&field.**contains(word)
>>>>>>> query=query|new_query
>>>>>>> return query
>>>>>>>
>>>>>>> Then in the function that has the sqlform.grid call, before the call
>>>>>>> add
>>>>>>>
>>>>>>> search_text=request.get_vars.**search_text
>>>>>>> query=search_query(db.tablea.**id
>>>>>>> <http://db.tablea.id>,search_text,
>>>>>>>
>>>>>>> [db.tablea.fielda,db.tablea.**fieldb])
>>>>>>> ...
>>>>>>> # the query could now be combined with other queries.
>>>>>>>
>>>>>>> table=SQLFORM.grid(query, search_widget=search_form.....**...)
>>>>>>>
>>>>>>> return dict(table=table)
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> --
>>>>
>>>>
>>>>
>>>>
>>>
>>>
> Em sexta-feira, 20 de julho de 2012 05h29min27s UTC-3, peter escreveu:
>>
>> I think that there is an argument for incorporating my solution into the
>> standard sqlform grid and having a flag for switching between the query
>> system or my simple text search. If the table is being presented in a web
>> application for the great web public then they are going to expect searches
>> to be 'google like'.
>>
>> Peter
>>
>> On Thursday, 19 July 2012 16:22:21 UTC+1, Richard wrote:
>>>
>>> I think it will solve one of the issue I had with using sqlform.grid in
>>> place of sqltable + Datatables. Since Datatables has a pretty simple
>>> search/filter and my users knows how to use it than I would not remove this
>>> kind of easy search/filter functionality and leave them with only a harder
>>> more complex solution, so I stick with sqltable + Datatables even if
>>> sqlform.grid is much more interesting...
>>>
>>> Thank Peter.
>>>
>>> Richard
>>>
>>> On Thu, Jul 19, 2012 at 11:00 AM, peter <peterchu...@gmail.com<javascript:>
>>> > wrote:
>>>
>>>> Thanks for this I had not noticed that clear did not work, I guess I
>>>> never use it.
>>>>
>>>> The problem is a type in the search_form function
>>>>
>>>> The fifth line should read
>>>>
>>>> id = 'search_text'),
>>>>
>>>> not id='searchText'),
>>>>
>>>>
>>>> Does anyone know if I can edit the first message in this topic so as to
>>>> correct it?
>>>>
>>>> Peter
>>>>
>>>>
>>>>
>>>> On Wednesday, 18 July 2012 15:30:59 UTC+1, Elcimar wrote:
>>>>>
>>>>>
>>>>> Works like a charm, but the "Clear" button is working exactly like the
>>>>> "Search" one, without clearing 'search_text' before submit
>>>>> Is there another method to do that?
>>>>>
>>>>> Em segunda-feira, 16 de abril de 2012 23h32min49s UTC-3, Cliff
>>>>> Kachinske escreveu:
>>>>>>
>>>>>> Good one.
>>>>>>
>>>>>> You earned a browser bookmark.
>>>>>>
>>>>>> Thanks.
>>>>>>
>>>>>> On Wednesday, March 7, 2012 4:44:00 AM UTC-5, peter wrote:
>>>>>>>
>>>>>>> As I have commented before, sqlform.grid has a particular way of
>>>>>>> searching. Its combination of search and 'queries' is very powerful.
>>>>>>> However the search does not really work in the way a casual web user
>>>>>>> might expect. If entered - Bob Dylan - in the search box and clicked
>>>>>>> search, then one get 'invalid query'. I eventually worked out how to
>>>>>>> change the search widget, so as I believe this is currently
>>>>>>> undocumented I thought I would share it. The semantics I have chosen
>>>>>>> for search are that it will return records where any of the
>>>>>>> specified
>>>>>>> fields (fielda and fieldb in the example) contain all of the words
>>>>>>> in
>>>>>>> the search field. i.e if the search term is -Bob Dylan- it will
>>>>>>> return
>>>>>>> records that have both Bob and Dylan in the fieldA or both in
>>>>>>> fieldb.
>>>>>>>
>>>>>>> Define a search function that creates the form and a function that
>>>>>>> does the search
>>>>>>>
>>>>>>> def search_form(self,url):
>>>>>>> form = FORM('',
>>>>>>>
>>>>>>> INPUT(_name='search_text',_**value=request.get_vars.search_**text,
>>>>>>> _style='width:200px;',
>>>>>>> _id='searchText'),
>>>>>>> INPUT(_type='submit',_value=**T('Search')),
>>>>>>> INPUT(_type='submit',_value=**T('Clear'),
>>>>>>> _onclick="jQuery('#search_**text').val('');"),
>>>>>>> _method="GET",_action=url)
>>>>>>>
>>>>>>> return form
>>>>>>>
>>>>>>> def search_query(tableid,search_**text,fields):
>>>>>>> words= search_text.split(' ') if search_text else []
>>>>>>> query=tableid<0#empty query
>>>>>>> for field in fields:
>>>>>>> new_query=tableid>0
>>>>>>> for word in words:
>>>>>>> new_query=new_query&field.**contains(word)
>>>>>>> query=query|new_query
>>>>>>> return query
>>>>>>>
>>>>>>> Then in the function that has the sqlform.grid call, before the call
>>>>>>> add
>>>>>>>
>>>>>>> search_text=request.get_vars.**search_text
>>>>>>> query=search_query(db.tablea.**id
>>>>>>> <http://db.tablea.id>,search_text,
>>>>>>>
>>>>>>> [db.tablea.fielda,db.tablea.**fieldb])
>>>>>>> ...
>>>>>>> # the query could now be combined with other queries.
>>>>>>>
>>>>>>> table=SQLFORM.grid(query, search_widget=search_form.....**...)
>>>>>>>
>>>>>>> return dict(table=table)
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> --
>>>>
>>>>
>>>>
>>>>
>>>
>>>
> Em sexta-feira, 20 de julho de 2012 05h29min27s UTC-3, peter escreveu:
>>
>> I think that there is an argument for incorporating my solution into the
>> standard sqlform grid and having a flag for switching between the query
>> system or my simple text search. If the table is being presented in a web
>> application for the great web public then they are going to expect searches
>> to be 'google like'.
>>
>> Peter
>>
>> On Thursday, 19 July 2012 16:22:21 UTC+1, Richard wrote:
>>>
>>> I think it will solve one of the issue I had with using sqlform.grid in
>>> place of sqltable + Datatables. Since Datatables has a pretty simple
>>> search/filter and my users knows how to use it than I would not remove this
>>> kind of easy search/filter functionality and leave them with only a harder
>>> more complex solution, so I stick with sqltable + Datatables even if
>>> sqlform.grid is much more interesting...
>>>
>>> Thank Peter.
>>>
>>> Richard
>>>
>>> On Thu, Jul 19, 2012 at 11:00 AM, peter <peterchu...@gmail.com<javascript:>
>>> > wrote:
>>>
>>>> Thanks for this I had not noticed that clear did not work, I guess I
>>>> never use it.
>>>>
>>>> The problem is a type in the search_form function
>>>>
>>>> The fifth line should read
>>>>
>>>> id = 'search_text'),
>>>>
>>>> not id='searchText'),
>>>>
>>>>
>>>> Does anyone know if I can edit the first message in this topic so as to
>>>> correct it?
>>>>
>>>> Peter
>>>>
>>>>
>>>>
>>>> On Wednesday, 18 July 2012 15:30:59 UTC+1, Elcimar wrote:
>>>>>
>>>>>
>>>>> Works like a charm, but the "Clear" button is working exactly like the
>>>>> "Search" one, without clearing 'search_text' before submit
>>>>> Is there another method to do that?
>>>>>
>>>>> Em segunda-feira, 16 de abril de 2012 23h32min49s UTC-3, Cliff
>>>>> Kachinske escreveu:
>>>>>>
>>>>>> Good one.
>>>>>>
>>>>>> You earned a browser bookmark.
>>>>>>
>>>>>> Thanks.
>>>>>>
>>>>>> On Wednesday, March 7, 2012 4:44:00 AM UTC-5, peter wrote:
>>>>>>>
>>>>>>> As I have commented before, sqlform.grid has a particular way of
>>>>>>> searching. Its combination of search and 'queries' is very powerful.
>>>>>>> However the search does not really work in the way a casual web user
>>>>>>> might expect. If entered - Bob Dylan - in the search box and clicked
>>>>>>> search, then one get 'invalid query'. I eventually worked out how to
>>>>>>> change the search widget, so as I believe this is currently
>>>>>>> undocumented I thought I would share it. The semantics I have chosen
>>>>>>> for search are that it will return records where any of the
>>>>>>> specified
>>>>>>> fields (fielda and fieldb in the example) contain all of the words
>>>>>>> in
>>>>>>> the search field. i.e if the search term is -Bob Dylan- it will
>>>>>>> return
>>>>>>> records that have both Bob and Dylan in the fieldA or both in
>>>>>>> fieldb.
>>>>>>>
>>>>>>> Define a search function that creates the form and a function that
>>>>>>> does the search
>>>>>>>
>>>>>>> def search_form(self,url):
>>>>>>> form = FORM('',
>>>>>>>
>>>>>>> INPUT(_name='search_text',_**value=request.get_vars.search_**text,
>>>>>>> _style='width:200px;',
>>>>>>> _id='searchText'),
>>>>>>> INPUT(_type='submit',_value=**T('Search')),
>>>>>>> INPUT(_type='submit',_value=**T('Clear'),
>>>>>>> _onclick="jQuery('#search_**text').val('');"),
>>>>>>> _method="GET",_action=url)
>>>>>>>
>>>>>>> return form
>>>>>>>
>>>>>>> def search_query(tableid,search_**text,fields):
>>>>>>> words= search_text.split(' ') if search_text else []
>>>>>>> query=tableid<0#empty query
>>>>>>> for field in fields:
>>>>>>> new_query=tableid>0
>>>>>>> for word in words:
>>>>>>> new_query=new_query&field.**contains(word)
>>>>>>> query=query|new_query
>>>>>>> return query
>>>>>>>
>>>>>>> Then in the function that has the sqlform.grid call, before the call
>>>>>>> add
>>>>>>>
>>>>>>> search_text=request.get_vars.**search_text
>>>>>>> query=search_query(db.tablea.**id
>>>>>>> <http://db.tablea.id>,search_text,
>>>>>>>
>>>>>>> [db.tablea.fielda,db.tablea.**fieldb])
>>>>>>> ...
>>>>>>> # the query could now be combined with other queries.
>>>>>>>
>>>>>>> table=SQLFORM.grid(query, search_widget=search_form.....**...)
>>>>>>>
>>>>>>> return dict(table=table)
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> --
>>>>
>>>>
>>>>
>>>>
>>>
>>>
> Em sexta-feira, 20 de julho de 2012 05h29min27s UTC-3, peter escreveu:
>>
>> I think that there is an argument for incorporating my solution into the
>> standard sqlform grid and having a flag for switching between the query
>> system or my simple text search. If the table is being presented in a web
>> application for the great web public then they are going to expect searches
>> to be 'google like'.
>>
>> Peter
>>
>> On Thursday, 19 July 2012 16:22:21 UTC+1, Richard wrote:
>>>
>>> I think it will solve one of the issue I had with using sqlform.grid in
>>> place of sqltable + Datatables. Since Datatables has a pretty simple
>>> search/filter and my users knows how to use it than I would not remove this
>>> kind of easy search/filter functionality and leave them with only a harder
>>> more complex solution, so I stick with sqltable + Datatables even if
>>> sqlform.grid is much more interesting...
>>>
>>> Thank Peter.
>>>
>>> Richard
>>>
>>> On Thu, Jul 19, 2012 at 11:00 AM, peter <peterchu...@gmail.com<javascript:>
>>> > wrote:
>>>
>>>> Thanks for this I had not noticed that clear did not work, I guess I
>>>> never use it.
>>>>
>>>> The problem is a type in the search_form function
>>>>
>>>> The fifth line should read
>>>>
>>>> id = 'search_text'),
>>>>
>>>> not id='searchText'),
>>>>
>>>>
>>>> Does anyone know if I can edit the first message in this topic so as to
>>>> correct it?
>>>>
>>>> Peter
>>>>
>>>>
>>>>
>>>> On Wednesday, 18 July 2012 15:30:59 UTC+1, Elcimar wrote:
>>>>>
>>>>>
>>>>> Works like a charm, but the "Clear" button is working exactly like the
>>>>> "Search" one, without clearing 'search_text' before submit
>>>>> Is there another method to do that?
>>>>>
>>>>> Em segunda-feira, 16 de abril de 2012 23h32min49s UTC-3, Cliff
>>>>> Kachinske escreveu:
>>>>>>
>>>>>> Good one.
>>>>>>
>>>>>> You earned a browser bookmark.
>>>>>>
>>>>>> Thanks.
>>>>>>
>>>>>> On Wednesday, March 7, 2012 4:44:00 AM UTC-5, peter wrote:
>>>>>>>
>>>>>>> As I have commented before, sqlform.grid has a particular way of
>>>>>>> searching. Its combination of search and 'queries' is very powerful.
>>>>>>> However the search does not really work in the way a casual web user
>>>>>>> might expect. If entered - Bob Dylan - in the search box and clicked
>>>>>>> search, then one get 'invalid query'. I eventually worked out how to
>>>>>>> change the search widget, so as I believe this is currently
>>>>>>> undocumented I thought I would share it. The semantics I have chosen
>>>>>>> for search are that it will return records where any of the
>>>>>>> specified
>>>>>>> fields (fielda and fieldb in the example) contain all of the words
>>>>>>> in
>>>>>>> the search field. i.e if the search term is -Bob Dylan- it will
>>>>>>> return
>>>>>>> records that have both Bob and Dylan in the fieldA or both in
>>>>>>> fieldb.
>>>>>>>
>>>>>>> Define a search function that creates the form and a function that
>>>>>>> does the search
>>>>>>>
>>>>>>> def search_form(self,url):
>>>>>>> form = FORM('',
>>>>>>>
>>>>>>> INPUT(_name='search_text',_**value=request.get_vars.search_**text,
>>>>>>> _style='width:200px;',
>>>>>>> _id='searchText'),
>>>>>>> INPUT(_type='submit',_value=**T('Search')),
>>>>>>> INPUT(_type='submit',_value=**T('Clear'),
>>>>>>> _onclick="jQuery('#search_**text').val('');"),
>>>>>>> _method="GET",_action=url)
>>>>>>>
>>>>>>> return form
>>>>>>>
>>>>>>> def search_query(tableid,search_**text,fields):
>>>>>>> words= search_text.split(' ') if search_text else []
>>>>>>> query=tableid<0#empty query
>>>>>>> for field in fields:
>>>>>>> new_query=tableid>0
>>>>>>> for word in words:
>>>>>>> new_query=new_query&field.**contains(word)
>>>>>>> query=query|new_query
>>>>>>> return query
>>>>>>>
>>>>>>> Then in the function that has the sqlform.grid call, before the call
>>>>>>> add
>>>>>>>
>>>>>>> search_text=request.get_vars.**search_text
>>>>>>> query=search_query(db.tablea.**id
>>>>>>> <http://db.tablea.id>,search_text,
>>>>>>>
>>>>>>> [db.tablea.fielda,db.tablea.**fieldb])
>>>>>>> ...
>>>>>>> # the query could now be combined with other queries.
>>>>>>>
>>>>>>> table=SQLFORM.grid(query, search_widget=search_form.....**...)
>>>>>>>
>>>>>>> return dict(table=table)
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> --
>>>>
>>>>
>>>>
>>>>
>>>
>>>
--
