在MongoDB上篩選日

我有一個名為“batches”的集合，其中包含帶有 ISODate 的“createdAt”欄位：

    {
    "_id" : ObjectId("5f6134ecf908840018f2e9ea"),
    "status" : "BATCH_PROCESSING",
    "groupId" : 13,
    "type" : "not",
    "finished" : false,
    "scheduledTo" : "2020-09-15T18:50:51-03:00",
    "identifier" : "COLABORADORES",
    "createdAt" : "2020-09-18T18:41:00-03:00",
    "__v" : 0
}

{
    "_id" : ObjectId("5f6144d7863bb40018045906"),
    "status" : "BATCH_PROCESSING",
    "groupId" : 13,
    "type" : "not",
    "finished" : false,
    "scheduledTo" : "2020-09-16T19:48:00-03:00",
    "identifier" : "COLABORADORES",
    "createdAt" : "2020-09-15T19:48:55-03:00",
    "__v" : 0
}

{
    "_id" : ObjectId("5f617021b985c1001974c3af"),
    "status" : "CANCELED",
    "groupId" : 13,
    "type" : "not",
    "finished" : true,
    "scheduledTo" : "2020-09-15T23:06:00-03:00",
    "identifier" : "COLABORADORES",
    "createdAt" : "2020-09-18T22:53:37-03:00",
    "__v" : 0,
    "numberOfLines" : 1
}

我只需要過濾特定日期的檔案。我嘗試了很多方法，但沒有帶來檔案：

db.getCollection("batches").find(
  { createdAt : {
    "$gte": ISODate("2020-09-15T00:00:00Z"), 
    "$lt": ISODate("2020-09-19T00:00:00Z") 
  } }
);

db.getCollection("batches").find({ createdAt : Date("2020-09-15")} 
);

查詢運行良好，但答案始終是：

在 136 毫秒內獲取 0 條記錄

如何正確執行此過濾器？

uj5u.com熱心網友回復：

您的資料格式不正確。您的欄位“createdDate”是一個字串，而不是 ISODate()。考慮這個...

db.batches.insertMany([
{
    "_id" : ObjectId("5f6134ecf908840018f2e9ea"),
    "status" : "BATCH_PROCESSING",
    "groupId" : 13,
    "type" : "not",
    "finished" : false,
    "scheduledTo" : "2020-09-15T18:50:51-03:00",
    "identifier" : "COLABORADORES",
    "createdAt" : ISODate("2020-09-18T18:41:00-03:00"),
    "__v" : 0
},
{
    "_id" : ObjectId("5f6144d7863bb40018045906"),
    "status" : "BATCH_PROCESSING",
    "groupId" : 13,
    "type" : "not",
    "finished" : false,
    "scheduledTo" : "2020-09-16T19:48:00-03:00",
    "identifier" : "COLABORADORES",
    "createdAt" : ISODate("2020-09-15T19:48:55-03:00"),
    "__v" : 0
},
{
    "_id" : ObjectId("5f617021b985c1001974c3af"),
    "status" : "CANCELED",
    "groupId" : 13,
    "type" : "not",
    "finished" : true,
    "scheduledTo" : "2020-09-15T23:06:00-03:00",
    "identifier" : "COLABORADORES",
    "createdAt" : ISODate("2020-09-18T22:53:37-03:00"),
    "__v" : 0,
    "numberOfLines" : 1
}]
)

詢問

在您的帖子中應用查詢時...

db.getCollection("batches").find(
  { createdAt : {
    "$gte": ISODate("2020-09-15T00:00:00Z"), 
    "$lt": ISODate("2020-09-19T00:00:00Z") 
  } })

...我們現在看到以下結果：

MongoDB Enterprise replSet:PRIMARY> db.getCollection("batches").find(
...   { createdAt : {
...     "$gte": ISODate("2020-09-15T00:00:00Z"), 
...     "$lt": ISODate("2020-09-19T00:00:00Z") 
...   } })
{ "_id" : ObjectId("5f6134ecf908840018f2e9ea"), "status" : "BATCH_PROCESSING", "groupId" : 13, "type" : "not", "finished" : false, "scheduledTo" : "2020-09-15T18:50:51-03:00", "identifier" : "COLABORADORES", "createdAt" : ISODate("2020-09-18T21:41:00Z"), "__v" : 0 }
{ "_id" : ObjectId("5f6144d7863bb40018045906"), "status" : "BATCH_PROCESSING", "groupId" : 13, "type" : "not", "finished" : false, "scheduledTo" : "2020-09-16T19:48:00-03:00", "identifier" : "COLABORADORES", "createdAt" : ISODate("2020-09-15T22:48:55Z"), "__v" : 0 }

標籤：mongodb mongodb查询

上一篇：對于模型“card”的路徑“_id”處的值“未定義”（型別字串），轉換為ObjectId失敗

下一篇：MongoDB在最后一個斜杠之前通過正則運算式更新