Sorting an Array of Objects by two Properties

by

Presuming the timestamps themselves sort ok (e.g. ISO8601 and same time zone), try:

myArray.sort(function(a,b) {
  var x = a.RemindingTimestamp - b.RemindingTimestamp;
  return x == 0? a.ModificationTimestamp - b.ModificationTimestamp : x;
}

Edit – response to comments

A descending sort is achieved by changing the order of subtraction, or multiplying the result by -1. Dates that don’t sort because they don’t subtract (e.g. 2012-04-12) can be handled by conversion to dates first, e.g.

// Convert ISO8601 date string to date object
// Assuming date is ISO8601 long format, ignores timezone
function toDate(s) {
  var bits = s.split(/[-T :]/);
  var d = new Date(bits[0], bits[1]-1, bits[2]);
  d.setHours(bits[3], bits[4], parseFloat(bits[5])); 
  return d;
}

// Source data, should end up sorted per n
var myArray = [ 
  {RemindingTimestamp: '2012-04-15T23:15:12Z', 
   ModificationTimestamp: '2012-04-15T23:15:12Z', n: 4},
  {RemindingTimestamp: '2012-04-12T23:15:12Z', 
   ModificationTimestamp: '2012-04-12T23:15:12Z', n: 1},
  {RemindingTimestamp: '2012-04-12T23:15:12Z', 
   ModificationTimestamp: '2012-04-13T23:15:12Z', n: 2},
  {RemindingTimestamp: '2012-04-12T23:15:12Z', 
   ModificationTimestamp: '2012-04-13T23:15:14Z', n: 3}
];

// Sort it
myArray.sort(function(a,b) {
  var x = toDate(a.RemindingTimestamp) - toDate(b.RemindingTimestamp);
  return x? x : toDate(a.ModificationTimestamp) - toDate(b.ModificationTimestamp);
});

// Just to show the result
function sa(o) {
  var result = [], t;
  for (var i=0; i<o.length; i++) {
    t = o[i]; 
      result.push(t.n);
  }
  alert(result);
}

sa(myArray); // 1,2,3,4

The conversion of date string to date object can be extended to handle time zone if required (for ISO8601 compliant strings only, those that use time zone abbreviations instead of the actual offset are unreliable).

More Related Contents:

  1. consider a string which has question marks, numbers , letters [closed]
  2. Sorting object property by values
  3. How to sort an array of integers correctly
  4. Is it correct to use JavaScript Array.sort() method for shuffling?
  5. Sort Array Elements (string with numbers), natural sort
  6. How to compare software version number using js? (only number)
  7. Fast stable sorting algorithm implementation in javascript
  8. Sort mixed alpha/numeric array
  9. Sorting arrays numerically by object property value
  10. How do I sort an array of objects based on the ordering of another array?
  11. sort Javascript array by two numeric fields
  12. How can you sort an array without mutating the original array?
  13. Efficient way to insert a number into a sorted array of numbers?
  14. Sort an html list with javascript
  15. Count unique elements in array without sorting
  16. Does .sort function change original array?
  17. Remove duplicate objects from an array using javascript
  18. Sort version-dotted number strings in Javascript?
  19. sort json object in javascript
  20. Optimized merge sort faster than quicksort
  21. Populate nested object from array?
  22. Javascript – sorting array by multiple criteria
  23. 400x Sorting Speedup by Switching a.localeCompare(b) to (ab?1:0))
  24. Disable sorting for a particular column in jQuery DataTables
  25. Sort a Javascript Array by frequency and then filter repeats
  26. Sort a dictionary by value in JavaScript
  27. How to sort numbers? [duplicate]
  28. sorting object Sunday to Saturday in javascript
  29. Implement async/await in sort function of arrays javascript
  30. How to sort a JavaScript array of objects by nested object property?

Leave a Comment