Sort multiple field in array object

Question

I have array obj like this:

[{ A: '24/12/2020', J: 54106, }, { A: '10/dd/2020', J: 54103 }, { A: 'mm/29/2020', J: 54103 }]

I wanna sort J field first then sort A field .. but I have issue when I sort, I wanna result like this :

[ { A: '10/dd/2020', J: 54103 }, { A: 'mm/29/2020', J: 54103 }, { A: '24/12/2020', J: 54106, }]

but data response is :

[{ A: 'mm/29/2020', J: 54103 }, { A: '10/dd/2020', J: 54103 }, { A: '24/12/2020', J: 54106, }]

My code here :

result.sort(function (a, b) {
  return parseFloat(a.J) - parseFloat(b.J) || (a.A) - (b.A);
});

I think it need sort from number to text but it's not like that

parentheses around a single value have no effect. – Nina Scholz Nov 02 '20 at 11:18 — Nina Scholz, Nov 02 '20 at 11:18
what is thew wanted order of the part date string? – Nina Scholz Nov 02 '20 at 12:06 — Nina Scholz, Nov 02 '20 at 12:06

mr hr · Accepted Answer · 2020-11-02T12:27:25.040

2

Just write a compare function to sort it. First compare the J fields and then compare the A fields.

const data = [
  { A: '24/12/2020', J: 54106 },
  { A: '10/dd/2020', J: 54103 },
  { A: 'mm/29/2020', J: 54103 },
];

const cmp = (x, y) => {
  if (x.J === y.J) {
    return x.A.localeCompare(y.A);
  }
  return x.J > y.J ? 1 : -1;
};
const ret = data.sort(cmp);
console.log(ret);

edited Nov 02 '20 at 12:27

answered Nov 02 '20 at 11:03

mr hr

3,162
2
9
19

I don't know why but it's not working when "A": "mm/29/2020" is in first obj, check it: [link](https://jsfiddle.net/0hb3yjqu/) – Trần Đình Khanh Nov 02 '20 at 11:58
What is A field? Do you want to compare it as a date or string? – mr hr Nov 02 '20 at 12:09
I just want to compare as string, I think number will be sort first then character, it's right? – Trần Đình Khanh Nov 02 '20 at 12:13
I try with this data but not working too: ```const data = [ { A: 'mm', J: 54103, }, { A: '10', J: 54103, } ]; ``` – Trần Đình Khanh Nov 02 '20 at 12:21
now check it and let me know it's working or not. – mr hr Nov 02 '20 at 12:28
it's not working :( .. You can check here [link](https://jsfiddle.net/0hb3yjqu/) – Trần Đình Khanh Nov 02 '20 at 12:36
You are using the old code. Replace it with the new one that I have just updated here. Just replace this line return y.A - x.A; with return x.A.localeCompare(y.A); – mr hr Nov 02 '20 at 12:37

Sort multiple field in array object

1 Answers1