মঙ্গোডিবি-তে সাবডকুমেন্টের শর্ত অনুসারে নথিগুলি কীভাবে জিজ্ঞাসা করবেন?

আসুন প্রথমে নথি-

> db.demo394.insertOne(
...    {
...
...       details: [
...       {
...          _id: '1',
...          startDate: '2018-01-11T07:00:00.000Z',
...          endDate: '2019-01-12T07:59:59.999Z'
...       },
...       {
...          _id: '2',
...          startDate: '2019-01-21T07:00:00.000Z',
...          endDate: '2020-01-04T07:59:59.999Z'
...       }
...    ]
... }
... );
{
   "acknowledged" : true,
   "insertedId" : ObjectId("5e5e716817aa3ef9ab8ab202")
}

Find() পদ্ধতি -

> db.demo394.find();

এটি নিম্নলিখিত আউটপুট −

{
   "_id" : ObjectId("5e5e716817aa3ef9ab8ab202"), "details" : [
      { "_id" : "1", "startDate" : "2018-01-11T07:00:00.000Z", "endDate" : "2019-01-12T07:59:59.999Z" },
      { "_id" : "2", "startDate" : "2019-01-21T07:00:00.000Z", "endDate" : "2020-01-04T07:59:59.999Z" }
   ]
}

সাবডকুমেন্ট −

> db.demo394.find({
...    $expr: {
...       $let: {
...          vars: { "d": { $arrayElemAt: [ "$details", -1 ] } },
...          in: { $eq: [ "$$d.endDate", "2020-01-04T07:59:59.999Z" ] }
...       }
...    }
... })

এটি নিম্নলিখিত আউটপুট −

{
   "_id" : ObjectId("5e5e716817aa3ef9ab8ab202"), "details" : [
      { "_id" : "1", "startDate" : "2018-01-11T07:00:00.000Z", "endDate" : "2019-01-12T07:59:59.999Z" },
      { "_id" : "2", "startDate" : "2019-01-21T07:00:00.000Z", "endDate" : "2020-01-04T07:59:59.999Z" }
   ] 
}