How to find data based on sub-field name in MongoDB using Mongoose?

Question

There is a sub-field called 'name' in MongoDB Collection (User):

[
{
    "teacher": {
        "name": "Alex",
        "email": "[email protected]"
    },
    "waiter": {
        "name": "Feliks",
        "email": "[email protected]"
    },
    "pilot": [
    {
        "name": "Sam",
        "email": "[email protected]"
    },
    {
        "name": "alice",
        "email": "[email protected]"
    }
    ],
},
{
    "teacher": {
        "name": "max",
        "email": "[email protected]"
    },
    "waiter": {
        "name": "Sam",
        "email": "[email protected]"
    },
    "pilot": [
    {
        "name": "richard",
        "email": "[email protected]"
    },
    {
        "name": "alice",
        "email": "[email protected]"
    }
    ],
}
]

How can I find data based on the field 'name'. For example, when I'm looking for 'Sam', it should return me the all documents since 'Sam' is in "waiter" and "pilot" in first and second documents respectively.

I cannot do something like:

User.find({"teacher.name": "Sam", "waiter.name": "Sam", "pilot.name": "Sam" })

This will return me nothing as it is an AND logic. What I need is an OR logic.

see stackoverflow.com/questions/38274135/… and docs.mongodb.com/manual/reference/operator/query/or — Joe
– Joe, Commented Dec 16, 2021 at 6:42

niiir · Accepted Answer · 2021-12-16 06:55:07Z

1

You can use the $or operator. So the query should look like this:

User.find({ $or: [
                  { "teacher.name": "Sam" }, 
                  { "waiter.name": "Sam" }, 
                  { "pilot.name": "Sam" }
                 ] 
          });

Read here for me details.

answered Dec 16, 2021 at 6:55

niiir

3774 silver badges9 bronze badges

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

Collectives™ on Stack Overflow

How to find data based on sub-field name in MongoDB using Mongoose?

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