Query Your Data查询数据

The following filter returns documents where start_date is greater than than the BSON Date 2017-05-01:以下筛选器返回start_date大于BSONDate 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.通过在start_Date和$gt比较运算符中指定Date类型，Compass按时间顺序执行大于比较，返回start_Date晚于2017-05-01的文档。

Without the Date type specification, Compass compares the start_dates as strings lexicographically, instead of comparing the values chronologically.在没有Date类型规范的情况下，Compass按字典顺序将start_dates作为字符串进行比较，而不是按时间顺序比较值。

You have 3,235 articles. You would like to see all articles that Joe Bloggs wrote.你有3235篇文章。你想看看乔·布洛格斯写的所有文章。

Compass Filter OptionCompass筛选器选项

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

MongoDB AggregationMongoDB聚合

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. 以下示例使用下面的JSON文档作为示例数据。To import this sample data to your MongoDB deployment with MongoDB Compass:要使用MongoDB Compass将此示例数据导入到MongoDB部署中，请执行以下操作：

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"}
}
]

1. In Compass, use the left navigation panel to select the database and the collection you want to import the data to.在Compass中，使用左侧导航面板选择要将数据导入到的数据库和集合。
2. Click the Documents tab.单击“文档”选项卡。
3. Click Add Data and select Insert Document.单击“添加数据”，然后选择“插入文档”。
4. Ensure that View is set to JSON, or {}, and paste the copied JSON documents in the field.确保“视图”设置为JSON或{}，并将复制的JSON文档粘贴到字段中。
5. Click Insert.单击“插入”。