Case insensitive search

QuestionsCase insensitive search
Sri asked 10 years ago

I am using full version of phpjqgrid. Is there a way that I can configure case insensitive search?

5 Answers
Abu Ghufran answered 10 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.

Your Answer

19 + 5 =

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?