I have an appointment booking app and I want the booking detail will delete after the booked date expired. How can I achieve that? I tried it with node-scheduler but does not work. and its a simple API with Crud…
I would like to get price and date info and send to ejs the between two specific dates and names. My first document is like this and I have many. For instance I want all Bitcoin infos between 2022-4-1 and…
I have a notification collection and inside I have documents like this : id: 6253ec60facb2ee68475510e; companyId: 6253asdsad0facb2ee68475510e; workStatus: true id: 6253ec60abcb2ee68475510e; companyId: 6253ec60afva2ee68475510e; workStatus: true I want to search documents by the companyId and not id. When I do this…
In my node.js express application I am retrieving a user from my database const newUser = await User.create({ username, password, email, avatar, }) but before sending the response with the user object I want to remove the password. delete newUser.password;…
For example await Smartphones.findOne({_id: req.params.id}) await Smartphones.findOne({_id: ObjectId(req.params.id)}) To me it seem both return object, but I don't if it have any benefit of using ObjectId when comparing
I have 2 collections one is user and other is college. I want a rating schema with aggregate query user 1 gives 2 rating to college 1 I made a rating schema like rate = mongoose.Schema({ rating: number, userId: collegeid:})…
I've been trying to create a query on documents like these: [ { "timestamp": new ISODate('2020-01-01T00:00:00'), "objectId": "Id_A", "locationId": "Location_A" }, { "timestamp": new ISODate('2021-01-01T00:00:00'), "objectId": "Id_A", "locationId": "Location_A" }, { "timestamp": new ISODate('2022-01-01T00:00:00'), "objectId": "Id_A", "locationId": "Location_B" }, {…
i have a controller function as: User.updateOne( { _id: "6252d87e010b3f94adcf4e41" }, { $pull: { newCart: { "post._id": "6249e216c1e3b6ae2d4aa273", }, }, }, {new:true} ).then((res) => console.log(res, user)); The response is like this: { acknowledged: true, modifiedCount: 1, upsertedId: null, upsertedCount: 0,…
How to get the latest documents from a collection using date time? I have searched in SO for this specific problem, but couldn't find an example that is similar to my data structure. I have this kind of data structure:…
I have a collection like this: { '_id' : ObjectId('6251f8556e75125f9260f333'), 'name': 'jojo', 'profile': 'jojo profile', 'date': ISODate("2022-04-09T21:18:40.473Z"), 'look': [ { 'art': 'group-id', 'data': 'alma', 'dt': '1'}, { 'art': 'called', 'data': 'central', 'dt': '1'}, { 'art': 'access-time', 'data': 108000, 'dt': '1'}…