MongodB object array query

Question

I want to figure out how to search object array, which has label "작성" and value is "Y"
I made find query like this {"attrs.label": "작성" , "attrs.value": "Y"}
But the problem is {..., attrs: [{label: "작성", value: "N"}, {label: "Another", value: "Y"}]}
this document was matched with my query I need full match in one array element.

I tried

{ $and: [{"attrs.label": /작성/}, {"attrs.value": "Y"}]}

mickl · Accepted Answer · 2021-07-15 08:05:14Z

1

In such case you can use $elemMatch operator to indicate that at least one array item has to fullfill all the requirements:

db.collection.find({ attrs: { $elemMatch: { label: "작성", value: "Y" } } })

Mongo Playground

answered Jul 15, 2021 at 8:05

mickl

50.1k9 gold badges71 silver badges99 bronze badges

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

Collectives™ on Stack Overflow

MongodB object array query

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