Case Insensitive Search

QuestionsCase Insensitive Search
Kumar Gaurav asked 10 years ago

I am evaluating demo mode… same problem, not understood how to use ignorecase thorugh php_grid. Please guide asap

5 Answers
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");

Kumar Gaurav answered 10 years ago

not resolved with bw

Abu Ghufran answered 10 years ago

Hi Kumar,

You can review demo online, and code is same as 'demos/editing/index.php'
http://www.phpgrid.org/demo/demos/editing/index.php

Which database are you using? Above demo is using mysql.

Kumar Gaurav answered 10 years ago

Oracle.
Also, problem is that the component has no configuration for simulating ignorecase : true of jqGrid.
Please help.

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'

Your Answer

10 + 7 =

Login with your Social Id:

OR, enter

Attach code here and paste link in question.
Attach screenshot here and paste link in question.



How useful was this discussion?

Click on a star to rate it!

Average rating 0 / 5. Vote count: 0

No votes so far! Be the first to rate it.

We are sorry that this post was not useful for you!

Let us improve this post!

Tell us how we can improve this post?