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 Jun 12 '13 at 21:04 — Lucia Pasarin, Jun 12 '13 at 21:04
Well it's an array of JSON objects. – user1816679 Jun 12 '13 at 21:24 — user1816679, Jun 12 '13 at 21:24

score 36 · Accepted Answer · answered Jun 12 '13 at 21:30

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 '13 at 21:30

Lucia Pasarin

2,268
1
21
37

How about in a deep nested array – Jimmy Obonyo Abor Jan 17 '18 at 19:19
what's the syntax for saving the result of this query in a javascript list? – fIwJlxSzApHEZIl Mar 02 '18 at 17:41

JohnnyHK · Answer 2 · 2019-07-07T15:13:39.993

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 07 '19 at 15:13

answered Jul 02 '19 at 19:59

JohnnyHK

305,182
66
621
471

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

2 Answers2

Linked

Related