Database
[{"vehicleId":123,"startTime":ISODate("2021-01-01T12:00:00.000Z"),"endTime":ISODate("2021-01-01T13:00:00.000Z"),"availability":"Available"},{vehicleId:123,startTime:ISODate("2021-01-01T13:00:00.000Z"),endTime:ISODate("2021-01-01T14:00:00.000Z"),availability:"Partially_Available"},{vehicleId:123,startTime:ISODate("2021-01-01T14:00:00.000Z"),endTime:ISODate("2021-01-01T15:00:00.000Z"),availability:"Available"},{vehicleId:123,startTime:ISODate("2021-01-01T14:00:00.000Z"),endTime:ISODate("2021-01-01T15:00:00.000Z"),availability:"Booked"},{vehicleId:123,startTime:ISODate("2021-01-01T12:00:00.000Z"),endTime:ISODate("2021-01-01T16:00:00.000Z"),availability:"Available"},{vehicleId:456,startTime:ISODate("2021-01-01T14:00:00.000Z"),endTime:ISODate("2021-01-01T15:00:00.000Z"),availability:"Available"},{vehicleId:456,startTime:ISODate("2021-01-01T13:00:00.000Z"),endTime:ISODate("2021-01-01T14:00:00.000Z"),availability:"Booked"},{vehicleId:789,startTime:ISODate("2021-01-01T14:00:00.000Z"),endTime:ISODate("2021-01-01T15:00:00.000Z"),availability:"Partially_Available"}]
Query
db.collection.find({availability:{$in:["Available","Partially_Available"]},startTime:{$gte:ISODate("2021-01-01T12:00:00.000Z")},endTime:{$lte:ISODate("2021-01-01T15:00:00.000Z")}})