jQuery Grid Plugin - jqGridForum

Topic RSS

Toolbar Search - Case Insensitive?

20/06/2010
03:02

doubleforte

Member

Members

Forum Posts: 5

Member Since:
19/02/2010

Offline

Is there a way to make the toolbar search case INsensitive? So for example, "LOrem" would bring back both "lorem" and "Lorem"?

Thanks

brian

20/06/2010
13:05

tony

Sofia, Bulgaria

Moderator

Members

Moderators

Forum Posts: 7721

Member Since:
30/10/2007

Offline

Hello,

Thanks, since the local search is relative new feature we will see how to add this in the future releses.

Best Regards

Tony

For professional UI suites for Java Script and PHP visit us at our commercial products site - guriddo.net - by the very same guys that created jqGrid.

21/06/2010
22:26

Renso

Member

Members

Forum Posts: 118

Member Since:
11/09/2008

Offline

Tony, I think this should be determined by the server-side code. If we start adding too many options to jqGrid it is going to become too large and performance will become increasingly hard to tune from your end. I cannot see a situation where a user should decide whether or not a search option should be case sensitive or not, for example address, name, etc should always be case insensitive due to the nature of the Internet today, most folks texting today do not care about case. Anyway, doubleforte, not saying your request has no value but we need to always keep in mind we all use this GREAT plugin and want to keep it lean and mean Laugh

21/06/2010
22:35

doubleforte

Member

Members

Forum Posts: 5

Member Since:
19/02/2010

Offline

I agree that it could be done on the server, but in my current setup, I'm using it to filter local results with no server call. 🙂

22/06/2010
15:36

Renso

Member

Members

Forum Posts: 118

Member Since:
11/09/2008

Offline

doubleforte, how much data are you trying to search through client-side; i.e. how many rows and how does the client-side search/filter affect performance of having to load all data? I'm just curious as I always hit the database for every request as a rule because it is hard to say how a list may grow in size over time and I'm not sure doing client-side filtering outweights the performance hit of loading all the data?

03/08/2010
05:17

himitsu

New Member

Members

Forum Posts: 1

Member Since:
03/08/2010

Offline

This problem you can check when you load a data one time only (loadonce:true) and you wish make a search.

04/08/2010
15:51

archan.bhatt

Member

Members

Forum Posts: 19

Member Since:
29/07/2010

Offline

Any updates on case INsensitive search?

11/08/2010
22:46

rocktheroad

New Member

Members

Forum Posts: 2

Member Since:
11/08/2010

Offline

I am curious about any information about customizing toolbar search. Currently I need to have case insensitive search, as it is mostly default mode whatever you search on the internet. Second one is to modify from "begins with" to "contains" .

I am also using local mode, and I find it very usable. Currently I am having grids with 6000 records, and users preferred little longer loading and quicker data access/search. I think that bandwidth is getting cheaper than ping, making round-trip to server more time consuming overall... But it really depends of use case...

Just wanted to give my support for this feature request... In meanwhile I'll have to make workaround and code it by myself 🙁

06/09/2010
11:04

lagwagone

Member

Members

Forum Posts: 4

Member Since:
06/09/2010

Offline

Anyone manage to find a workaround for this? I've managed to change the search options from begins with to contains (by changing "bw" to "cn" in Grid.Custom.js source line 536).

var so = (this.searchoptions && this.searchoptions.sopt) ? this.searchoptions.sopt[0] : "cn";

I've been fiddling with the case statement around line 550, seems that var v is the string thats been input to search on. I can successfully get v.toLowerCase() but can't figure out what it compares it to so that I can also convert the column data to lower case for the compare.

case 'text':

v = $(

"input[name="+nm+"]",$t.grid.hDiv).val();

if(v) {

sdata[nm] = v;

sopt[nm] = so;

j++;

}

else {

try {

delete $t.p.postData[nm];

}

catch (e) {}

}

break;

Anyone have any ideas?

Thanks,

Neil

06/09/2010
13:06

OlegK

Germany

Member

Members

Forum Posts: 1255

Member Since:
10/08/2009

Offline

Hi!

New 3.8 version of jqGrid which will be soon released has additional defaultSearch option. So you can use filterToolbar ({defaultSearch : "cn"}); for filtering to "contains" instead of default "begins with".

Moreover after reading of your post I suggested very small changes in the code of jqGrid which I just posted in /blog/?page_id=393/bugs/case-insensitive-local-searching/#p19541. After this changes one will be able use new jqGrid option ignoreCase: true. The results you could see in the demo http://www.ok-soft-gmbh.com/jq.....ilter3.htm.

Is it want you wanted?

I hope Tony will include my suggestion in the release of 3.8.

Bests regards
Oleg

06/09/2010
14:40

lagwagone

Member

Members

Forum Posts: 4

Member Since:
06/09/2010

Offline

Hi Oleg,

This is exactly what I was looking for Laugh . Hopefully it is included in the final release of v3.8. I think that seaching contains and ignoring case should be the default.

Thanks so much,

Neil

09/06/2011
11:27

WayFarer

New Member

Members

Forum Posts: 1

Member Since:
09/06/2011

Offline

Guys, any news here?

Was Oleg's solution been integrated to jqGrid?

09/06/2011
11:59

OlegK

Germany

Member

Members

Forum Posts: 1255

Member Since:
10/08/2009

Offline

Hello!

The features described here are the part of jqGrid (since 3.8 version see here).

Regards
Oleg

21/11/2014
14:41

George

Member

Members

Forum Posts: 3

Member Since:
25/08/2014

Offline

Hello!

Can you add ignoreCase for search form as well?

And how to set default search rule to "Contains" in search form?