Query on Embedded/Nested Documents
➤ Use the Select your language drop-down menu in the upper-right to set the language of the following examples.
Match an Embedded/Nested Document
For example, the following query selects all documents where the field
size equals the document { h: 14, w: 21, uom: "cm" }:
Equality matches on the whole embedded document require an exact
match of the specified <value> document, including the field order.
For example, the following query does not match any documents in the
inventory collection:
Query on Nested Field
To specify a query condition on fields in an embedded/nested document,
use dot notation ("field.nestedField").
Note
When querying using dot notation, the field and nested field must be inside quotation marks.
Specify Equality Match on a Nested Field
The following example selects all documents where the field uom
nested in the size field equals "in":
Specify Match using Query Operator
The following query uses the less than operator ($lt) on
the field h embedded in the size field:
Specify AND Condition
The following query selects all documents where the nested field h
is less than 15, the nested field uom equals "in", and the
status field equals "D":
Additional Query Tutorials
For additional query examples, see: