{
"_id" : ObjectId("63810333ae6cd2130104bfd7"),
"calendarId" : ObjectId("63810333ae6cd2130104bfd6"),
"date" : 26,
"endDate" : "01-01-2024",
"endMonth" : 1,
"endTime" : "5:00 AM",
"endYear" : 2024,
"groupId" : ObjectId("5f06cca74e51ba15f5167b86"),
"insertedAt" : "2022-11-25T18:02:27.432666Z",
"isActive" : true,
"location" : {
"latitude" : "127.386",
"logitude" : "138.43"
},
"reminder" : "30 MIN",
"reverseEndDate" : "2024-01-01",
"reverseStartDate" : "2023-09-26",
"sortDate" : 20230926,
"sortTime" : 300,
"startDate" : "26-09-2023",
"startMonth" : 9,
"startTime" : "3:00 AM",
"startYear" : 2023,
"title" : "New post test",
"updatedAt" : "2022-11-25T18:02:27.432696Z",
"venue" : "MYSORE"
}
{
"_id" : ObjectId("63810363ae6cd21301348ef9"),
"calendarId" : ObjectId("63810df2ae6cd21301ad489b"),
"date" : 28,
"endDate" : "16-08-2022",
"endMonth" : 8,
"endTime" : "5:00 AM",
"endYear" : 2022,
"groupId" : ObjectId("5f06cca74e51ba15f5167b86"),
"insertedAt" : "2022-11-25T18:48:18.809333Z",
"isActive" : true,
"location" : {
"latitude" : "127.386",
"logitude" : "138.43"
},
"reminder" : "30 MIN",
"reverseEndDate" : "2022-08-16",
"reverseStartDate" : "2022-08-15",
"sortDate" : 20220815,
"sortTime" : 300,
"startDate" : "15-08-2022",
"startMonth" : 8,
"startTime" : "3:00 AM",
"startYear" : 2022,
"title" : "New",
"updatedAt" : "2022-11-25T18:48:18.809358Z",
"venue" : "MYSORE"
}
{
"_id" : ObjectId("638103baae6cd213014b43fd"),
"calendarId" : ObjectId("638103baae6cd213014b43fc"),
"date" : 30,
"endDate" : "02-10-2023",
"endMonth" : 10,
"endTime" : "5:00 AM",
"endYear" : 2023,
"groupId" : ObjectId("5f06cca74e51ba15f5167b86"),
"insertedAt" : "2022-11-25T18:04:42.263385Z",
"isActive" : true,
"location" : {
"latitude" : "127.386",
"logitude" : "138.43"
},
"reminder" : "30 MIN",
"reverseEndDate" : "2023-10-02",
"reverseStartDate" : "2023-09-30",
"sortDate" : 20230930,
"sortTime" : 300,
"startDate" : "30-09-2023",
"startMonth" : 9,
"startTime" : "3:00 AM",
"startYear" : 2023,
"title" : "New post test",
"updatedAt" : "2022-11-25T18:04:42.263411Z",
"venue" : "MYSORE"
}
{
"_id" : ObjectId("638103f9ae6cd2130198b544"),
"calendarId" : ObjectId("638103f9ae6cd2130198b543"),
"date" : 1,
"endDate" : "02-10-2023",
"endMonth" : 10,
"endTime" : "5:00 AM",
"endYear" : 2023,
"groupId" : ObjectId("5f06cca74e51ba15f5167b86"),
"insertedAt" : "2022-11-25T18:05:45.365134Z",
"isActive" : false,
"location" : {
"latitude" : "127.386",
"logitude" : "138.43"
},
"reminder" : "30 MIN",
"reverseEndDate" : "2023-10-02",
"reverseStartDate" : "2023-10-01",
"sortDate" : 20231001,
"sortTime" : 300,
"startDate" : "01-10-2023",
"startMonth" : 10,
"startTime" : "3:00 AM",
"startYear" : 2023,
"title" : "New post test",
"updatedAt" : "2022-11-25T18:52:55.336916Z",
"venue" : "MYSORE"
}
{
"_id" : ObjectId("63811207ae6cd21301772c14"),
"calendarId" : ObjectId("63811207ae6cd21301772c13"),
"endDate" : "02-09-2023",
"endMonth" : 9,
"endTime" : "5:00 AM",
"endYear" : 2023,
"groupId" : ObjectId("5f06cca74e51ba15f5167b86"),
"insertedAt" : "2022-11-25T19:05:43.518031Z",
"isActive" : true,
"location" : {
"latitude" : "127.386",
"logitude" : "138.43"
},
"reminder" : "30 MIN",
"reverseEndDate" : "2023-09-02",
"reverseStartDate" : "2022-10-01",
"sortDate" : 20221001,
"sortTime" : 300,
"startDate" : "01-10-2022",
"startMonth" : 10,
"startTime" : "3:00 AM",
"startYear" : 2022,
"title" : "New post test",
"updatedAt" : "2022-11-25T19:05:43.518053Z",
"venue" : "MYSORE"
}
query used to filter
db.calendar_events_db.find({"$and":[{startMonth:{"$lte":9}},{endMonth:{"$gte":9}},{startYear:{"$lte":2023}},{endYear:{"$gte":2023}}]}).pretty()
expected documents
{
"_id" : ObjectId("63810333ae6cd2130104bfd7"),
"calendarId" : ObjectId("63810333ae6cd2130104bfd6"),
"date" : 26,
"endDate" : "01-01-2024",
"endMonth" : 1,
"endTime" : "5:00 AM",
"endYear" : 2024,
"groupId" : ObjectId("5f06cca74e51ba15f5167b86"),
"insertedAt" : "2022-11-25T18:02:27.432666Z",
"isActive" : true,
"location" : {
"latitude" : "127.386",
"logitude" : "138.43"
},
"reminder" : "30 MIN",
"reverseEndDate" : "2024-01-01",
"reverseStartDate" : "2023-09-26",
"sortDate" : 20230926,
"sortTime" : 300,
"startDate" : "26-09-2023",
"startMonth" : 9,
"startTime" : "3:00 AM",
"startYear" : 2023,
"title" : "New post test",
"updatedAt" : "2022-11-25T18:02:27.432696Z",
"venue" : "MYSORE"
}
{
"_id" : ObjectId("638103baae6cd213014b43fd"),
"calendarId" : ObjectId("638103baae6cd213014b43fc"),
"date" : 30,
"endDate" : "02-10-2023",
"endMonth" : 10,
"endTime" : "5:00 AM",
"endYear" : 2023,
"groupId" : ObjectId("5f06cca74e51ba15f5167b86"),
"insertedAt" : "2022-11-25T18:04:42.263385Z",
"isActive" : true,
"location" : {
"latitude" : "127.386",
"logitude" : "138.43"
},
"reminder" : "30 MIN",
"reverseEndDate" : "2023-10-02",
"reverseStartDate" : "2023-09-30",
"sortDate" : 20230930,
"sortTime" : 300,
"startDate" : "30-09-2023",
"startMonth" : 9,
"startTime" : "3:00 AM",
"startYear" : 2023,
"title" : "New post test",
"updatedAt" : "2022-11-25T18:04:42.263411Z",
"venue" : "MYSORE"
}
result
{
"_id" : ObjectId("638103baae6cd213014b43fd"),
"calendarId" : ObjectId("638103baae6cd213014b43fc"),
"date" : 30,
"endDate" : "02-10-2023",
"endMonth" : 10,
"endTime" : "5:00 AM",
"endYear" : 2023,
"groupId" : ObjectId("5f06cca74e51ba15f5167b86"),
"insertedAt" : "2022-11-25T18:04:42.263385Z",
"isActive" : true,
"location" : {
"latitude" : "127.386",
"logitude" : "138.43"
},
"reminder" : "30 MIN",
"reverseEndDate" : "2023-10-02",
"reverseStartDate" : "2023-09-30",
"sortDate" : 20230930,
"sortTime" : 300,
"startDate" : "30-09-2023",
"startMonth" : 9,
"startTime" : "3:00 AM",
"startYear" : 2023,
"title" : "New post test",
"updatedAt" : "2022-11-25T18:04:42.263411Z",
"venue" : "MYSORE"
}
Any way to filter the documents