Sort JSON by value

Question

how I can sort my json file by name -> value? I want to show by asc value of tag name. Any idea how to convert my json file?

Here is how look my JSON file:

[{
    "id": "105",
    "name": "FIAT",
    "active": true,
    "parentId": "1"
}, {
    "id": "106",
    "name": "AUDI",
    "active": true,
    "parentId": "1"
}, {
    "id": "107",
    "name": "BMW",
    "active": true,
    "parentId": "1"
}, {
    "id": "109",
    "name": "RENAULT",
    "active": true,
    "parentId": "1"
}]

I will be grateful if someone help me. Thanks in advance.

Are you trying to sort on the client side or the server side? — Joe Clay, Feb 23 '16 at 11:17
You should give more information; like said before, we need to know you want to do it in Php or js (eg. if you want to do it client side, you don't even have to change your JSON, and just sort your array on js with _.sort() ) — Julien Leray, Feb 23 '16 at 11:21
Are you trying to sort the whole array of objects by the value of `name`, or are you trying to sort each individual object so that the keys show up in alphabetical order? — Mark Reed, Feb 23 '16 at 11:23

score 48 · Accepted Answer · edited Jun 05 '20 at 14:18

48

I suggest to use Array#sort()

var data = [
    { "id": "105", "name": "FIAT",    "active": true, "parentId": "1" },
    { "id": "106", "name": "AUDI",    "active": true, "parentId": "1" },
    { "id": "107", "name": "BMW",     "active": true, "parentId": "1" },
    { "id": "109", "name": "RENAULT", "active": true, "parentId": "1" }
];

data.sort(function (a, b) {
    return a.name.localeCompare(b.name);
});

document.write('<pre>' + JSON.stringify(data, 0, 4) + '</pre>');

edited Jun 05 '20 at 14:18

Gleb Kemarsky

10,160
7
43
68

answered Feb 23 '16 at 11:20

Nina Scholz

376,160
25
347
392

2

Is localeCompare support extensive enough? – Matthijs Feb 23 '16 at 11:23
@Matthijs, what do you mean with *extensive*? – Nina Scholz Feb 23 '16 at 11:25
1

I was talking about browser support. Turns out Safari does not support locale comparisons in the way you describe; so if you're targeting that, another type of comparison is required. – Matthijs Feb 23 '16 at 11:28
1

yes, that's right. `a.name - b.name` – Nina Scholz Feb 23 '16 at 11:49

score 17 · Answer 2 · edited Mar 09 '21 at 15:14

17

Pretty straight-forward.

var data = [
  { "id": "105", "name": "FIAT",    "active": true, "parentId": "1" },
  { "id": "106", "name": "AUDI",    "active": true, "parentId": "1" },
  { "id": "107", "name": "BMW",     "active": true, "parentId": "1" },
  { "id": "109", "name": "RENAULT", "active": true, "parentId": "1" }
];

data.sort(function(a, b) {
  return a.name > b.name;
});

console.log(data);

edited Mar 09 '21 at 15:14

Penny Liu

15,447
5
79
98

answered Feb 23 '16 at 11:23

dorado

1,515
1
15
38

1

you are actually calling 2 times data.sort(), the second call is redundant – Max Jan 29 '19 at 14:45
Cant we use `return a.name - b.name` instead of `return a.name > b.name;` – Shivam Suchak Jan 06 '22 at 14:06

Sort JSON by value

2 Answers2

Linked

Related