So I have Been Writing this function all night, its goal is to find and sort data from two tables and then return an array of objects containing my needed data But the array keep showing empty
router.post('/find/', (req,res,next)=>{
try {
// Return an array of Hotels in the Region
hotels.find({region:"wuse"}).then(hotel=>{
const finalArr = []
for(var i = 0; i< hotel.length;i++){
rooms.find({hotel:hotel[i]._id,price:{$lt : 29000}}).then(rooms=>{
for(var j = 0; j <rooms.length; j++ ){
// Push to the arr
finalArr.push(rooms[j])
console.log(rooms[j]);// Its Works
}
}).catch(err =>{
console.log(err);
})
}
console.log(finalArr);// And This Return [] an Empty Array
res.end()
}).catch(err =>{
console.log(err);
})
} catch (error) {
console.log(error);
}
})
I have used Async/await, append(), forEach() and Promise.all()
any solution would.
