Mongoose : search in an array

Question

I have this schema:

new mongoose.Schema({
    providers : [{
            provider: { type: String, required: true },
            data : { type : String, unique: true }
        }]
});

For instance, an item can be :

providers: [{provider: "linkedin", data: "abcd"},
            {provider: "twitter", data: "efgh"}]

What I would like to search in Mongoose: provider == "linkedin" and data = "abcd".

Do you know how to achieve this?

JohnnyHK · Accepted Answer · 2015-05-12 17:26:28Z

5

Use $elemMatch to match multiple fields in the same element:

Model.find({providers: {$elemMatch: {provider: 'linkedin', data: 'abcd'}}})

The following would also work, but is more brittle as it would require an exact match of the element, with no extra fields and with the two fields in the same order.

Model.find({providers: {provider: 'linkedin', data: 'abcd'}})

edited May 12, 2015 at 17:26

answered May 12, 2015 at 17:12

JohnnyHK

313k70 gold badges632 silver badges479 bronze badges

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

3 Comments

Sylvain Leroux Over a year ago

What's the advantage of using $elemMatch here instead of db.w.find({providers:{provider:"linkedin", data:"abcd"}}) ?

JohnnyHK Over a year ago

@SylvainLeroux That would work, but is more brittle as it would require an exact match of the element, with no extra fields and with the two fields in the same order.

Sylvain Leroux Over a year ago

Thank you for clarifying that. I was looking at the doc right now and just noticed that I've forgot about those limitations. Maybe worth mentioning that in your answer ?

Collectives™ on Stack Overflow

Mongoose : search in an array

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related