Order array of objects by date then by string value if dates are the same

Question

I have an array of objects:

arr = [
        {
            name : 'Gary',
            DOB : '01/01/1980',
            importance: 'High'
        },
        {
            name : 'Bill',
            DOB : '01/01/1985',
            importance: 'High'
        },
        {
            name : 'Joe',
            DOB : '01/01/1981',
            importance: 'Medium'
        },
        {
            name : 'Phillip',
            DOB : '01/01/1981',
            importance: 'High'
        },
        {
            name : 'Ed',
            DOB : '01/01/1980',
            importance: 'Low'
        },
        {
            name : 'Nix',
            DOB : '01/01/1980',
            importance: 'High'
        },
        {
            name : 'Pat',
            DOB : '01/01/1980',
            importance: 'Low'
        }
    ]

I'm sorting these guys by two fields, first by DOB, and if they have the same DOB, then by importance, Low to High, so Low at the top and High at the bottom.

I can compare their dates easily enough, but I'm having a hard time ordering them by their importance after that?

Can anyone offer any advice?

var importanceOrder = ['Low', 'Normal', 'High'];

arr.sort(function(a, b) {
    if(a.dueDate.value != b.dueDate.value){
        return a.dueDate.value < b.dueDate.value ? -1 : 1;
    } else {
    //??
    }
});

Low, Normal and High should be comparable somehow to sort. Try to map them to integers and then sort by the interger, which will make it easier. — 31piy
– 31piy, Commented May 11, 2018 at 11:07
OK, if you have this var importanceOrder = ['Low', 'Normal', 'High'];, and you have, say, a variable ``a = "Low"` then another that b = "High". With this information alone, how would you check if a > b? — VLAZ
– VLAZ, Commented May 11, 2018 at 11:15

Nina Scholz · Accepted Answer · 2018-05-11 11:16:18Z

2

You could take an object for the sortorder of imortance and a function for getting an ISO date.

const getISO = s => s.replace(/(..)\/(..)\/(....)/, '$3-$1-$2');

var array = [{ name: 'Gary', DOB: '01/01/1980', importance: 'High' }, { name: 'Bill', DOB: '01/01/1985', importance: 'High' }, { name: 'Joe', DOB: '01/01/1981', importance: 'Medium' }, { name: 'Phillip', DOB: '01/01/1981', importance: 'High' }, { name: 'Ed', DOB: '01/01/1980', importance: 'Low' }, { name: 'Nix', DOB: '01/01/1980', importance: 'High' }, { name: 'Pat', DOB: '01/01/1980', importance: 'Low' }],
    order = { Low: 1, Normal: 2, High: 3 };


array.sort((a, b) => getISO(a.DOB).localeCompare(getISO(b.DOB)) || order[a.importance] - order[b.importance]);

console.log(array);

.as-console-wrapper { max-height: 100% !important; top: 0; }

answered May 11, 2018 at 11:16

Nina Scholz

388k26 gold badges367 silver badges417 bronze badges

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

Comments

Maciej Kwas · Accepted Answer · 2018-05-11 11:18:20Z

-1

Ok, this is pretty straightforward, firstly check whether dates are different and sort them in that manner and then if they are equal (x - x == 0 which will return false in first equation) check their importance, easy as that :)

arr.sort((a, b) => new Date(a.DOB) - new Date(b.DOB) || importanceOrder.indexOf(a.importance) - importanceOrder.indexOf(b.importance))

answered May 11, 2018 at 11:18

Maciej Kwas

6,5473 gold badges34 silver badges55 bronze badges

3 Comments

31piy Over a year ago

new Date(a.DOB) -- this doesn't return what you expect. Try it on console. The bahaviour is not consistent among the browsers.

Maciej Kwas Over a year ago

@31piy couldn't assume what the format is, because OP posted all dates with 01/01, so it returns exactly what I expected, I just picked American date notation with "month-day-year" order

31piy Over a year ago

You're not the only one who gets confused at it, mate. :)

Collectives™ on Stack Overflow

Order array of objects by date then by string value if dates are the same

2 Answers 2

Comments

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related