Project Fields to Return from Query

Return All Fields in Matching Documents

The following example returns all fields from all documents in the inventory collection where the status equals "A":

The operation corresponds to the following SQL statement:

SELECT * from inventory WHERE status = "A"

Return the Specified Fields and the _id Field Only

A projection can explicitly include several fields by setting the <field> to 1 in the projection document. The following operation returns all documents that match the query. In the result set, only the item, status and, by default, the _id fields return in the matching documents.

The operation corresponds to the following SQL statement:

SELECT _id, item, status from inventory WHERE status = "A"

Suppress _id Field

You can remove the _id field from the results by setting it to 0 in the projection, as in the following example:

The operation corresponds to the following SQL statement:

SELECT item, status from inventory WHERE status = "A"

Return All But the Excluded Fields

Instead of listing the fields to return in the matching document, you can use a projection to exclude specific fields. The following example which returns all fields except for the status and the instock fields in the matching documents:

Return Specific Fields in Embedded Documents

You can return specific fields in an embedded document. Use the dot notation to refer to the embedded field and set to 1 in the projection document.

The following example returns:

• The _id field (returned by default),

• The item field,

• The status field,

• The uom field in the size document.

The uom field remains embedded in the size document.

Starting in MongoDB 4.4, you can also specify embedded fields using the nested form, e.g. { item: 1, status: 1, size: { uom: 1 } }.

Suppress Specific Fields in Embedded Documents

You can suppress specific fields in an embedded document. Use the dot notation to refer to the embedded field in the projection document and set to 0.

The following example specifies a projection to exclude the uom field inside the size document. All other fields are returned in the matching documents:

Starting in MongoDB 4.4, you can also specify embedded fields using the nested form, e.g. { size: { uom: 0 } }.

Projection on Embedded Documents in an Array

Use dot notation to project specific fields inside documents embedded in an array.

The following example specifies a projection to return:

• The _id field (returned by default),

• The item field,

• The status field,

• The qty field in the documents embedded in the instock array.

Project Specific Array Elements in the Returned Array

Additional Considerations

Starting in MongoDB 4.4, MongoDB enforces additional restrictions with regards to projections. See Projection Restrictions for details.