Find with Array in a model with array Mongoose

Question

I need to create a query that searches within an array for occurrences of values that pass through an array.

It does not need to be an exact query, but it can bring me the occurrences

This is a part of my model

var OrdersCompaniesSchema = new Schema({
    target_studies: String,
    target_grade: String,
    interests : [String], // Contains for example ["Works","Sciences","Economy"]
    stock: Number
})

I tried the query like this

db.orderscompanies.find({"interests": { "$in": ["Works","Banks","Sports"] }})

But this query response me a blank array [] because this find the exactly values, and I dont need this. I need find any one ocurrence according the array with which I am consulting

Any help? Thanks!

Muthu Rg · Accepted Answer · 2017-01-30 02:19:19Z

2

According to the MongoDB docs here. It states that If the field holds an array, then the $in operator selects the documents whose field holds an array that contains at least one element that matches a value in the specified array. It doesn't try to match all occurrences as per your question.

It should work for you. If not, you should be doing some other mistake. If you can put more concrete code it'll help!

answered Jan 30, 2017 at 2:19

Muthu Rg

6621 gold badge7 silver badges18 bronze badges

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

Collectives™ on Stack Overflow

Find with Array in a model with array Mongoose

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related