MongoDB sort documents by array elements

by

You cannot do that with arrays, and the main problem here is because you want the “sort” to happen on the matched element. If you want to sort results like this then you need to use .aggregate() instead. Either as:

For modern MongoDB versions:

db.maps.aggregate([
    { "$match": { "points.type": "type1" }},
    { "$addFields": {
        "order": {
            "$filter": {
              "input": "$points",
              "as": "p",
              "cond": { "$eq": [ "$$p.type", "type1" ] }
            }
        }
    }},
    { "$sort": { "order": 1 } }
])

For MongoDB 2.6 to 3.0

db.maps.aggregate([
   { $match: { 'points.type': 'type1' } },
    {
     $project: {
       points: {
        $setDifference: [
          {
            $map: {
              input: '$points',
              as: 'p',
              in: {
                $cond: [
                  { $eq: ['$$p.type', 'type1'] },
                  '$$p',
                  false,
                ]
              }
            }
          },
          [false]
        ]
      }
    }
  },
  { $sort: { 'points.distanceToSpawn': 1 } },
]);

Or less efficiently in versions prior to MongoDB 2.6:

db.maps.aggregate([
    { "$match": { "points.type": "type1" }},
    { "$unwind": "$points" },
    { "$match": { "points.type": "type1" }},
    { "$group": {
        "_id": "$_id",
        "points": { "$push": "$points" }
    }},
    { "$sort": { "points.ditanceToSpawn": 1 } }         
])

That’s the only way to match the correct elements and have them considered in a “sort” operation. The default cursor sort will just otherwise consider the values for the field in the array elements that do not match your selected “type” instead.

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. Return only matched sub-document elements within a nested array
  6. Converting string to date in mongodb
  7. Check if every element in array matches condition
  8. MongoDB nested lookup with 3 levels
  9. MongoDB Full and Partial Text Search
  10. Matching ObjectId to String for $graphLookup
  11. Mongodb Join on _id field from String to ObjectId
  12. Mongodb aggregation lookup with conditions
  13. How to get back the Original document back after aggregation
  14. Mongo sort on a calculated condition
  15. MongoDB lookup when foreign field is an array of objects
  16. MongoDB: Calculate dwell time between every status value change
  17. MongoDB: how to parse date in 3.6 mongoDb version?
  18. Search on multiple collections in MongoDB
  19. Using stored JavaScript functions in the Aggregation pipeline, MapReduce or runCommand
  20. MongoDB – The argument to $size must be an Array, but was of type: EOO / missing
  21. convert iso date to timestamp in mongo query
  22. Remove Duplicates from MongoDB
  23. Using $slice operator to get last element of array
  24. How to access overall document count during arithmetic aggregation expression
  25. How does MongoDB order their docs in one collection? [duplicate]
  26. count array occurrences across all documents with mongo
  27. Mongodb, aggregate query with $lookup
  28. mongodb aggregate query isn’t returning proper sum on using $sum
  29. Return the last “true” value for each group
  30. MongoDB aggregate within daily grouping [duplicate]

Leave a Comment