Sort by multiple objects in a array in Javascript

Question

var customersObj= [ 
    { recordId: "123", groupID: "1992" ,memberID:"10" Name : "John"     },
    { recordId: "141",  groupID: "1994" ,memberID:"13", Name : "Arrow"  },
    { recordId: "111", groupID: "1991",memberID:"12", Name : "Mike" }
];

I need to return the array by sort them first by recordId, then by groupID, then by memberID ...

I tried this but didn't get expected result"

return _.sortBy(customersObj,'recordID','groupID','memberID');

Can someone assist here on this...

felixmosh · Accepted Answer · 2019-10-22 07:17:24Z

2

Pay attention that your *ID are strings, so, I've used Array.map to convert them to ints, and then _.sortBy works expectedly.

I've added additional values to check the sub-sorting.

const customersObj = [{
  recordId: "123",
  groupID: "1992",
  memberID: "10",
  Name: "John"
}, {
  recordId: "141",
  groupID: "1994",
  memberID: "13",
  Name: "Arrow"
}, {
  recordId: "111",
  groupID: "1991",
  memberID: "12",
  Name: "Mike"
}, {
  recordId: "123",
  groupID: "1991",
  memberID: "12",
  Name: "Sean"
}, {
  recordId: "123",
  groupID: "1991",
  memberID: "11",
  Name: "Sara"
}];

const result = customersObj.map(item => ({
  recordId: parseInt(item.recordId, 10),
  groupID: parseInt(item.groupID, 10),
  memberID: parseInt(item.memberID, 10),
  Name: item.Name
}));

console.log(_.sortBy(result, 'recordId', 'groupID', 'memberID'))

<script src="https://cdnjs.cloudflare.com/ajax/libs/lodash.js/4.17.15/lodash.js"></script>

answered Oct 22, 2019 at 7:17

felixmosh

35.8k10 gold badges81 silver badges99 bronze badges

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

2 Comments

Mar1009 Over a year ago

thanks @felixmosh, but converting in to INT doesn't applicable for memberID with values more than six digits, for example the real data for member ID would be '1342493', '148005', '1808779'..So please advice how to sort with third value

felixmosh Over a year ago

JS supports 6 digits as ints... max value is Number.MAX_SAFE_INTEGER = 9007199254740991

StepUp · Accepted Answer · 2019-10-22 07:09:45Z

0

Try use this approach:

const customersObj= [
  { recordId: "123", groupID: "1992" ,memberID:"10", Name : "John"     },
  { recordId: "141",  groupID: "1994" ,memberID:"13", Name : "Arrow"  },
  { recordId: "111", groupID: "1991",memberID:"12", Name : "Mike" }
];

const sorted = customersObj.sort((a,b)=>{
  return a.recordId - b.recordId || a.groupID - b.groupID || a.memberID - b.memberID;
})    

console.log(`sorted`, sorted);

answered Oct 22, 2019 at 7:09

StepUp

38.5k16 gold badges95 silver badges159 bronze badges

Comments

Sohail Ashraf · Accepted Answer · 2019-10-22 07:10:20Z

0

you can use sort method with lambda function to sort.

const list = [
{      color: 'white', size: 'XXL' },
    { color: 'red', size: 'XL' },
   { color: 'black', size: 'M' }
]
list.sort((a, b) => (a.color > b.color) ? 1 : -1) // you can add different conditions here.

answered Oct 22, 2019 at 7:10

Sohail Ashraf

10.7k3 gold badges31 silver badges43 bronze badges

Comments

pbachman · Accepted Answer · 2019-10-22 07:18:57Z

0

to sort multiple fields, do it like this

customersObj.sort(function(a, b) {
    return a["recordId"] - b["recordId"] || a["groupID"] - b["groupID"] || a["memberID"] - b["memberID"];
});

answered Oct 22, 2019 at 7:18

pbachman

1,0692 gold badges13 silver badges23 bronze badges

Comments

Paresh Barad · Accepted Answer · 2019-10-22 07:19:30Z

You can sort array of object using multiple values by the following method

var arrayOfObj = [ 
    { recordId: "123", groupID: "1992" ,memberID:"10" , Name : "John"     },
    { recordId: "141",  groupID: "1994" ,memberID:"13", Name : "Arrow"  },
    { recordId: "111", groupID: "1991",memberID:"12", Name : "Mike" }
];

let sortBy = [{
  prop:'recordId',
  direction: 1
},{
  prop:'lastName',
  direction: 1
},{
  prop:'memberID',
  direction: 1
}];

arrayOfObj.sort(function(a,b){
  let i = 0, result = 0;
  while(i < sortBy.length && result === 0) {
    result = sortBy[i].direction*(a[ sortBy[i].prop ].toString() < b[ sortBy[i].prop ].toString() ? -1 : (a[ sortBy[i].prop ].toString() > b[ sortBy[i].prop ].toString() ? 1 : 0));
    i++;
  }
  return result;
})

console.log(arrayOfObj, ":::::");

Nina Scholz · Accepted Answer · 2019-10-22 07:24:23Z

0

With lodash, could take an array of keys and take the right spelling of the wanted keys.

var customersObj = [{ recordId: "123", groupID: "1992", memberID: "10", Name: "John" }, { recordId: "141", groupID: "1994", memberID: "13", Name: "Arrow" }, { recordId: "111", groupID: "1991",
memberID: "12", Name: "Mike" }];

console.log(_.sortBy(customersObj, ['recordId', 'groupID', 'memberID']));
//                                 ^        ^                        ^

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

<script src="https://cdnjs.cloudflare.com/ajax/libs/lodash.js/4.17.11/lodash.min.js"></script>

answered Oct 22, 2019 at 7:24

Nina Scholz

388k26 gold badges367 silver badges417 bronze badges

Comments

mattxml · Accepted Answer · 2019-10-22 07:30:05Z

0

Hi i tried solve your problem :)

const display = document.querySelector(".display");

var customersObj= [ 
    { recordId: "123", groupID: "1992" ,memberID:"10", Name : "John"     },
    { recordId: "141",  groupID: "1994" ,memberID:"13", Name : "Arrow"  },
    { recordId: "111", groupID: "1991",memberID:"12", Name : "Mike" }
];
customersObj.sort(function (a, b) {
    return a.recordId - b.recordId || b.groupID - a.groupID || c.memberID - c.memberID;
});
customersObj.map(obj => {
  const item = document.createElement("div");
  item.textContent += obj.recordId + " " + obj.groupID + " " + obj.memberID +" "+ obj.Name;
  display.appendChild(item);
});

<div class="display">
</div>

answered Oct 22, 2019 at 7:30

mattxml

822 silver badges8 bronze badges

Collectives™ on Stack Overflow

Sort by multiple objects in a array in Javascript

7 Answers 7

2 Comments

Comments

Comments

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

7 Answers 7

2 Comments

Comments

Comments

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related