Mongo complex sorting?

by

UPDATE: This answer appears to be out of date; it seems that custom sorting can be more or less achieved by using the $project function of the aggregation pipeline to transform the input documents prior to sorting. See also @Ari’s answer.

I don’t think this is possible directly; the sort documentation certainly doesn’t mention any way to provide a custom compare function.

You’re probably best off doing the sort in the client, but if you’re really determined to do it on the server you might be able to use db.eval() to arrange to run the sort on the server (if your client supports it).

Server-side sort:

db.eval(function() { 
  return db.scratch.find().toArray().sort(function(doc1, doc2) { 
    return doc1.a - doc2.a 
  }) 
});

Versus the equivalent client-side sort:

db.scratch.find().toArray().sort(function(doc1, doc2) { 
  return doc1.a - doc2.b 
});

Note that it’s also possible to sort via an aggregation pipeline and by the $orderby operator (i.e. in addition to .sort()) however neither of these ways lets you provide a custom sort function either.

More Related Contents:

  1. MEAN app vs. Mongo service local in Angular2
  2. Find objects between two dates MongoDB
  3. How to update the _id of one MongoDB Document?
  4. MongoDB: count the number of items in an array
  5. How to remove a field completely from a MongoDB document?
  6. How to Model a “likes” voting system with MongoDB
  7. Understanding MongoDB BSON Document size limit
  8. MongoDB – admin user not authorized
  9. How can I run MongoDB as a Windows service?
  10. Overflow sort stage buffered data usage exceeds internal limit
  11. Slow pagination over tons of records in mongodb
  12. MongoDB – paging
  13. MongoDB query with an ‘or’ condition
  14. MongoDB: How to query for records where field is null or not set?
  15. exclude fields in $lookup aggregation
  16. Mongo how to $lookup with DBRef
  17. Add some kind of row number to a mongodb aggregate command / pipeline
  18. How to enforce foreign keys in NoSql databases (MongoDB)?
  19. How do you query for “is not null” in Mongo?
  20. MongoDB: exception in initAndListen: 20 Attempted to create a lock file on a read-only directory: /data/db, terminating
  21. MongoDB ‘unable to find index for $geoNear query’
  22. MongoDB sort documents by array elements
  23. MongoDB won’t start after server crash
  24. How does sorting with an index work in MongoDB?
  25. How to use dot in field name?
  26. How to get multiple document using array of MongoDb id?
  27. Docker: change folder where to store docker volumes
  28. How to organise a many to many relationship in MongoDB
  29. MongoDB on Ubuntu won’t start as a service, nothing in the log
  30. Query for a field in an object in array with Mongo?

Leave a Comment