Database

[{"Number":"2140007529","Name":"ABC","IsInactive":true,"EntryList":[{"Timestamp":ISODate("2022-06-01T14:00:00.000+00:00"),"Value":21564.0},{"Timestamp":ISODate("2022-07-01T21:31:00.000+00:00"),"Value":21568.0},{"Timestamp":ISODate("2022-08-02T21:21:00.000+00:00"),"Value":21581.642},{"Timestamp":ISODate("2022-09-02T15:42:00.000+00:00"),"Value":21593.551},{"Timestamp":ISODate("2022-09-26T13:00:00.000+00:00"),"Value":21603}]},{"Number":"2220000784","Name":"XYZ","IsInactive":false,"EntryList":[{"Timestamp":ISODate("2022-09-26T13:00:00.000+00:00"),"Value":0.0},{"Timestamp":ISODate("2022-10-01T08:49:00.000+00:00"),"Value":5.274},{"Timestamp":ISODate("2022-11-01T09:56:00.000+00:00"),"Value":76.753},{"Timestamp":ISODate("2022-12-01T19:43:00.000+00:00"),"Value":244.877},{"Timestamp":ISODate("2023-01-01T11:54:00.000+00:00"),"Value":528.56},{"Timestamp":ISODate("2023-02-01T17:21:00.000+00:00"),"Value":802.264}]}]

Query

db.collection.aggregate([{"$match":{"IsInactive":false,"EntryList.Timestamp":{"$gte":ISODate("2022-12-31")}}},{"$project":{"Number":1,"Name":1,"IsInactive":1,"EntryList":{"$filter":{"input":"$EntryList","cond":{"$gte":["$$this.Timestamp",ISODate("2022-12-31")]}}}}}])

Result