How can I sort this JSON using Javascript?

Question

This my JSON file data.

{"434762882136408065":{"hacksilver":1500,"lastDaily":"06/15/2018","username":"Bader56"},"419738969530433548":{"hacksilver":"10009000","lastDaily":"NOT COLLECTED","username":"Robotos"}}

And i want it to log users by richest to not richest like

ROBOTOS: 10009000

Bader56: 1500

i tried

Object.keys(userData).forEach(user => {
        console.log(userData[user].username+': '+userData[user].hacksilver);
    });

but its logging Bader at first place, Also i tried .reverse() but it the same if there third person here

Of course it gives you Bader first as you just load the array. Try sorting it: https://stackoverflow.com/a/7889040/401499 — Tomasz Kapłoński, Jun 15 '18 at 09:29

Eddie · Accepted Answer · 2018-06-15T09:44:53.170

1

You can sort() the array first.

Use Object.values to convert the object into an array. use sort() to reorder the array. Use forEach to loop thru the sorted array.

let userData = {"434762882136408065":{"hacksilver":1500,"lastDaily":"06/15/2018","username":"Bader56"},"419738969530433548":{"hacksilver":"10009000","lastDaily":"NOT COLLECTED","username":"Robotos"}}

Object.values(userData).sort((a, b) => b.hacksilver - a.hacksilver)
                       .forEach(o => {
                            console.log(o.username + ': ' + o.hacksilver);
                       })

If your nodejs does not support Object.values you can use Object.keys as:

let userData = {"434762882136408065":{"hacksilver":1500,"lastDaily":"06/15/2018","username":"Bader56"},"419738969530433548":{"hacksilver":"10009000","lastDaily":"NOT COLLECTED","username":"Robotos"}}

Object.keys(userData).sort((a, b) => userData[b].hacksilver - userData[a].hacksilver)
                     .forEach(o => {
                          console.log(userData[o].username + ': ' + userData[o].hacksilver);
                     })

Doc: sort(), forEach()

edited Jun 15 '18 at 09:44

answered Jun 15 '18 at 09:32

Eddie

26,593
6
36
58

I got Object.values is not a function, BTW im using nodejs – Josha Jun 15 '18 at 09:34
1

what version of Node.js? – Sid Vishnoi Jun 15 '18 at 09:35
6.11.2 on Ubuntu – Josha Jun 15 '18 at 09:37
@Josha I added another block of code using `Object.keys` – Eddie Jun 15 '18 at 09:37
1

@Josha Anyway, Node v7+ supports `Object.values` – Sid Vishnoi Jun 15 '18 at 09:38
Now i got undefined – Josha Jun 15 '18 at 09:39
Yes. will basically sort the users from the higest hacksilver to the lowest – Eddie Jun 15 '18 at 09:41
Im using external file, btw userData is the variable – Josha Jun 15 '18 at 09:42
Yes, you can this on dynamic values. – Eddie Jun 15 '18 at 09:42
1

in data, `hacksilver` has values both as numbers and strings. Cast it to `Number` – Sid Vishnoi Jun 15 '18 at 09:42
@SudhanshuVishnoi how? – Josha Jun 15 '18 at 09:47
Are you able to `console.log(userData)`? – Eddie Jun 15 '18 at 09:47
1

`fs` is async in nature (i think). So make sure that you already have the `userData` before you do the sorting. – Eddie Jun 15 '18 at 09:48

score 1 · Answer 2 · answered Jun 15 '18 at 09:33

Convert the original object to array, so you could use sort method on it, and then sort it by any criteria:

const dataObj = {"434762882136408065":{"hacksilver":1500,"lastDaily":"06/15/2018","username":"Bader56"},"419738969530433548":{"hacksilver":"10009000","lastDaily":"NOT COLLECTED","username":"Robotos"}};

// convert object to array
const dataArr = Object.keys(dataObj).map(key => dataObj[key]);

// sort it by hacksilver value
const sorted = dataArr.sort((a,b) => {
    return Number(b.hacksilver) - Number(a.hacksilver) 
});

console.log(sorted);

How can I sort this JSON using Javascript?

2 Answers2