sorting complex JSON object

Question

Refering to earlier questions about referencing elements of and sorting a JSON (javascript) array. See refer to an element of JSON (Javascript) object Sorting an array of JavaScript objects

Is it possible to sort one branch of a more complex javascript array, such as sorting by price in the example below?

var homes = 
{
    "Agents" : [
        {
            "name" : "Bob Barker" 
        },
        {
            "name" : "Mona Mayflower" 
        } 
    ] ,
    "Listings" : [
        {
            "h_id": "3",
            "city": "Dallas",
            "state": "TX",
            "zip": "75201",
            "price": "162500" 
        },
        {
            "h_id": "4",
            "city": "Bevery Hills",
            "state": "CA",
            "zip": "90210",
            "price": "319250" 
        },
        {
            "h_id": "5",
            "city": "New York",
            "state": "NY",
            "zip": "00010",
            "price": "962500" 
        } 
    ] 
}

thanks you all your help!!!

EDIT

Sorry for the confusion. I meant Javascript as tag. (This should have been apparent by rest of question) I got the sort working, just having trouble iterating through the array.

// before sort 
alert(homes.Listings[0].price); 
// sort 
homes.Listings.sort(sort_by('price', false, parseInt));  
// after sort works: 
alert(homes.Listings[0].price); 
// iteration does not work "$ is not defined" 
$.each(homes.Listings, function(i, thisHome) { 
    alert(thisHome.price);  
});

@BalusC, that's what I was wondering and why I was apprehensive about posting my answer. — Andy E, Jan 18 '10 at 12:29

score 5 · Answer 1 · answered Jan 18 '10 at 12:27

5

The standard Array.sort takes a comparator function. Use that:

function makeNumericCmp(property) {
    return function (a, b) {
        return parseInt(a[property]) - parseInt(b[property]);
    };
}
homes.Listings.sort(makeNumericCmp('price'));

answered Jan 18 '10 at 12:27

outis

75,655
22
151
221

score 1 · Answer 2 · edited May 23 '17 at 12:30

1

The answer is more-or-less in the question you posted a link to:

Sorting an array of JavaScript objects

homes.Listings.sort(function (a, b)
{
    return a.price - b.price;
});

edited May 23 '17 at 12:30

Community

1
1

answered Jan 18 '10 at 12:28

Andy E

338,112
86
474
445

score 0 · Answer 3 · edited May 23 '17 at 12:30

0

I would recommend using a toolkit, for example jQuery. See Sorting JSON by values

edited May 23 '17 at 12:30

Community

1
1

answered Jan 18 '10 at 12:29

Martin

2,956
7
30
59

Why the down vote? Explaining your down vote seems like a decent thing to do. – Martin Jan 18 '10 at 13:11
I did not vote you down, but I suggest you are recommend a big hammer for a small problem. – Upperstage Jan 18 '10 at 14:22
You're right, I didn't know about "The standard Array.sort takes a comparator function." – Martin Jan 18 '10 at 14:52

score 0 · Answer 4 · answered Jan 18 '10 at 14:28

0

Sorry for the confusion. I meant Javascript as tag. (This should have been apparent by rest of question) I got the sort working, just having trouble iterating through the array.

// before sort
alert(homes.Listings[0].price);
// sort
homes.Listings.sort(sort_by('price', false, parseInt)); 
// after sort works:
alert(homes.Listings[0].price);
// iteration does not work "$ is not defined"
$.each(homes.Listings, function(i, thisHome) {
    alert(thisHome.price); 
});

answered Jan 18 '10 at 14:28

rshid

1

This post is fine if intended as an answer to your question (which you're allowed to do), but otherwise you should edit your question to add clarifications. SO is a Q&A site, not a forum. As for the error, it's because `$` isn't a standard object; it's defined by various libraries, which you probably didn't load. – outis Jan 18 '10 at 14:37
I've added this updated information to your question - please delete this "answer". – Andy E Jan 18 '10 at 14:42
Thanks for kind advice. JS library fell off the page during edit. I didn't even think of checking that. – rshid Jan 18 '10 at 14:44

sorting complex JSON object

4 Answers4