I'm trying to apply group and sort on objects.

var emplData = [{
    "pany": "panyA",
    "title": "positionA",
    "office": "Boston",
    "first-name": "Mike",
    "last-name": "Bloom",
    "profile-url": "url"
}, {
    "pany": "panyA",
    "title": "positionD",
    "office": "Amsterdam",
    "first-name": "Adam",
    "last-name": "Smart",
    "profile-url": "url"
}, {
    "pany": "panyB",
    "title": "positionB",
    "office": "Toronto",
    "first-name": "Tina",
    "last-name": "Carmichael",
    "profile-url": "url"
}, {
    "pany": "panyB",
    "title": "positionA",
    "office": "Chicago",
    "first-name": "Seth",
    "last-name": "Big",
    "profile-url": "url"
}, {
    "pany": "panyC",
    "title": "positionC",
    "office": "St. Louis",
    "first-name": "Carla",
    "last-name": "Elsas",
    "profile-url": "url"
}]

I like to group the data by pany and then sort by office (ascending order). I'm using underscore.js to group and it returns similar to object below.

var grpData = _.groupBy(emplData, 'pany');

  {
    CompanyA:[{object1}, {object2} etc.],
    CompanyB: [{object1}, {object2} etc.],
    CompanyC: [{object1}, {object2} etc.]
  }

Now each object inside the grouped array has properties including office, I can't get the results I need to sort the data by it so we have an ascending order.

I have tried below method but doesn't seem to work.

var srtData = _.sortBy(grpData , function (i) {
    $(i).each(function (i2, val) {
        return val.office;
    });
});

Anyone know a solution for this?

I'm trying to apply group and sort on objects.

var emplData = [{
    "pany": "panyA",
    "title": "positionA",
    "office": "Boston",
    "first-name": "Mike",
    "last-name": "Bloom",
    "profile-url": "url"
}, {
    "pany": "panyA",
    "title": "positionD",
    "office": "Amsterdam",
    "first-name": "Adam",
    "last-name": "Smart",
    "profile-url": "url"
}, {
    "pany": "panyB",
    "title": "positionB",
    "office": "Toronto",
    "first-name": "Tina",
    "last-name": "Carmichael",
    "profile-url": "url"
}, {
    "pany": "panyB",
    "title": "positionA",
    "office": "Chicago",
    "first-name": "Seth",
    "last-name": "Big",
    "profile-url": "url"
}, {
    "pany": "panyC",
    "title": "positionC",
    "office": "St. Louis",
    "first-name": "Carla",
    "last-name": "Elsas",
    "profile-url": "url"
}]

I like to group the data by pany and then sort by office (ascending order). I'm using underscore.js to group and it returns similar to object below.

var grpData = _.groupBy(emplData, 'pany');

  {
    CompanyA:[{object1}, {object2} etc.],
    CompanyB: [{object1}, {object2} etc.],
    CompanyC: [{object1}, {object2} etc.]
  }

Now each object inside the grouped array has properties including office, I can't get the results I need to sort the data by it so we have an ascending order.

I have tried below method but doesn't seem to work.

var srtData = _.sortBy(grpData , function (i) {
    $(i).each(function (i2, val) {
        return val.office;
    });
});

Anyone know a solution for this?

• javascript
• underscore.js

1 Answer 1

Why not sort and then group? Then the result will be a collection grouped by pany name each holding sorted array of objects (asc. by office name)

var grpData = _.groupBy(_.sortBy(emplData, "office"), 'pany');