How to filter the json data using jquery

Question

I am working on asp.net mvc. I have a json response like,

[{"firstname":"xxx","lastname":"yyy","name":"zzz"},
{"firstname":"aaa","lastname":"bbb","name":"ccc"},
{"firstname":"zzz","lastname":"eee","name":"ddd"},
...]

Now i want to filter the above json response by name that startwith search criteria. I havebeen followed the following way,

var array=[];
array = jQuery.grep(jsondata, function (n,i) { return n.name.startsWith(searchstring); });

but i always get empty array. please guide me.

You would be better to filter the data server side, pass in your search query data as part of the JSON request.. maybe, I guess it depends on your UI requirements — musefan
– musefan, Commented Dec 5, 2012 at 16:41

Michael Malinovskij · Accepted Answer · 2012-12-05 17:23:47Z

1

Probably jQuery.parseJSON() will help.

var data = $.parseJSON(<pass server json here>)[0], // 0 is used to match your example
    ret = [],
    rg = new RegExp('^' + search);

for (var i in data){
    if ( rg.test(data[i].name) ){ // '^' symbol is required.
        ret.push(data[i]);
    }
}

edited Dec 5, 2012 at 17:23

answered Dec 5, 2012 at 16:42

Michael Malinovskij

1,4228 silver badges22 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Karthik Bammidi Over a year ago

starts with condition not working here. is there any other way for that?

Karthik Bammidi Over a year ago

actually i have a variable 'name' in that search string will be stored. if(/^(search)/.test(data[i].name) condition working for for me. how to place varible in the regular expression in place of serach

Michael Malinovskij Over a year ago

RegExp constructor accepts strings as an arguments. Updated the answer.

Collectives™ on Stack Overflow

How to filter the json data using jquery

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related