Sorting JSON JS Object based on Time

Question

i have a JS object JSON. i need to sort this based on time

I have done some conversion on time and converted SqlTime stamp to JS Date time.

Need to sort the below based on time

[
{
"file_name":"150412-001070",
"date_time":"2015-07-21T13:11:55.000Z",
"polpospercent":68.95,"polnegpercent":31.05,
"Anger":6.58,
"Surprise":32.87,
"Sadness":32.87,
"Joy":4.59,
"Disgust":13.84,
"Fear":9.26,
"file_ts":"2014-04-26T22:03:00.000Z"
},

{"file_name":"150412-001070",
"date_time":"2015-07-21T13:11:55.000Z",
"polpospercent":68.95,"polnegpercent":31.05,
"Anger":6.58,
"Surprise":32.87,
"Sadness":32.87,
"Joy":4.59,
"Disgust":13.84,
"Fear":9.26,
"file_ts":"2014-05-26T22:03:00.000Z"
}
]

@Jayesh Goyani you shouldn't have removed the AngularJS tag ... there might very well be valid AngularJS answers to this thread — devnull69
– devnull69, Commented Jul 23, 2015 at 7:49

Thom-x · Accepted Answer · 2015-07-23 07:30:23Z

Use the filter function on your array :

var a = [
{
"file_name":"150412-001070",
"date_time":"2013-07-21T13:11:55.000Z",
"polpospercent":68.95,"polnegpercent":31.05,
"Anger":6.58,
"Surprise":32.87,
"Sadness":32.87,
"Joy":4.59,
"Disgust":13.84,
"Fear":9.26,
"file_ts":"2014-04-26T22:03:00.000Z"
},

{"file_name":"150412-001070",
"date_time":"2014-07-21T14:11:55.000Z",
"polpospercent":68.95,"polnegpercent":31.05,
"Anger":6.58,
"Surprise":32.87,
"Sadness":32.87,
"Joy":4.59,
"Disgust":13.84,
"Fear":9.26,
"file_ts":"2014-05-26T22:03:00.000Z"
},

{"file_name":"150412-001070",
"date_time":"2017-07-21T18:11:55.000Z",
"polpospercent":68.95,"polnegpercent":31.05,
"Anger":6.58,
"Surprise":32.87,
"Sadness":32.87,
"Joy":4.59,
"Disgust":13.84,
"Fear":9.26,
"file_ts":"2014-05-26T22:03:00.000Z"
},

{"file_name":"150412-001070",
"date_time":"2010-07-21T13:11:55.000Z",
"polpospercent":68.95,"polnegpercent":31.05,
"Anger":6.58,
"Surprise":32.87,
"Sadness":32.87,
"Joy":4.59,
"Disgust":13.84,
"Fear":9.26,
"file_ts":"2014-05-26T22:03:00.000Z"
}
]

var b = a.sort(function(x,y){
  return new Date(x.date_time).getTime() - new Date(y.date_time).getTime();
})

console.log(b);

Siddharth · Accepted Answer · 2015-07-23 07:30:49Z

1

got some reference

function sort(jsonArray, key){
                if(jsonArray){
                   var sortedArray = jsonArray.sort(function(left, right) { 
                                     //array.sort is buit-in function
                       var a = left[key];
                       var b = right[key];
                       if (a !== b) {
                           if (a > b || a === void 0) return 1;
                           if (a < b || b === void 0) return -1;
                       }
                       return 0;
                  });
                  return sortedArray;
                }
            }

it seems to work

answered Jul 23, 2015 at 7:30

Siddharth

5452 gold badges8 silver badges25 bronze badges

Comments

user3227295 · Accepted Answer · 2015-07-23 07:32:25Z

1

use sort function, ann convert it to js date obj.

var array=[
{
"file_name":"150412-001070",
"date_time":"2015-07-21T13:11:55.000Z",
"polpospercent":68.95,"polnegpercent":31.05,
"Anger":6.58,
"Surprise":32.87,
"Sadness":32.87,
"Joy":4.59,
"Disgust":13.84,
"Fear":9.26,
"file_ts":"2014-04-26T22:03:00.000Z"
},

{"file_name":"150412-001070",
"date_time":"2015-07-21T13:11:55.000Z",
"polpospercent":68.95,"polnegpercent":31.05,
"Anger":6.58,
"Surprise":32.87,
"Sadness":32.87,
"Joy":4.59,
"Disgust":13.84,
"Fear":9.26,
"file_ts":"2014-05-26T22:03:00.000Z"
}
];

console.log(array);
var sortedArray=array.sort(function(a,b){
  return new Date(a.file_ts)- new Date(b.file_ts);
})
console.log(sortedArray);

answered Jul 23, 2015 at 7:32

user3227295

2,1561 gold badge13 silver badges17 bronze badges

1 Comment

devnull69 Over a year ago

Converting is not necessary ... the date_time property is in ISO string format which provides "natural" sortability

devnull69 · Accepted Answer · 2015-07-23 07:30:40Z

0

You can use sort() for your array providing a custom sort function

yourjsonobject.sort(function(a, b) {
  if (a.date_time < b.date_time) {
    return -1;
  }
  if (a.date_time > b.date_time) {
    return 1;
  }
  return 0;
});

answered Jul 23, 2015 at 7:30

devnull69

16.6k9 gold badges55 silver badges67 bronze badges

Comments

Sapikelio · Accepted Answer · 2015-07-23 07:33:13Z

Try with this sort function. It works for me!

var files= [
    {
    "file_name":"150412-001070",
    "date_time":"2015-07-21T13:11:55.000Z",
    "polpospercent":68.95,"polnegpercent":31.05,
    "Anger":6.58,
    "Surprise":32.87,
    "Sadness":32.87,
    "Joy":4.59,
    "Disgust":13.84,
    "Fear":9.26,
    "file_ts":"2014-04-26T22:03:00.000Z"
    },
    {
    "file_name":"150412-001070",
    "date_time":"2015-07-21T13:11:55.000Z",
    "polpospercent":68.95,"polnegpercent":31.05,
    "Anger":6.58,
    "Surprise":32.87,
    "Sadness":32.87,
    "Joy":4.59,
    "Disgust":13.84,
    "Fear":9.26,
    "file_ts":"2014-05-26T22:03:00.000Z"
    }
    ];

function sortFiles() {
    files = files.sort(function(a, b) {
        return a["file_ts"]- b["file_ts"];

    });
}

Ankit · Accepted Answer · 2018-08-28 14:27:08Z

0

Just use getTime() method after creating a date object and use filter method. You can use moment as well for date comparision.

But here is what which is simple:-

array.sort(function(a, b){
  return new Date(a.date_time).getTime() < new Date(b.date_time).getTime();
});

answered Aug 28, 2018 at 14:27

Ankit

9906 silver badges12 bronze badges

Comments

Endre Simo · Accepted Answer · 2015-07-23 07:30:36Z

-2

To order by time you can use the orderBy operator.

The orderBy filter the specific array using an expression.

{{[
    {
        "file_name": "150412-001070",
        "date_time": "2015-07-21T13:11:55.000Z",
        "polpospercent": 68.95,
        "polnegpercent": 31.05,
        "Anger": 6.58,
        "Surprise": 32.87,
        "Sadness": 32.87,
        "Joy": 4.59,
        "Disgust": 13.84,
        "Fear": 9.26,
        "file_ts": "2014-04-26T22:03:00.000Z"
    },
    {
        "file_name": "150412-001070",
        "date_time": "2015-07-21T13:11:55.000Z",
        "polpospercent": 68.95,
        "polnegpercent": 31.05,
        "Anger": 6.58,
        "Surprise": 32.87,
        "Sadness": 32.87,
        "Joy": 4.59,
        "Disgust": 13.84,
        "Fear": 9.26,
        "file_ts": "2014-05-26T22:03:00.000Z"
    }
] | orderBy : '+date_time'}}

You can pass either a + or a - to force the sort in ascending or descending order.

answered Jul 23, 2015 at 7:30

Endre Simo

11.6k3 gold badges44 silver badges52 bronze badges

4 Comments

devnull69 Over a year ago

Ahem ... this doesn't seem to be an AngularJS question, does it?

Endre Simo Over a year ago

Hey why the downvote? It was tagged as an angular question, yes?

devnull69 Over a year ago

I didn't see this tag ... right now it is not tagged like this (any more)

devnull69 Over a year ago

You are right, someone removed the tag ... that was not a good idea

Collectives™ on Stack Overflow

Sorting JSON JS Object based on Time

7 Answers 7

Comments

Comments

1 Comment

Comments

Comments

Comments

4 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

7 Answers 7

Comments

Comments

1 Comment

Comments

Comments

Comments

4 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related