Query Your Data

The following filter returns documents where start_date is greater than than the BSON Date 2017-05-01:

{ "start_date": {$gt: new Date('2017-05-01')} }

By specifying the Date type in both start_date and the $gt comparison operator, Compass performs the greater than comparison chronologically, returning documents with start_date later than 2017-05-01.

Without the Date type specification, Compass compares the start_dates as strings lexicographically, instead of comparing the values chronologically.

You have 3,235 articles. You would like to see all articles that Joe Bloggs wrote.

Compass Filter Option

{ author : { $eq : "Joe Bloggs" } }

MongoDB Aggregation

db.article.aggregate(
  { $filter : { author : { $eq : "Joe Bloggs" } } }
);

SQL

SELECT * FROM article
WHERE author = "Joe Bloggs";

The following examples use the JSON documents below as sample data. To import this sample data to your MongoDB deployment with MongoDB Compass:

1. Copy the array of documents below by clicking Copy.

[
   {
      "name":"Andrea Le",
      "email":"andrea_le@fakegmail.com",
      "version":5,
      "scores":[85, 95, 75],
      "dateCreated":{"$date":"2003-03-26"}
   },
   {
      "email":"no_name@fakegmail.com",
      "version":4,
      "scores":[90, 90, 70],
      "dateCreated":{"$date":"2001-04-15"}
   },
   {
      "name":"Greg Powell",
      "email":"greg_powell@fakegmail.com",
      "version":1,
      "scores":[65, 75, 80],
      "dateCreated":{"$date":"1999-02-10"}
   }
]

2. In Compass, use the left navigation panel to select the database and the collection you want to import the data to.

3. Click the Documents tab.

4. Click Add Data and select Insert Document.

5. Ensure that View is set to JSON, or {}, and paste the copied JSON documents in the field.

6. Click Insert.