Mongoose, Matching a field of string array type with a given string array

Question

Suppose there is a Schema and there is a field

 phoneNumber:{
    type:[String],
    required:true
},

now i want to compare this column with an array , example ["ABC","DEF"]. How can i check if any element in this array matches with an element in a document

Like if there are documents A =  { phoneNumber :["ACD, "BFG"]} and B= {phoneNumber:["GCD"]}

The query should return the B document if i check using C= ["GCD"], as B is the only document that contains "GCD" element. I did try to use myDoc.find({phoneNumber:{$in:["GCD"]}) but it isnt returning anything. What is the correct query which is to be used

Your question is not clear to me. Please format your post and clearly show each document separately and data in each document. — palaѕн
– palaѕн, Commented May 28, 2020 at 13:26

Nevus · Accepted Answer · 2021-01-03 16:34:00Z

2

Use $in:

db.collection.find({"phoneNumber.type": { $in: ["ACD", "BFG"] } })

edited Jan 3, 2021 at 16:34

Nevus

1,4361 gold badge12 silver badges22 bronze badges

answered May 28, 2020 at 13:28

Tom Slabbaert

22.5k10 gold badges34 silver badges45 bronze badges

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

Collectives™ on Stack Overflow

Mongoose, Matching a field of string array type with a given string array

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