Sort json data by comparing two objects

Question

Please help! I have the following json data below and I want to compare the object's Date and Request using jquery and return the data with the recent date and latest request.

json:

[Object{
 'Date': '3/27/2017',
 'Item': '100',
 'Request': '2'
},
Object{
 'Date': '3/28/2017',
 'Item': '100',
 'Request': '1'
},
Object{
 'Date': '3/27/2017',
 'Item': '100',
 'Request': '1'
},
Object{
 'Date': '3/28/2017',
 'Item': '100',
 'Request': '2'
}]

So the expected result would be:

[Object{
 'Date': '3/28/2017',
 'Item': '100',
 'Request': '2'
 },
 Object{
 'Date': '3/28/2017',
 'Item': '100',
 'Request': '1'
 },
 Object{
 'Date': '3/27/2017',
 'Item': '100',
 'Request': '2'
 },
Object{
'Date': '3/27/2017',
'Item': '100',
'Request': '1'
}]

i don't think you need jquery for this. Use javascript sort() method. — Mansur Anorboev, Mar 28 '17 at 06:05
Possible duplicate of [sort json object in javascript](http://stackoverflow.com/questions/17684921/sort-json-object-in-javascript) — efkan, Mar 28 '17 at 06:24

score 0 · Answer 1 · edited May 23 '17 at 11:54

0

This link will give you some idea how to work sort javascript object.

Sort Json object in javascript

Simple function to sort an array of objects

edited May 23 '17 at 11:54

Community

1
1

answered Mar 28 '17 at 06:03

Robin Halder

253
2
14

it would compare two elements, not just one. – bash ishen Mar 28 '17 at 06:10
From those link you can get some ideas how to do that and if you try yourself I guess you can solve it :) – Robin Halder Mar 28 '17 at 06:12

score 0 · Answer 2 · answered Mar 28 '17 at 06:04

Try this,

var json = [{
    'Date': '3/27/2017',
    'Item': '100',
    'Request': '2'
  },
  {
    'Date': '3/28/2017',
    'Item': '100',
    'Request': '1'
  },
  {
    'Date': '3/27/2017',
    'Item': '100',
    'Request': '1'
  },
  {
    'Date': '3/28/2017',
    'Item': '100',
    'Request': '2'
  }
];

// sort function callback
function sort_obj(a, b) {
  return (new Date(b.Date) > new Date(a.Date) ||
            b.Request > a.Request) ? 1 : -1;
}
var output = [];
output.push($(json).sort(sort_obj));
console.log(output);

<script src="https://ajax.googleapis.com/ajax/libs/jquery/1.9.1/jquery.min.js"></script>

efkan · Answer 3 · 2017-03-28T06:22:58.423

You don't need to use jquery for to perform the sorting operation. You can overcome by using plain Javascript code.

(This is the source you need to read)

Also I've added code to jsfiddle

And also the code snippet below can be run.

Note: return (b.Date - a.Date) sorts the objects from the object that has the biggest date to the object that has the smallest date.
return (a.Date - b.Date) sorts from small to big.
This is valid for the all elements of an array (return a-b and return b-a)

Good luck!

let array = [{
 'Date': '3/27/2017',
 'Item': '100',
 'Request': '2'
},
{
 'Date': '3/28/2017',
 'Item': '100',
 'Request': '1'
},
{
 'Date': '3/27/2017',
 'Item': '100',
 'Request': '1'
},
{
 'Date': '3/28/2017',
 'Item': '100',
 'Request': '2'
}]

array.sort(compare)

function compare (a, b) {
 return (new Date(b.Date) - new Date(a.Date))
}

console.log(array)

Sort json data by comparing two objects

3 Answers3