How to select the document based on day

{
	"_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

This is the same question as your other thread How to fetch all the values of the specified date in the particular array

Changing from day 18 to day 21 won’t provide you with a different answer. So here is the same answer:

Try to do that in an aggregation $set stage using $filter.

There are examples that you may use to help you.

This topic was automatically closed 5 days after the last reply. New replies are no longer allowed.