Running Queries in MongoDB Compass

Create a Filter Query

Write a query in MongoDB Compass to find all documents where the status field is 'active'.

Expected output: Documents with status equal to 'active' are displayed.

Hint: Use the filter syntax: { status: 'active' }

Project Specific Fields

Modify your query to return only the 'name' and 'email' fields.

Expected output: Query results show only the name and email fields.

Hint: Use projection: { name: 1, email: 1 }

Sort Results by Date

Sort the query results by the 'createdAt' field in ascending order.

Expected output: Documents are ordered by creation date from oldest to newest.

Hint: Use sort: { createdAt: 1 }

You filter documents by entering a query in the Filter box using MongoDB query syntax, such as { age: 25 } to find documents where age equals 25.

Projection specifies which fields to include or exclude in the query results, allowing you to retrieve only the necessary data.

You sort results by entering a JSON object in the Sort box with field names and sort directions, for example, { age: -1 } to sort by age descending.