query find where element in array

Question

my documents "parents" got the folowing structure:

{childrenIdList: [23, 24, 34]}
{childrenIdList: [23, 88]}
{childrenIdList: [1, 5, 8]}

how to select parents by childId in there childrenIdList?

Such query must return first two documents of 3 in my example if childId = 23.

I tried to use elemMatch method, but seemingly it works only with objects, i.e. it would work only if my data would be {childrenIdList: [{Id: 1}, {Id: 5}, {Id: 8}]}

Gergo Erdosi · Accepted Answer · 2014-07-05 16:50:45Z

1

You can just use db.collection.find({childrenIdList: 23}). See the Query Arrays section in the manual for more details.

answered Jul 5, 2014 at 16:50

Gergo Erdosi

42.3k21 gold badges122 silver badges95 bronze badges

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

Comments

Loourr · Accepted Answer · 2014-07-05 16:53:39Z

0

db.collection.find({"parent.childrenIdList": {$in: [23]}})

answered Jul 5, 2014 at 16:53

Loourr

5,12510 gold badges46 silver badges69 bronze badges

1 Comment

Austin Mullins Over a year ago

Can you expand this answer to explain why this works?

Collectives™ on Stack Overflow

query find where element in array

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related