Sort data in sub array in mongodb

Question

Is that possible to sort data in sub array in mongo database?

{   "_id" : ObjectId("4e3f8c7de7c7914b87d2e0eb"), 
    "list" : [
            {
                "id" : ObjectId("4e3f8d0be62883f70c00031c"),
                "datetime" : 1312787723,
                "comments" : 
                    {
                        "id" : ObjectId("4e3f8d0be62883f70c00031d")
                        "datetime": 1312787723,
                    },
                    {
                        "id" : ObjectId("4e3f8d0be62883f70c00031d")
                        "datetime": 1312787724,
                    },                  
                    {
                        "id" : ObjectId("4e3f8d0be62883f70c00031d")
                        "datetime": 1312787725,
                    },
            }
        ], 
    "user_id" : "3" }

For example I want to sort comments by field "datetime". Thanks. Or only variant is to select all data and sort it in PHP code, but my query works with limit from mongo...

user699082 · Accepted Answer · 2011-08-23 19:06:21Z

2

With MongoDB, you can sort the documents or select only some parts of the documents, but you can't modify the documents returned by a search query.

If the current order of your comments can be changed, then the best solution would be to sort them in the MongoDB documents (find(), then for each doc, sort its comments and update()). If you want to keep the current internal order of comments, then you'll have to sort each document after each query.

In both case, the sort will be done with PHP. Something like:

foreach ($doc['list'] as $list) {
    // uses a lambda function, PHP 5.3 required
    usort($list['comments'], function($a,$b){ return $a["datetime"] < $b["datetime"] ? -1 : 1; });
}

If you can't use PHP 5.3, replace the lambda function by a normal one. See usort() examples.

answered Aug 23, 2011 at 19:06

user699082

Sign up to request clarification or add additional context in comments.

2 Comments

Yaroslav Boichuk Over a year ago

thx, I have done like that, but I think can do it with mongo, but Thx for reply;)

Shane Stillwell Over a year ago

If you have a solution, it would be nice to share it with the rest of us.

Collectives™ on Stack Overflow

Sort data in sub array in mongodb

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related