Case Insensitive Search with Array as data source

QuestionsCase Insensitive Search with Array as data source
Gurdeep asked 3 years ago

Hi Abu,

I have a grid with an array set as the data source. When I try to use the inline search to filter the grid, it is Case Sensitive and I would like it to be case insensitive.

I had set the column up as:

$col["name"] = 'column_name';
$col["dbname"] = 'LOWER(column_name)';

This was to try to search the column in lower case, but it did not work. Could you please advise on how to get this inline search working Case Insensitive for a grid with an array as the data source?

Thanks

2 Answers
Abu Ghufran answered 3 years ago

For case insensitive searching with array based grid, you need to set:
$opt["ignoreCase"] = true;

$g->set_options($opt);

Gurdeep Sembi answered 3 years ago

Thanks a lot Abu for the quick reply,

That worked perfectly!

Your Answer

2 + 17 =

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?