jQuery Grid Plugin - jqGrid - Topic: case insensitive local searching

mikeerickson on case insensitive local searching

Wed, 22 Sep 2010 21:19:41 +0300

mikeerickson said:

OlegK said:

Hi Tony!

I place the topic in "Bugs" part of forum only to make you easy to find it. I read in forum wisches to implement case insensitive searching for local data and find that it can be very easy implemented in jqGrid. I suggest following changes for grid.base.js:

1) include additional option ignoreCase: false in the line 687 (after groupingView option)

2) After the line 1364: query = $.jgrid.from(ts.p.data); insert the line

if (ts.p.ignoreCase) { query = query.ignoreCase(); }

It's all. You can see demo after the changes under http://www.ok-soft-gmbh.com/jq.....ilter3.htm. I use in the demo filterToolbar with the new option {defaultSearch : "cn"}.

Best regards
Oleg

While this now allows case insensitive searching for data that "cn" it does NOT work from beginning of text

If I have

Abdo

abdo

And I type 'abdo' it will find the second, but not the first.

Well, I guess it does work (it would help if I pasted the code at the right place). Sorry for the noise

mse

mikeerickson on case insensitive local searching

Wed, 22 Sep 2010 21:15:23 +0300

OlegK said:

Hi Tony!

I place the topic in "Bugs" part of forum only to make you easy to find it. I read in forum wisches to implement case insensitive searching for local data and find that it can be very easy implemented in jqGrid. I suggest following changes for grid.base.js:

1) include additional option ignoreCase: false in the line 687 (after groupingView option)

2) After the line 1364: query = $.jgrid.from(ts.p.data); insert the line

if (ts.p.ignoreCase) { query = query.ignoreCase(); }

It's all. You can see demo after the changes under http://www.ok-soft-gmbh.com/jq.....ilter3.htm. I use in the demo filterToolbar with the new option {defaultSearch : "cn"}.

Best regards
Oleg

While this now allows case insensitive searching for data that "cn" it does NOT work from beginning of text

If I have

Abdo

abdo

And I type 'abdo' it will find the second, but not the first.

Chad LaVigne on case insensitive local searching

Thu, 16 Sep 2010 21:51:35 +0300

Thanks for adding these 2 options, I was also looking for them. I'm using Oleg's updates and found a small bug. If the column is a date type, the toLowerCase calls in the compare function fail. These calls are on lines 265 & 266 of Oleg's grid.base-new.js file. I think a toString call is all that is needed to fix it, chaning lines 265 & 266 to following fixed the issue for me.

a=a.toString().toLowerCase();

b=b.toString().toLowerCase();

Thanks for putting out an excellent plugin.

Chad

tony on case insensitive local searching

Sat, 11 Sep 2010 13:40:19 +0300

Oleg,

Thanks again. Too many options into the grid, but instead I will include this.

Tony

OlegK on case insensitive local searching

Mon, 06 Sep 2010 13:00:21 +0300

Hi Tony!

I place the topic in "Bugs" part of forum only to make you easy to find it. I read in forum wisches to implement case insensitive searching for local data and find that it can be very easy implemented in jqGrid. I suggest following changes for grid.base.js:

1) include additional option ignoreCase: false in the line 687 (after groupingView option)

2) After the line 1364: query = $.jgrid.from(ts.p.data); insert the line

if (ts.p.ignoreCase) { query = query.ignoreCase(); }

It's all. You can see demo after the changes under http://www.ok-soft-gmbh.com/jq.....ilter3.htm. I use in the demo filterToolbar with the new option {defaultSearch : "cn"}.

Best regards
Oleg