Query for a field in an object in array with Mongo?

Question

Is it possible to use Mongo to query for entries that have a particular value in a field in an object in an array.

For example, let's say I want to find all objects where field1 has an array of objects, one of which has the field 'one' with a value of 1. This query should return the following object from my collection:

{_id: 0000, field1: [{one: 1, two: 2}, {one: 'uno', two: 'dos'}]}

Do you mean an array of documents?

Lucia Pasarin
– Lucia Pasarin

2013-06-12 21:04:26 +00:00
Commented Jun 12, 2013 at 21:04 — Lucia Pasarin
– Lucia Pasarin, Commented Jun 12, 2013 at 21:04
Well it's an array of JSON objects.

user1816679
– user1816679

2013-06-12 21:24:34 +00:00
Commented Jun 12, 2013 at 21:24 — user1816679
– user1816679, Commented Jun 12, 2013 at 21:24

Lucia Pasarin · Accepted Answer · 2013-06-12 21:30:15Z

36

I suppose what you need is:

db.collection.find( { field1: { $elemMatch: { one: 1 } } } );

http://docs.mongodb.org/manual/reference/operator/elemMatch/#op._S_elemMatch

answered Jun 12, 2013 at 21:30

Lucia Pasarin

2,3181 gold badge22 silver badges39 bronze badges

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

2 Comments

Jimmy Obonyo Abor Over a year ago

How about in a deep nested array

fIwJlxSzApHEZIl Over a year ago

what's the syntax for saving the result of this query in a javascript list?

JohnnyHK · Accepted Answer · 2019-07-07 15:13:39Z

7

This is an old question, but a simpler way to perform this query is to use dot notation:

db.collection.find({'field1.one': 1})

edited Jul 7, 2019 at 15:13

answered Jul 2, 2019 at 19:59

JohnnyHK

313k70 gold badges632 silver badges479 bronze badges

Collectives™ on Stack Overflow

Query for a field in an object in array with Mongo?

2 Answers 2

2 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related