two factors JSON sorting

Question

I found an exellent script example to sorts a JSON according to a specified key:

function sortJSON(data, key, way) {

return data.sort(function(a, b) {

var x = a[key]; var y = b[key];

if (way === '123' ) { return ((x < y) ? -1 : ((x > y) ? 1 : 0)); }

if (way === '321') { return ((x > y) ? -1 : ((x < y) ? 1 : 0)); }

});

}

where:

data = JSON to sort

key = the key you want it sorted with

way = ascending or descending order

My JSON is as follow:

var POL = [

{cName:"John Doe", cDate: new Date(2005, 4, 16), cPassword:"162151", cTeam:34, cEmail:"john.doe@email.com"},

{cName:"Jane Doe", cDate: new Date(2005, 4, 16), cPassword:"161974", cTeam:34, cEmail:"jane.doe@email.com"},

{cName:"Jack Doe", cDate: new Date(2013, 3, 22), cPassword:"167406", cTeam:34, cEmail:"jack.doe@email.com"},

...

]

I need to sort the JSON by cDate first but supposed there are identical dates, I need to sort these by cPassword

How can I update my script, maybe I need something totally different or maybe is it even possible?

try67 · Accepted Answer

No, you need to do it all in a single function.Basically it would be something like this:if (a.cDate==b.cDate) { // compare passwords} else { // compare dates}

MatLac10492407 · Answer

I might have been quick on the response because I just applied my solution to the real JSON and it doesn't sort the second factor. So I inserted an alert in the if statement and found out is is never triggered.

So definittely, comparing the two dates returns false, is there something I'm not getting?

function sortJSON(data, key1, key2, way) {

return data.sort(function(a, b) {

var x = a[key1]; var y = b[key1];

if (a[key1] == b[key1]){

app.alert("test") //never triggers

var x2 = a[key2]; var y2 = b[key2];

if (way === '123' ) { return ((x2 < y2) ? -1 : ((x2 > y2) ? 1 : 0)); }

if (way === '321') { return ((x2 > y2) ? -1 : ((x2 < y2) ? 1 : 0)); }

}

else {

app.alert("test2") //triggers about 72 times

if (way === '123' ) { return ((x < y) ? -1 : ((x > y) ? 1 : 0)); }

if (way === '321') { return ((x > y) ? -1 : ((x < y) ? 1 : 0)); }

}

});

}

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.