Docs Menu

Set Which Fields Are Returnedicons/link.png

If the query bar displays the Project option, you can specify which fields to return in the resulting data. By default, all fields are returned.

To set a projection:

  1. In the Query Bar, click Options.
  2. Enter the projection document into the Project field.

    To include fields:

    Specify the field name and set to 1 in the project document.

    Example
    { year: 1, name: 1 }

    Only the fields specified in the project document are returned. The _id field is returned unless it is set to 0 in the Project document.

    To exclude fields:

    Specify the field name and set to 0 in the project document.

    Example
    { year: 0, name: 0 }

    All fields except for the fields specified in the project document are returned.

    As you type, the Find button is disabled and the Project label turns red until a valid query is entered.

  3. Click Find to run the query and view the updated results.

    Note

    For query result sets larger than 1000 documents, Compass shows a sampling of the results. Otherwise, Compass shows the entire result set.

    For details on sampling, see Sampling.

To learn how project works, see the project entry in the MongoDB Manual.

$project corresponds to choosing specific fields to return in a SQL SELECT statement.

Example

You have 3,235 articles. You would like to see only the headlines and authors of those articles.

SQL
SELECT headline, author FROM article;
MongoDB Aggregation
db.article.aggregate(
{ $project : { headline : 1, author : 1 } }
);
Compass Project Option
{ headline : 1, author : 1 }
Give Feedback
MongoDB logo
© 2021 MongoDB, Inc.

About

  • Careers
  • Investor Relations
  • Legal Notices
  • Privacy Notices
  • Security Information
  • Trust Center
© 2021 MongoDB, Inc.