{
"_id" : ObjectId("6287e3c6ae6cd20f3571fd80"),
"attendanceStaff" : [
{
"attendanceId" : "6287e3c6ae6cd20f3571fd9a",
"attendanceTakenById" : "6069a5daa0ccf704e7319d16",
"attendanceTakenByName" : "Admin ",
"date" : "20-05-2022",
"dateString" : "20220520",
"day" : 20,
"isApproved" : false,
"session" : "morning"
},
{
"attendanceId" : "62885168ae6cd2094074eb5a",
"attendanceTakenById" : "6069a5daa0ccf704e7319d16",
"attendanceTakenByName" : "Admin ",
"date" : "21-05-2022",
"dateString" : "20220521",
"day" : 21,
"isApproved" : false,
"session" : "morning"
},
{
"attendanceId" : "628855b2ae6cd209405267f2",
"attendanceTakenById" : "6069a5daa0ccf704e7319d16",
"attendanceTakenByName" : "Admin ",
"date" : "21-05-2022",
"dateString" : "20220521",
"day" : 21,
"isApproved" : false,
"session" : "afternoon"
}
],
"groupId" : ObjectId("5f06cca74e51ba15f5167b86"),
"insertedAt" : "2022-05-20T18:53:58.086391Z",
"isActive" : true,
"month" : 5,
"updatedAt" : "2022-05-20T18:53:58.086385Z",
"userId" : ObjectId("606b6c5fa0ccf722221c7319"),
"year" : 2022
}
{
"_id" : ObjectId("6287e3c6ae6cd20f3571fd81"),
"attendanceStaff" : [
{
"attendanceId" : "6287e3c6ae6cd20f3571fd9a",
"attendanceTakenById" : "6069a5daa0ccf704e7319d16",
"attendanceTakenByName" : "Admin ",
"date" : "20-05-2022",
"dateString" : "20220520",
"day" : 20,
"isApproved" : false,
"session" : "morning"
},
{
"attendanceId" : "62885168ae6cd2094074eb5a",
"attendanceTakenById" : "6069a5daa0ccf704e7319d16",
"attendanceTakenByName" : "Admin ",
"date" : "21-05-2022",
"dateString" : "20220521",
"day" : 21,
"isApproved" : false,
"session" : "morning"
},
{
"attendanceId" : "628855b2ae6cd209405267f2",
"attendanceTakenById" : "6069a5daa0ccf704e7319d16",
"attendanceTakenByName" : "Admin ",
"date" : "21-05-2022",
"dateString" : "20220521",
"day" : 21,
"isApproved" : false,
"session" : "afternoon"
}
],
"groupId" : ObjectId("5f06cca74e51ba15f5167b86"),
"insertedAt" : "2022-05-20T18:53:58.086403Z",
"isActive" : true,
"month" : 5,
"updatedAt" : "2022-05-20T18:53:58.086397Z",
"userId" : ObjectId("606b6c77a0ccf72222c5d301"),
"year" : 2022
}
{
"_id" : ObjectId("6287e3c6ae6cd20f3571fd82"),
"attendanceStaff" : [
{
"attendanceId" : "6287e3c6ae6cd20f3571fd9a",
"attendanceTakenById" : "6069a5daa0ccf704e7319d16",
"attendanceTakenByName" : "Admin ",
"date" : "20-05-2022",
"dateString" : "20220520",
"day" : 20,
"isApproved" : false,
"session" : "morning"
},
{
"attendanceId" : "62885168ae6cd2094074eb5a",
"attendanceTakenById" : "6069a5daa0ccf704e7319d16",
"attendanceTakenByName" : "Admin ",
"date" : "21-05-2022",
"dateString" : "20220521",
"day" : 21,
"isApproved" : false,
"session" : "morning"
},
{
"attendanceId" : "628855b2ae6cd209405267f2",
"attendanceTakenById" : "6069a5daa0ccf704e7319d16",
"attendanceTakenByName" : "Admin ",
"date" : "21-05-2022",
"dateString" : "20220521",
"day" : 21,
"isApproved" : false,
"session" : "afternoon"
}
],
"groupId" : ObjectId("5f06cca74e51ba15f5167b86"),
"insertedAt" : "2022-05-20T18:53:58.086415Z",
"isActive" : true,
"month" : 5,
"updatedAt" : "2022-05-20T18:53:58.086409Z",
"userId" : ObjectId("606b6cc1a0ccf72222117b3e"),
"year" : 2022
}
{
"_id" : ObjectId("6287e3c6ae6cd20f3571fd83"),
"attendanceStaff" : [
{
"attendanceId" : "6287e3c6ae6cd20f3571fd9a",
"attendanceTakenById" : "6069a5daa0ccf704e7319d16",
"attendanceTakenByName" : "Admin ",
"date" : "20-05-2022",
"dateString" : "20220520",
"day" : 20,
"isApproved" : false,
"session" : "morning",
"attendance" : "present",
"time" : "08:29"
},
{
"attendanceId" : "62885168ae6cd2094074eb5a",
"attendanceTakenById" : "6069a5daa0ccf704e7319d16",
"attendanceTakenByName" : "Admin ",
"date" : "21-05-2022",
"dateString" : "20220521",
"day" : 21,
"isApproved" : false,
"session" : "morning"
},
{
"attendanceId" : "628855b2ae6cd209405267f2",
"attendanceTakenById" : "6069a5daa0ccf704e7319d16",
"attendanceTakenByName" : "Admin ",
"date" : "21-05-2022",
"dateString" : "20220521",
"day" : 21,
"isApproved" : false,
"session" : "afternoon",
"attendance" : "present",
"time" : "08:30"
}
],
"groupId" : ObjectId("5f06cca74e51ba15f5167b86"),
"insertedAt" : "2022-05-20T18:53:58.086427Z",
"isActive" : true,
"month" : 5,
"updatedAt" : "2022-05-20T18:53:58.086421Z",
"userId" : ObjectId("606b6cd7a0ccf7222269ae8d"),
"year" : 2022
}
{
"_id" : ObjectId("6287e3c6ae6cd20f3571fd84"),
"attendanceStaff" : [
{
"attendanceId" : "6287e3c6ae6cd20f3571fd9a",
"attendanceTakenById" : "6069a5daa0ccf704e7319d16",
"attendanceTakenByName" : "Admin ",
"date" : "20-05-2022",
"dateString" : "20220520",
"day" : 20,
"isApproved" : false,
"session" : "morning",
"attendance" : "present",
"time" : "08:29"
},
{
"attendanceId" : "62885168ae6cd2094074eb5a",
"attendanceTakenById" : "6069a5daa0ccf704e7319d16",
"attendanceTakenByName" : "Admin ",
"date" : "21-05-2022",
"dateString" : "20220521",
"day" : 21,
"isApproved" : false,
"session" : "morning"
},
{
"attendanceId" : "628855b2ae6cd209405267f2",
"attendanceTakenById" : "6069a5daa0ccf704e7319d16",
"attendanceTakenByName" : "Admin ",
"date" : "21-05-2022",
"dateString" : "20220521",
"day" : 21,
"isApproved" : false,
"session" : "afternoon",
"attendance" : "present",
"time" : "08:30"
}
],
"groupId" : ObjectId("5f06cca74e51ba15f5167b86"),
"insertedAt" : "2022-05-20T18:53:58.086439Z",
"isActive" : true,
"month" : 5,
"updatedAt" : "2022-05-20T18:53:58.086433Z",
"userId" : ObjectId("606b6cfaa0ccf722224daddc"),
"year" : 2022
}
The query us to filter
db.staff_attendance_database.find({"userId" : ObjectId("606b6cfaa0ccf722224daddc"),"month" : 5,"groupId" : ObjectId("5f06cca74e51ba15f5167b86")},{"attendanceStaff.day":21}).pretty()
The result I’m getting
{
"_id" : ObjectId("6287e3c6ae6cd20f3571fd84"),
"attendanceStaff" : [
{
"day" : 20
},
{
"day" : 21
},
{
"day" : 21
}
]
}
I just wanted to fetch all document of day 21