How to find a record by unique value inside an array in MongoDB?

Question

I want to locate a record which has the "String to match" in his "affiliates.wallets" array. But for some reason, I'm unable to do it.

I was trying something like:

db.collection.findOne({ "affiliates.wallets": {$in: "[String to match]"}, (err, data) => console.log(err, data)})

But it returns null. So, I'm asking for help.

Simplified Wallet Schema:

Wallet {
  affiliates: {
    wallets: [String]
  }
}

P.S: I'm using findOne method because this "String to match" which I'm using to locate the record is unique and it can be located only in one record.

this seems to work: mongoplayground.net/p/CGYgABvHXsm

R2D2
– R2D2

2022-02-07 19:19:10 +00:00
Commented Feb 7, 2022 at 19:19 — R2D2
– R2D2, Commented Feb 7, 2022 at 19:19

NeNaD · Accepted Answer · 2022-02-07 19:20:44Z

1

You don't need $in operator. You can do it like this:

db.collection.findOne({
  "affiliates.wallets": "String to match", 
}, (err, data) => {
  console.log(err, data)
})

answered Feb 7, 2022 at 19:20

NeNaD

20.9k11 gold badges65 silver badges119 bronze badges

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

Collectives™ on Stack Overflow

How to find a record by unique value inside an array in MongoDB?

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