Complex query of MongoDB

Question

I have looked up the manual of MongoDB, but cannot find a proper solution to do the following search:

Document structure:

{
    "_id" : ObjectId("57201082e92c07baef62452a"),
    "user_id" : 1,
    "profile" : [ 
        {
            "date" : ISODate("2012-10-11T12:58:06.000Z"),
            "content" : [ 
                {
                    "feature_id" : 1,
                    "feature_value" : true
                }
            ]
        },
        {
            "date" : ISODate("2013-04-12T8:23:09.000Z"),
            "content" : [ 
                {
                    "feature_id" : 1,
                    "feature_value" : false
                }
            ]
        }
    ]
}

What I want to get is the LATEST feature_value of a given user_id and a given feature_id.

Is there any way to accomplish this using MongoDB?

Thanks.

Do you mean the last element in the "profile" array?

Sede
– Sede

2016-04-27 07:13:27 +00:00
Commented Apr 27, 2016 at 7:13 — Sede
– Sede, Commented Apr 27, 2016 at 7:13

achuth · Accepted Answer · 2016-04-27 04:55:43Z

1

Assuming the latest(as profile.date) you can use the following to get the desired result.(query not tested, hope it works).

db.test.aggregate(
[
  {$match : {"user_id" : 1}},
  {$unwind : "$profile"},
  {$unwind : "$profile.content"},
  {$match : {"profile.content.feature_id" : 1}},
  {$sort : {"profile.date" : -1}},
  {$limit : 1},
  {$group:{_id : "$_id", content : {$push:"$profile.content"}}}
 ])

answered Apr 27, 2016 at 4:55

achuth

1,2222 gold badges16 silver badges30 bronze badges

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

Comments

Andrei · Accepted Answer · 2016-04-27 11:46:05Z

0

Please try this:

db.test.aggregate(
{$match:{"user_id" :1,"profile.content.feature_id":1}},
{$project:{"profile.content.feature_value":1}},
{$sort:{"profile.date" :-1}},
{$limit : 1});

edited Apr 27, 2016 at 11:46

Andrei

44.9k39 gold badges163 silver badges228 bronze badges

answered Apr 27, 2016 at 6:59

Shantanu Madane

6155 silver badges15 bronze badges

Collectives™ on Stack Overflow

Complex query of MongoDB

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related