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
– Andy E, Commented Jan 18, 2010 at 12:29

outis · Accepted Answer · 2010-01-18 12:27:56Z

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, 2010 at 12:27

outis

77.7k23 gold badges155 silver badges228 bronze badges

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

Comments

Community · Accepted Answer · 2017-05-23 12:30:46Z

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, 2017 at 12:30

CommunityBot

11 silver badge

answered Jan 18, 2010 at 12:28

Andy E

346k86 gold badges482 silver badges452 bronze badges

Comments

Community · Accepted Answer · 2017-05-23 12:30:46Z

0

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

edited May 23, 2017 at 12:30

CommunityBot

11 silver badge

answered Jan 18, 2010 at 12:29

Martin

2,9717 gold badges31 silver badges59 bronze badges

3 Comments

Martin Over a year ago

Why the down vote? Explaining your down vote seems like a decent thing to do.

Upperstage Over a year ago

I did not vote you down, but I suggest you are recommend a big hammer for a small problem.

Martin Over a year ago

You're right, I didn't know about "The standard Array.sort takes a comparator function."

rshid · Accepted Answer · 2010-01-18 14:28:55Z

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, 2010 at 14:28

rshid

1

3 Comments

outis Over a year ago

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.

Andy E Over a year ago

I've added this updated information to your question - please delete this "answer".

rshid Over a year ago

Thanks for kind advice. JS library fell off the page during edit. I didn't even think of checking that.

Collectives™ on Stack Overflow

sorting complex JSON object

4 Answers 4

Comments

Comments

3 Comments

3 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

3 Comments

3 Comments

Linked

Related