Mongo sort on a calculated condition

by

If you want to “weight” results by certain criteria or have any kind of “calculated value” within a “sort”, then you need the .aggregate() method instead. This allows “projected” values to be used in the $sort operation, for which only a present field in the document can be used:

db.messages.aggregate([
    { "$match": { "messages": userId } },
    { "$project": {
        "recipients": 1,
        "unread": 1,
        "content": 1,
        "readYet": {
            "$setIsSubset": [ [userId], "$unread" ] }
        }
    }},
    { "$sort": { "readYet": -1 } },
    { "$limit": 20 }
])

Here the $setIsSubset operator allows comparison of the “unread” array with a converted array of [userId] to see if there are any matches. The result will either be true where the userId exists or false where it does not.

This can then be passed to $sort, which orders the results with preference to the matches ( decending sort is true on top ), and finally $limit just returns the results up to the amount specified.

So in order to use a calulated term for “sort”, the value needs to be “projected” into the document so it can be sorted upon. The aggregation framework is how you do this.

Also note that $elemMatch is not required just to match a single value within an array, and you need only specify the value directly. It’s purpose is where “multiple” conditions need to be met on a single array element, which of course does not apply here.

More Related Contents:

  1. Retrieve only the queried element in an object array in MongoDB collection
  2. Update MongoDB field using value of another field
  3. Does MongoDB’s $in clause guarantee order
  4. $lookup on ObjectId’s in an array
  5. MongoDB: Combine data from multiple collections into one..how?
  6. Return only matched sub-document elements within a nested array
  7. Converting string to date in mongodb
  8. Check if every element in array matches condition
  9. MongoDB nested lookup with 3 levels
  10. MongoDB Full and Partial Text Search
  11. Matching ObjectId to String for $graphLookup
  12. Mongodb Join on _id field from String to ObjectId
  13. Mongodb aggregation lookup with conditions
  14. How to get back the Original document back after aggregation
  15. MongoDB sort documents by array elements
  16. MongoDB lookup when foreign field is an array of objects
  17. MongoDB: Calculate dwell time between every status value change
  18. MongoDB: how to parse date in 3.6 mongoDb version?
  19. Search on multiple collections in MongoDB
  20. Using stored JavaScript functions in the Aggregation pipeline, MapReduce or runCommand
  21. MongoDB – The argument to $size must be an Array, but was of type: EOO / missing
  22. convert iso date to timestamp in mongo query
  23. Remove Duplicates from MongoDB
  24. Using $slice operator to get last element of array
  25. How to access overall document count during arithmetic aggregation expression
  26. Mongodb aggregation pipeline how to limit a group push
  27. count array occurrences across all documents with mongo
  28. $project in $lookup mongodb
  29. Mongodb concat int and string
  30. Return actual type of a field in MongoDB

Leave a Comment