saravanapriyanm/Filter by week.md

Last active August 1, 2023 13:29

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/saravanapriyanm/b6b70773aac9de16e49aa5986d0205b0.js"></script>
Save saravanapriyanm/b6b70773aac9de16e49aa5986d0205b0 to your computer and use it in GitHub Desktop.

Download ZIP

MongoDB

Raw

Filter by week.md

$match: { $expr: {$eq: [{$week: "$Document.data.DATE"}, 27]} }

Raw

Find records within date.md

$match: { "Document.data.DATE": { $gte: ISODate('2023/07/04'), $lt: ISODate('2023/07/05'), } }

Raw

Get available types of a field.md

    [
  {
    $match: {
      FormId: "f80e8870-ba52-4638-857d-039f4ee6a9c8",
      IsLatestApproved: true,
    },
  },
  {
    $project: {
        fieldType: {
          $type: "$Document.data.DATE",
        },
      },
  },
  {
    $group: {
        _id: "$fieldType",
        v: { $sum: 1 },
      },
  },
]


  

Raw

Get Latest Nth Date Record.md

[ { $match: { FormId: "f80e8870-ba52-4638-857d-039f4ee6a9c8", IsLatestApproved: true, }, }, { $sort: { "Document.data.DATE": -1 }, }, { $group: { _id: { year: {$year:"$Document.data.DATE"}, month: {$month:"$Document.data.DATE"}, day: {$dayOfMonth:"$Document.data.DATE"} } } }, { $skip:2 }, { $limit: 1 } ]

Raw

Get Latest Nth Date.md

Raw

Get latest record by field.md

[ { $match: { FormId: "f80e8870-ba52-4638-857d-039f4ee6a9c8", IsLatestApproved: true, }, }, { $sort: { "Document.data.DATE": -1 }, }, { $limit: 1 } ]