MongoDb: query on array field

Question

I've this object on reference collection:

> db.reference.find().pretty();
{
    "_id" : "Ref1",
    "metadata" : {
        "values" : [
            {
                "hola" : "adeu"
            },
            {
                "departament" : [
                    {
                        "ambit" : "just",
                        "name" : "ts"
                    }
                ]
            }
        ]
    },
    "timestamp" : ISODate("2018-09-22T08:37:08.989Z"),
    "_class" : "com.Reference"
}

I need to get document where metadata.values has an object {hola: "adeu"}.

I've tried without any luck:

> db.reference.find({metadata: {values: {hola: "adeu"}}});
> db.reference.find({metadata: {values: [{hola: "adeu"}]}});

Any ideas?

Try with db.reference.find({metadata: {values: { $elemMatch: {hola: "adeu"}}}}); — vitomadio
– vitomadio, Commented Sep 22, 2018 at 10:04
You can try : db.getCollection('reference').find({"metadata.values.hola" : "adeu"});, Also This lik help you with aggregate : stackoverflow.com/questions/52404430/… — IftekharDani
– IftekharDani, Commented Sep 22, 2018 at 12:44

Ankit · Accepted Answer · 2018-09-22 11:17:02Z

1

You can do something like this:

db.getCollection('reference').find({"metadata.values" : { "$in" : [{"hola" : "adeu"}] }});

You can also do an elemMatch like this, when you want it for a single object:

db.getCollection('reference').find({"metadata.values" : { "$elemMatch" : {"hola" : "adeu"} }})

answered Sep 22, 2018 at 11:17

Ankit

9906 silver badges12 bronze badges

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

Collectives™ on Stack Overflow

MongoDb: query on array field

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related