Re: [web2py] Easy to Understand SQLFORM.grid Custom Search
Dear villas, You said: I suppose that my proposal to use shlex would really apply to Peter's suggestion. I guess it might also be considered for use in the build_query function of sqlhtml.py. Shlex seems like a great way of using quotes to contain search phrases. I guess Google would be using something similar, and I'm sure that many of us use that feature all the time. I think you're right on all accounts. Maybe you should post an Enhancement request to Issues-web2py https://code.google.com/p/web2py/issues/list for the build_query function of sqlhtml.py. Love and peace, Joe On Monday, July 21, 2014 8:25:24 AM UTC-7, villas wrote: Hi Joe, I suppose that my proposal to use shlex would really apply to Peter's suggestion. I guess it might also be considered for use in the build_query function of sqlhtml.py. Shlex seems like a great way of using quotes to contain search phrases. I guess Google would be using something similar, and I'm sure that many of us use that feature all the time. On Monday, 14 July 2014 17:54:27 UTC+1, JoeCodeswell wrote: Dear villas, Thanks for the reply. Here is my understanding of what you want. You'd like to be able to search using a search syntax based on the shlex module. My technique uses the SQLFORM.grid's Standard Search Input (#w2p_keywords) syntax for it's searches. I suggest you post an Enhancment suggestion for the SQLFORM.grid's Standard Search Input as a main discussion topic in this forum. Thanks again, villas. Love and peace, Joe On Saturday, July 12, 2014 10:39:31 AM UTC-7, villas wrote: I would also like to add an optional 'extra' because it is nice to be able to search like this: search_text = 'David Cameron uk' By quoting search 'phrases' as well as words, you can get a better result. After all, I would not want every David in the UK to be listed. I have found that using 'shlex' is a good solution. For example: import shlex words = [x for x in shlex.split(search_text)] if search_text else [] I hope this might also be useful to someone wishing to improve their search options. D On Friday, 11 July 2014 00:20:39 UTC+1, peter wrote: Thanks for this Joe, and it is an interesting approach. However I find the approach I used https://groups.google.com/forum/#!searchin/web2py/sqlform.grid$20search/web2py/9_1ECdKHKUo/8OISg7o8OVIJ Somewhat easier to understand. Your approach is more novel however. Peter On Monday, July 21, 2014 8:25:24 AM UTC-7, villas wrote: Hi Joe, I suppose that my proposal to use shlex would really apply to Peter's suggestion. I guess it might also be considered for use in the build_query function of sqlhtml.py. Shlex seems like a great way of using quotes to contain search phrases. I guess Google would be using something similar, and I'm sure that many of us use that feature all the time. On Monday, 14 July 2014 17:54:27 UTC+1, JoeCodeswell wrote: Dear villas, Thanks for the reply. Here is my understanding of what you want. You'd like to be able to search using a search syntax based on the shlex module. My technique uses the SQLFORM.grid's Standard Search Input (#w2p_keywords) syntax for it's searches. I suggest you post an Enhancment suggestion for the SQLFORM.grid's Standard Search Input as a main discussion topic in this forum. Thanks again, villas. Love and peace, Joe On Saturday, July 12, 2014 10:39:31 AM UTC-7, villas wrote: I would also like to add an optional 'extra' because it is nice to be able to search like this: search_text = 'David Cameron uk' By quoting search 'phrases' as well as words, you can get a better result. After all, I would not want every David in the UK to be listed. I have found that using 'shlex' is a good solution. For example: import shlex words = [x for x in shlex.split(search_text)] if search_text else [] I hope this might also be useful to someone wishing to improve their search options. D On Friday, 11 July 2014 00:20:39 UTC+1, peter wrote: Thanks for this Joe, and it is an interesting approach. However I find the approach I used https://groups.google.com/forum/#!searchin/web2py/sqlform.grid$20search/web2py/9_1ECdKHKUo/8OISg7o8OVIJ Somewhat easier to understand. Your approach is more novel however. Peter -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups web2py-users group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
Re: [web2py] Easy to Understand SQLFORM.grid Custom Search
Hi Joe, I suppose that my proposal to use shlex would really apply to Peter's suggestion. I guess it might also be considered for use in the build_query function of sqlhtml.py. Shlex seems like a great way of using quotes to contain search phrases. I guess Google would be using something similar, and I'm sure that many of us use that feature all the time. On Monday, 14 July 2014 17:54:27 UTC+1, JoeCodeswell wrote: Dear villas, Thanks for the reply. Here is my understanding of what you want. You'd like to be able to search using a search syntax based on the shlex module. My technique uses the SQLFORM.grid's Standard Search Input (#w2p_keywords) syntax for it's searches. I suggest you post an Enhancment suggestion for the SQLFORM.grid's Standard Search Input as a main discussion topic in this forum. Thanks again, villas. Love and peace, Joe On Saturday, July 12, 2014 10:39:31 AM UTC-7, villas wrote: I would also like to add an optional 'extra' because it is nice to be able to search like this: search_text = 'David Cameron uk' By quoting search 'phrases' as well as words, you can get a better result. After all, I would not want every David in the UK to be listed. I have found that using 'shlex' is a good solution. For example: import shlex words = [x for x in shlex.split(search_text)] if search_text else [] I hope this might also be useful to someone wishing to improve their search options. D On Friday, 11 July 2014 00:20:39 UTC+1, peter wrote: Thanks for this Joe, and it is an interesting approach. However I find the approach I used https://groups.google.com/forum/#!searchin/web2py/sqlform.grid$20search/web2py/9_1ECdKHKUo/8OISg7o8OVIJ Somewhat easier to understand. Your approach is more novel however. Peter -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups web2py-users group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
Re: [web2py] Easy to Understand SQLFORM.grid Custom Search
Dear villas, Thanks for the reply. Here is my understanding of what you want. You'd like to be able to search using a search syntax based on the shlex module. My technique uses the SQLFORM.grid's Standard Search Input (#w2p_keywords) syntax for it's searches. I suggest you post an Enhancment suggestion for the SQLFORM.grid's Standard Search Input as a main discussion topic in this forum. Thanks again, villas. Love and peace, Joe On Saturday, July 12, 2014 10:39:31 AM UTC-7, villas wrote: I would also like to add an optional 'extra' because it is nice to be able to search like this: search_text = 'David Cameron uk' By quoting search 'phrases' as well as words, you can get a better result. After all, I would not want every David in the UK to be listed. I have found that using 'shlex' is a good solution. For example: import shlex words = [x for x in shlex.split(search_text)] if search_text else [] I hope this might also be useful to someone wishing to improve their search options. D On Friday, 11 July 2014 00:20:39 UTC+1, peter wrote: Thanks for this Joe, and it is an interesting approach. However I find the approach I used https://groups.google.com/forum/#!searchin/web2py/sqlform.grid$20search/web2py/9_1ECdKHKUo/8OISg7o8OVIJ Somewhat easier to understand. Your approach is more novel however. Peter -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups web2py-users group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
Re: [web2py] Easy to Understand SQLFORM.grid Custom Search
I would also like to add an optional 'extra' because it is nice to be able to search like this: search_text = 'David Cameron uk' By quoting search 'phrases' as well as words, you can get a better result. After all, I would not want every David in the UK to be listed. I have found that using 'shlex' is a good solution. For example: import shlex words = [x for x in shlex.split(search_text)] if search_text else [] I hope this might also be useful to someone wishing to improve their search options. D On Friday, 11 July 2014 00:20:39 UTC+1, peter wrote: Thanks for this Joe, and it is an interesting approach. However I find the approach I used https://groups.google.com/forum/#!searchin/web2py/sqlform.grid$20search/web2py/9_1ECdKHKUo/8OISg7o8OVIJ Somewhat easier to understand. Your approach is more novel however. Peter -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups web2py-users group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
Re: [web2py] Easy to Understand SQLFORM.grid Custom Search
Dear viniciusban, *Thanks for the comment. You also said, How about updating the web2pyslices version, too? ;-) .DONE! :)*Thanks again, viniciusban. Love and peace, Joe On Thursday, July 10, 2014 12:10:27 PM UTC-7, viniciusban wrote: Really good. How about updating the web2pyslices version, too? ;-) On Thu, Jul 10, 2014 at 1:09 PM, JoeCodeswell joecod...@gmail.com javascript: wrote: Dear web2py-users, I have written a recipe to customize the SQLFORM.grid search WITHOUT the need to specify a custom search_widget and so needing to read understand the clever web2py implementation source code. The maintained link to the recipe is here on joecodeswell.wordpress.com. An older version is available on web2pyslices.com. Thanks for a GREAT framework and a GREAT community. Love and peace, Joe -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups web2py-users group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+un...@googlegroups.com javascript:. For more options, visit https://groups.google.com/d/optout. -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups web2py-users group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
Re: [web2py] Easy to Understand SQLFORM.grid Custom Search
Dear peter, Thanks for the reply. I have used your post https://groups.google.com/forum/#!searchin/web2py/sqlform.grid$20search/web2py/9_1ECdKHKUo/8OISg7o8OVIJin the past. Reading it and reading the gluon code actually helped me get a grid Custom Search WITH a search_widget specified in the grid function arguments. Thanks again, peter. Love and peace, Joe On Thursday, July 10, 2014 4:20:39 PM UTC-7, peter wrote: Thanks for this Joe, and it is an interesting approach. However I find the approach I used https://groups.google.com/forum/#!searchin/web2py/sqlform.grid$20search/web2py/9_1ECdKHKUo/8OISg7o8OVIJ Somewhat easier to understand. Your approach is more novel however. Peter -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups web2py-users group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
Re: [web2py] Easy to Understand SQLFORM.grid Custom Search
Nice. :-) On Fri, Jul 11, 2014 at 12:33 PM, JoeCodeswell joecodesw...@gmail.com wrote: Dear viniciusban, Thanks for the comment. You also said, How about updating the web2pyslices version, too? ;-) . DONE! :) Thanks again, viniciusban. Love and peace, Joe On Thursday, July 10, 2014 12:10:27 PM UTC-7, viniciusban wrote: Really good. How about updating the web2pyslices version, too? ;-) On Thu, Jul 10, 2014 at 1:09 PM, JoeCodeswell joecod...@gmail.com wrote: Dear web2py-users, I have written a recipe to customize the SQLFORM.grid search WITHOUT the need to specify a custom search_widget and so needing to read understand the clever web2py implementation source code. The maintained link to the recipe is here on joecodeswell.wordpress.com. An older version is available on web2pyslices.com. Thanks for a GREAT framework and a GREAT community. Love and peace, Joe -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups web2py-users group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+un...@googlegroups.com. For more options, visit https://groups.google.com/d/optout. -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups web2py-users group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout. -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups web2py-users group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
[web2py] Easy to Understand SQLFORM.grid Custom Search
Dear web2py-users, I have written a recipe to customize the SQLFORM.grid search WITHOUT the need to specify a custom search_widget and so needing to read understand the clever web2py implementation source code. The maintained link to the recipe is here on joecodeswell.wordpress.com http://joecodeswell.wordpress.com/2014/07/10/easy-to-understand-web2py-grid-custom-search/. An older version is available on web2pyslices.com http://www.web2pyslices.com/slice/show/1979/grid-custom-search-without-specifying-a-custom-search-widget . Thanks for a GREAT framework and a GREAT community. Love and peace, Joe -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups web2py-users group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
Re: [web2py] Easy to Understand SQLFORM.grid Custom Search
Really good. How about updating the web2pyslices version, too? ;-) On Thu, Jul 10, 2014 at 1:09 PM, JoeCodeswell joecodesw...@gmail.com wrote: Dear web2py-users, I have written a recipe to customize the SQLFORM.grid search WITHOUT the need to specify a custom search_widget and so needing to read understand the clever web2py implementation source code. The maintained link to the recipe is here on joecodeswell.wordpress.com. An older version is available on web2pyslices.com. Thanks for a GREAT framework and a GREAT community. Love and peace, Joe -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups web2py-users group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout. -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups web2py-users group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
Re: [web2py] Easy to Understand SQLFORM.grid Custom Search
Thanks for this Joe, and it is an interesting approach. However I find the approach I used https://groups.google.com/forum/#!searchin/web2py/sqlform.grid$20search/web2py/9_1ECdKHKUo/8OISg7o8OVIJ Somewhat easier to understand. Your approach is more novel however. Peter -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups web2py-users group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.