How to query a document in mongodb comparing fields from an array?

Question

if i have this collection:

db.createCollection("misMensajes", {max: 100});

And documents with this distribution:

    db.misMensajes.insert(
    {
    "FechaEnvío": new Date("2015-06-22"),
    "Texto": "bla",
    "Destinatarios":[
        {
            "Nombre": "Pepa",
            "Edad": 15,
            "Apodo": "P"
        },
        {
            "Nombre": "Juan",
            "Edad": 16,
            "Apodo": "J"
        }
    ]
    }
);

What i want to do is a query to get the documents that have for "Destinatarios" "Edad" greater than 15 and less than 18. I don't know how to query "inside" the array "Destinatarios". I am starting in mongo and I don't understand many things. What I have until now is:

db.misMensajes.find({
    $and:[
        {Edad:{$gt:15}},
        {Edad:{$lt:18}}
    ]
});

But this is not giving me what I need.

Dani · Accepted Answer · 2016-06-06 12:50:40Z

2

To query inside an array, you need to use the dot notation for the field name, Destinatarios.Edad in this case:

db.misMensajes.find({
    $and: [
        { 'Destinatarios.Edad': { $gt: 15 } },
        { 'Destinatarios.Edad': { $lt: 18 } }
    ]
})

Also note that you don't need $and in this case:

db.misMensajes.find({
    'Destinatarios.Edad': { $gt: 15, $lt: 18 }
})

For more complex queries, you might need to use the $elemMatch operator.

answered Jun 6, 2016 at 12:50

Dani

14.2k4 gold badges24 silver badges24 bronze badges

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

Comments

notionquest · Accepted Answer · 2016-06-06 12:44:37Z

0

Please use $elemMatch. Here is the query.

db.misMensajes.find( { Destinatarios: { $elemMatch: { $and:[ {Edad:{$gt:15}}, {Edad:{$lt:18}} ] } } } );

answered Jun 6, 2016 at 12:44

notionquest

39.4k6 gold badges120 silver badges111 bronze badges

Comments

Shrabanee · Accepted Answer · 2016-06-06 13:07:37Z

0

Refer the find-doc to have a better understanding on how to use find query based on fields of an array.

To do find based on greater than and less than (as per your requirement) value, use $gt and $lt of mongodb.

So your can use as below :-

db.misMensajes.find({
$and: [
    { 'Destinatarios.Edad': { $gt: 15 } },
    { 'Destinatarios.Edad': { $lt: 18 } }
]
}).toArray(function(err, result)
   {
       console.log(results); //results will be an array of objects, containing all the records, which matches the query
    }

NOTE:- The above query will return the parent record, which matches the condition.

Destinatarios will have all the objects, not only the objects that matches the query.

If you want to get specific objects of Destinatarios array, you have to use aggregate.

answered Jun 6, 2016 at 13:07

Shrabanee

2,7861 gold badge21 silver badges32 bronze badges

2 Comments

thefuentescore Over a year ago

Thak you! it really helps!

Shrabanee Over a year ago

Glad it helped you.

Collectives™ on Stack Overflow

How to query a document in mongodb comparing fields from an array?

3 Answers 3

Comments

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related