I am trying to sum values from different objects. Each object has its ID, but the IDs can repeat in some objects. What I need to do now is sum the values from the objects that have the same ID.…
I have the problem where I need to modify a specific field of a object that is located in a array, but I would need to filter out the object within another array to get that specific object. For example,…
Please, help , I need to find count() of all _a[]._p[] elements having at least one of: _a[]._p[].s.d.t[].dateP=2022 and _a[]._p[].s.d.t[].tF="N" and _a[]._p[].s.c.t[].dateP=2022 and _a[]._p[].s.c.t[].tF="N" in following type of document: { "_id": ObjectId("5c05984246a0201286d4b57a"), f: "x", "_a": [ { "_p": [ {…
I'm inserting these documents: db.users.insert({user1: 'a',user2: 'b'}); db.users.insert({user1: 'b',user2: 'a'}); db.users.insert({user1: 'c',user2: 'd'}); db.users.insert({user1: 'd',user2: 'c'}); Please note that user1 and user2 are actually ObjectId, but I'm writing them as single char to better explain the issue. I need to…
app.post ('/create_contact',function(req,res) { contact.create({ name :req.body.name, phone:req.body.phone },function(err,newContact) { if(err){console.log('error in creating a contact!'); return;} console.log('********',newContact); return res.redirect('back'); }); }); Errors: throw new MongooseError('Model.create() no longer accepts a callback'); ^ MongooseError: Model.create() no longer accepts a callback I tried this…
How can i get sorted data in array by "name" in categories where '_id = 63fe948a22009cbbba53b905'? My sample data: { "_id": "63fe948a22009cbbba53b905", "options": { "sort": "manual" }, "categories": [ { "priority": 0, "options": "manual", "name": "Nazwa 1", "_id": "63fe8cc76d50062ae1f53821" },…
I have a document with an array field named items. This is an optional field and not always set within the document. So this could either be undefined, empty array, or contain an array of id numbers [1, 2, 3].…
I have written a MongoDB query that looks like this: db.collection.aggregate([ { $group: { _id: null, categories: { $addToSet: "$category" } } }, { $project: { _id: 0, categories: 1 } } ]) but the result is: [ { "categories":…
Consider: app.get("/posts/:postId", function(req, res) { const requestedPostId = req.params.postId; Post.findOne({_id: requestedPostId}, function(err, post) { res.render("post", { title: post.title, content: post.content }); }); }); This is what used to work for me, using Express.js and Mongoose. How can I fix it?
I have this document. { "_id": "1", "name": "KP", "points": 20 }, { "_id": "2", "name": "Josh", "points: 30 }, { "_id": "3", "name": "Angelo", "points": 50 } How do I get the sum of all fields (should be 100)…