Set Which Fields Are Returned

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 subset of the results. Otherwise, Compass shows the entire result set.

   For details on sampling, see Sampling.