Mongo order by length of array

by

I thought you might be able to use $size, but that’s only to find arrays of a certain size, not ordering.

From the mongo documentation:
http://www.mongodb.org/display/DOCS/Advanced+Queries#AdvancedQueries-%24size

You cannot use $size to find a range of sizes (for example: arrays with more than 1 element). If you need to query for a range, create an extra size field that you increment when you add elements. Indexes cannot be used for the $size portion of a query, although if other query expressions are included indexes may be used to search for matches on that portion of the query expression.

Looks like you can probably fairly easily do this with the new aggregation framework, edit: which isn’t out yet.
http://www.mongodb.org/display/DOCS/Aggregation+Framework

Update Now the Aggregation Framework is out…

> db.test.aggregate([
  {$unwind: "$answers"}, 
  {$group: {_id:"$_id", answers: {$push:"$answers"}, size: {$sum:1}}}, 
  {$sort:{size:1}}]);
{
"result" : [
    {
        "_id" : ObjectId("5053b4547d820880c3469365"),
        "answers" : [
            {
                "content" : "answer1"
            },
            {
                "content" : "2nd answer"
            }
        ],
        "size" : 2
    },
    {
        "_id" : ObjectId("5053b46d7d820880c3469366"),
        "answers" : [
            {
                "content" : "answer1"
            },
            {
                "content" : "2nd answer"
            },
            {
                "content" : "The third answer"
            }
        ],
        "size" : 3
    }
  ],
  "ok" : 1
}

More Related Contents:

  1. Does MongoDB’s $in clause guarantee order
  2. Find document with array that contains a specific value
  3. Update field in exact element array in MongoDB
  4. Authentication failure while trying to save to mongodb
  5. How to change the type of a field?
  6. MongoDB logging all queries
  7. Return only matched sub-document elements within a nested array
  8. Querying internal array size in MongoDB
  9. How to delete N numbers of documents in mongodb
  10. Find duplicate records in MongoDB
  11. How to return Mongoose results from the find method?
  12. How do I start Mongo DB from Windows?
  13. MongoDB: Calculate dwell time between every status value change
  14. How to ignore nulls while unmarshalling a MongoDB document?
  15. How to use mongoimport to import CSV files?
  16. Mongodb query specific month|year not date
  17. Remove Duplicates from MongoDB
  18. Spring data MongoDb: MappingMongoConverter remove _class
  19. How to find min value in mongodb
  20. Does MongoDB support floating point types?
  21. How to delete documents by query efficiently in mongo?
  22. Sum in nested document MongoDB
  23. Update embedded object inside array inside array in MongoDB
  24. How to check if an array field contains a unique value or another array in MongoDB?
  25. MongoDB.service failed with result exit-code
  26. How can I sort a Meteor collection by time of insertion?
  27. MongoDB index/RAM relationship
  28. Export mongodb aggregation framework result to a new collection
  29. MongoDB aggregate by field exists
  30. MongoDB {aggregation $match} vs {find} speed

Leave a Comment