Sri asked 11 years ago
I am using full version of phpjqgrid. Is there a way that I can configure case insensitive search?
Abu Ghufran answered 11 years ago
By default, contains and begins with search is case insensitive.
If you can share grid code, it would help in analysis.
Kumar Gaurav answered 10 years ago
I am evaluating demo mode… same problem, not understood how to use ignorecase thorugh php_grid. Please guide asap.
Abu Ghufran answered 10 years ago
You can switch column settings to use begins with search instead of contains.
beginswith is case insensitive using LOWER() function.
$col["searchoptions"]["sopt"] = array("bw");
Abu Ghufran answered 10 years ago
For oracle, your need to replace default 'contains' search with 'beginswith'.
Search following line in jqgrid_dist.php, and edit
stringResult: true,searchOnEnter : false, defaultSearch:'cn'
to
stringResult: true,searchOnEnter : false, defaultSearch:'bw'
Kumar Gaurav answered 10 years ago
Not resolved… nothing which simulates ignore case with Oracle!
Please help.
