- Reference >
- Operators >
- Query and Projection Operators >
- Projection Operators >
- $ (projection)
$ (projection)¶
On this page
Definition¶
-
$
¶ The positional
$
operator limits the contents of an<array>
from the query results to contain only the first element matching the query document. To specify an array element to update, see the positional $ operator for updates.Use
$
in the projection document of thefind()
method or thefindOne()
method when you only need one particular array element in selected documents.
Usage Considerations¶
Both the $
operator and the $elemMatch
operator project
a subset of elements from an array based on a condition.
The $
operator projects the array elements based on some condition
from the query statement.
The $elemMatch
projection operator takes an explicit condition
argument. This allows you to project based on a condition not in the query, or
if you need to project based on multiple fields in the array’s subdocuments.
See Array Field Limitations for an example.
Behavior¶
Usage Requirements¶
Given the form:
The <array>
field being limited must appear in the query document, and the <value>
can be documents
that contain query operator expressions.
Array Field Limitations¶
MongoDB requires the following when dealing with projection over arrays:
- Only one positional
$
operator may appear in the projection document. - Only one array field may appear in the query document.
- The query document should only contain a single condition on the array field being projected. Multiple conditions may override each other internally and lead to undefined behavior.
Under these requirements, the following query is incorrect:
To specify criteria on multiple fields of documents inside that array, use the
$elemMatch
query operator. The following query will return any
subdocuments inside a grades
array that have a mean
of greater than 70
and a grade
of greater than 90.
You must use the $elemMatch
operator if you need separate conditions
for selecting documents and for choosing fields within those documents.
Sorts and the Positional Operator¶
When the find()
method includes a
sort()
, the find()
method applies the sort()
to order the matching
documents before it applies the positional $
projection operator.
If an array field contains multiple documents with the same field
name and the find()
method includes a
sort()
on that repeating field, the returned
documents may not reflect the sort order because the sort was
applied to the elements of the array before the $
projection operator.
Examples¶
Project Array Values¶
A collection students
contains the following documents:
In the following query, the projection { "grades.$": 1 }
returns only the first element greater than or equal to 85
for the grades
field.
The operation returns the following documents:
Although the array field grades
may contain multiple elements
that are greater than or equal to 85
, the $
projection operator returns only the first matching element from the
array.
Project Array Documents¶
A students
collection contains the following documents
where the grades
field is an array of documents; each document
contain the three field names grade
, mean
, and std
:
In the following query, the projection { "grades.$": 1 }
returns only the first element with the mean
greater
than 70
for the grades
field:
The operation returns the following documents: