Sort JSON array based on its attributes value

Question

This is the JSON Array what Iam getting:

    [
        {
            "Name" : "Sachin",
            "Age"  : "41",
            "Team" : "Mumbai"
        },
        {
            "Name" : "Dravid",
            "Age"  : "42",
            "Team" : "Rajasthan"
        },
        {
            "Name" : "Yuvraj",
            "Age"  : "31",
            "Team" : "Bangalore"
        }
    ]

But I need to sort this JSON array desc by the "Age" attribute. My desired JSON Array should be like below:

 [
    {
        "Name" : "Dravid",
        "Age"  : "42",
        "Team" : "Rajasthan"
    },
    {
        "Name" : "Sachin",
        "Age"  : "41",
        "Team" : "Mumbai"
    },
    {
        "Name" : "Yuvraj",
        "Age"  : "31",
        "Team" : "Bangalore"
    }
]

How to achieve this?

azero0 · Accepted Answer · 2014-07-01 05:54:31Z

6

var a = [
    {
        "Name" : "Sachin",
        "Age"  : "41",
        "Team" : "Mumbai"
    },
    {
        "Name" : "Dravid",
        "Age"  : "42",
        "Team" : "Rajasthan"
    },
    {
        "Name" : "Yuvraj",
        "Age"  : "31",
        "Team" : "Bangalore"
    }
];

   a.sort(function(x,y){return y["Age"]-x["Age"]});
   console.log(a);

answered Jul 1, 2014 at 5:54

azero0

2,3104 gold badges22 silver badges33 bronze badges

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

Comments

abhinsit · Accepted Answer · 2014-07-01 05:50:56Z

2

Use the following generic function predicateBy to sort your data by the desired field

var data=[
            {
                "Name" : "Sachin",
                "Age"  : "41",
                "Team" : "Mumbai"
            },
            {
                "Name" : "Dravid",
                "Age"  : "42",
                "Team" : "Rajasthan"
            },
            {
                "Name" : "Yuvraj",
                "Age"  : "31",
                "Team" : "Bangalore"
            }
        ]    

    function predicatBy(prop){
           return function(a,b){
              if( a[prop] > b[prop]){
                  return 1;
              }else if( a[prop] < b[prop] ){
                  return -1;
              }
              return 0;
           }
        }

        //Usage
        data.sort( predicatBy("age") );
        console.log(data);

answered Jul 1, 2014 at 5:50

abhinsit

3,2574 gold badges23 silver badges26 bronze badges

1 Comment

RobG Over a year ago

A better name would be sortBy as the predicate is the passed property name. ;-)

7zark7 · Accepted Answer · 2014-07-01 05:47:08Z

1

var _ = require('underscore');

var data = ...your data...
console.log(_.sortBy(data, 'Age').reverse());

answered Jul 1, 2014 at 5:47

7zark7

10.2k5 gold badges42 silver badges54 bronze badges

Comments

javinor · Accepted Answer · 2014-07-01 06:46:27Z

1

The naive answer would be to use Array.prototype.sort([compareFunction]). Something in the way of:

function compareAgeProperty(a,b) {
    return (parseInt(a.Age) < parseInt(b.Age)) ? -1 : 1; 
}

var arr = [/* your array's data here */];

arr.sort(compareAgeProperty);

I'd recommend you take a look at: https://developer.mozilla.org/en/docs/Web/JavaScript/Reference/Global_Objects/Array/sort

Your Age property is a string, and thus compared as a string, meaning '80'<'9'===true. Parsing the property should solve this issue.

edited Jul 1, 2014 at 6:46

answered Jul 1, 2014 at 5:59

javinor

6844 silver badges8 bronze badges

1 Comment

thevan Over a year ago

yes.. its giving desired solution when I change the < symbol to > symbol.. thank you..

xecgr · Accepted Answer · 2014-07-01 07:10:58Z

1

Try this:

var arr =   [
        {
            "Name" : "Sachin",
            "Age"  : "41",
            "Team" : "Mumbai"
        },
        {
            "Name" : "Dravid",
            "Age"  : "42",
            "Team" : "Rajasthan"
        },
        {
            "Name" : "Yuvraj",
            "Age"  : "31",
            "Team" : "Bangalore"
        }
    ]

var prop = "Age"

arr.sort(function(a,b){
    var cmp = -1
    if (a.hasOwnProperty(prop) && b.hasOwnProperty(prop)){
        var a_prop_value = parseFloat(a[prop])
        var b_prop_value = parseFloat(b[prop])
        if (isNaN(a_prop_value) || isNaN(b_prop_value)){
            //string comp
            cmp = a[prop].localeCompare(b[prop])
        }else{
            cmp = a_prop_value - b_prop_value > 0? 1 : a_prop_value - b_prop_value ==0? 0:-1
        }
    }
    return cmp;
});

edited Jul 1, 2014 at 7:10

answered Jul 1, 2014 at 5:51

xecgr

5,2033 gold badges22 silver badges28 bronze badges

4 Comments

RobG Over a year ago

Note that localeCompare is implementation dependant and may not produce consistent results.

thevan Over a year ago

its giving correct array structure when we look for Name, but not giving correct solution for Age attribute.

xecgr Over a year ago

i did a read mistake, you are wright @thevan, have a look to my last edit

xecgr Over a year ago

Ok, now you can sort by any of the JSON props, only changing the prop variable

Collectives™ on Stack Overflow

Sort JSON array based on its attributes value

5 Answers 5

Comments

1 Comment

Comments

1 Comment

4 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

Comments

1 Comment

Comments

1 Comment

4 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related