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
– Mansur Anorboev, Commented Mar 28, 2017 at 6:05

Community · Accepted Answer · 2017-05-23 11:54:22Z

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, 2017 at 11:54

CommunityBot

11 silver badge

answered Mar 28, 2017 at 6:03

Robin Halder

2432 silver badges14 bronze badges

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

2 Comments

bash ishen Over a year ago

it would compare two elements, not just one.

Robin Halder Over a year ago

From those link you can get some ideas how to do that and if you try yourself I guess you can solve it :)

Rohan Kumar · Accepted Answer · 2017-03-28 06:04:58Z

0

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>

answered Mar 28, 2017 at 6:04

Rohan Kumar

40.7k11 gold badges81 silver badges111 bronze badges

Comments

efkan · Accepted Answer · 2017-03-28 06:22:58Z

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)

Collectives™ on Stack Overflow

Sort json data by comparing two objects

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related