@massimo: we covered all bases. If I'm not mistaken grid uses smart_query, that by default uses '=', that for strings/text/etc maps to 'like', that in turns maps to ilike (after lots of discussion about it). Even if it used contains(), though, for everybody (including the OP that uses sqlite) except MongoDB and GAE, it would still be case-insensitive. If GAE and MongoDB don't have case-insensitivity as a built-in, the only thing to do is documenting the behaviour in the "gotchas" section of the book, not opening yet another ticket in googlecode and leave a web2py-user hanging in there ;-P
@nikos: with sqlite the search is case-insensitive by default. On Friday, October 10, 2014 10:13:35 PM UTC+2, Massimo Di Pierro wrote: > > Yes. grid uses contains(...) to build queries. It should default to case > insensitive except for MongoDB and GAE. We should still have a ticket > perhaps we can deal with these cases and we (I) will not forget. > > On Friday, 10 October 2014 10:01:09 UTC-5, Niphlod wrote: >> >> it's case-insensitive in trunk right now without the need to open a >> ticket. >> >> On Friday, October 10, 2014 6:41:19 AM UTC+2, Massimo Di Pierro wrote: >>> >>> Please open a ticket. We should be able to pass a parameter. >>> >>> On Thursday, 9 October 2014 04:09:47 UTC-5, Nikos Papageorgiou wrote: >>>> >>>> Hi, >>>> I need case insensitive search in grid/smartgird. >>>> Is there a way to implement it ? >>>> >>>> My code looks like : >>>> >>>> def phone_catalogue_manage(): >>>> form = SQLFORM.grid(db.t_phone_catalogue) >>>> return locals() >>>> >>>> My database is sqlite. >>>> >>>> 2.9.11-stable+timestamp.2014.09.15.23.35.11 >>>> (Running on Apache/2.2.3 (CentOS), Python 2.6.8) >>>> >>> -- 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.