[{"_id":1,"EventDatetime":"2020-07-12T19:38:00.653","Eventstatus":"05","DelNumber":"0703676929","DELIVERY_ITEM":[{"Product_Code":"123","Product_Name":"utensils","Shipment_Quantity":"12",},{"Product_Code":"456","Product_Name":"clothes","Shipment_Quantity":"10",}]},{"_id":2,"EventDatetime":"2020-07-12T19:38:00.653","Eventstatus":"03","DelNumber":"0703676929","DELIVERY_ITEM":[{"Product_Code":"123","Product_Name":"utensils","Shipment_Quantity":"12",},{"Product_Code":"456","Product_Name":"clothes","Shipment_Quantity":"10",}]},{"_id":3,"EventDatetime":"2020-07-12T19:38:00.653","Eventstatus":"02","DelNumber":"0703676929","DELIVERY_ITEM":[{"Product_Code":"123","Product_Name":"utensils","Shipment_Quantity":"12",},{"Product_Code":"456","Product_Name":"clothes","Shipment_Quantity":"10",}]},{"_id":4,"EventDatetime":"2020-07-12T19:38:00.653","Eventstatus":"04","DelNumber":"0703676928","DELIVERY_ITEM":[{"Product_Code":"123","Product_Name":"utensils","Shipment_Quantity":"12",},{"Product_Code":"456","Product_Name":"clothes","Shipment_Quantity":"10",}]},{"_id":5,"EventDatetime":"2020-07-12T19:38:00.653","Eventstatus":"02","DelNumber":"0703676928","DELIVERY_ITEM":[{"Product_Code":"123","Product_Name":"utensils","Shipment_Quantity":"12",},{"Product_Code":"456","Product_Name":"clothes","Shipment_Quantity":"10",}]},{"_id":6,"EventDatetime":"2020-07-12T19:38:00.653","Eventstatus":"01","DelNumber":"0703676928","DELIVERY_ITEM":[{"Product_Code":"123","Product_Name":"utensils","Shipment_Quantity":"12",},{"Product_Code":"456","Product_Name":"clothes","Shipment_Quantity":"10",}]}]

db.collection.aggregate([{$match:{DelNumber:"0703676929",Eventstatus:{$ne:"04"}}},{$addFields:{status:{$toInt:"$Eventstatus"}}},{$sort:{status:-1}},{$skip:1},{$limit:1}])