在MongoDB中的两个日期之间获取数据时获取空对象

Question

我正在尝试使用php卷曲来获取mongoDB数据。我的代码就像下面。

            curl_setopt_array($curl, array(
                CURLOPT_URL => $this->apiPath . $action,
                CURLOPT_RETURNTRANSFER => true,
                CURLOPT_ENCODING => '',
                CURLOPT_MAXREDIRS => 10,
                CURLOPT_TIMEOUT => 0,
                CURLOPT_FOLLOWLOCATION => true,
                CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
                CURLOPT_CUSTOMREQUEST => 'POST',
                CURLOPT_POSTFIELDS => '{
                                        "dataSource": "' . $this->dataSource . '",
                                        "database": "' . $this->database . '",
                                        "collection": "' . $this->collection . '",
                                        "filter": { 
                                            "type": { "$eq": "'.$query.'" }                                            
                                        }
                                    }',
                CURLOPT_HTTPHEADER => array(
                    'Content-Type: application/json',
                    'Access-Control-Request-Headers: *',
                    'api-key: ' . $this->apiKey,
                ),
            ));
            $mongodata = json_decode(curl_exec($curl));

我会像下面的

stdClass Object
(
    [documents] => Array
    (
        [0] => stdClass Object
        (
            [_id] => 6253c5fc22d6ee83815a111a
            [lang] => Bangla
            [type] => top
            [createdAt] => 2022-04-11T00:08:54Z
            [searchTerm] => key
            [customerId] => 747498
            [wpId] => 20
            [results] => stdClass Object
                (
                    [parts] => 0
                    [pages] => 0
                    [productCategory] => 0
                )

        )
    )
)

一样获得输出

curl_setopt_array($curl, array(
                CURLOPT_URL => $this->apiPath . $action,
                CURLOPT_RETURNTRANSFER => true,
                CURLOPT_ENCODING => '',
                CURLOPT_MAXREDIRS => 10,
                CURLOPT_TIMEOUT => 0,
                CURLOPT_FOLLOWLOCATION => true,
                CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
                CURLOPT_CUSTOMREQUEST => 'POST',
                CURLOPT_POSTFIELDS => '{
                                        "dataSource": "' . $this->dataSource . '",
                                        "database": "' . $this->database . '",
                                        "collection": "' . $this->collection . '",
                                        "filter": { 
                                            "type": { "$eq": "'.$query.'" },
                                            "createdOn": {
                                                "$gte": "2022-04-11T00:08:54Z",
                                                "$lt": "2022-04-11T00:08:54Z"
                                            } 
                                        }
                                    }',
                CURLOPT_HTTPHEADER => array(
                    'Content-Type: application/json',
                    'Access-Control-Request-Headers: *',
                    'api-key: ' . $this->apiKey,
                ),
            ));
            $mongodata = json_decode(curl_exec($curl));

输出

stdClass Object
(
    [documents] => Array
        (
        )

)

Answer 1

没有逻辑的文档集可以符合此条件，因为其createon应该是 都大于或等于x，而小于x。
此查询将始终返回一个空集：

db.collection.find({
  createdOn: {
    $gte: ISODate("2022-04-11T00:08:54Z"),
    $lt: ISODate("2022-04-11T00:08:54Z")
  }
})

即使为此文档：

  {
    createdOn: ISODate("2022-04-11T00:08:54Z"),
    a: 2
  }

在 mongodb Playground 上检查它。