I need to upsert many documents based on _id. E.g. document_1 = {_id:"1", "age":11, "name":"name1"} document_2 = {_id:"2", "age":22, "name":"name2"} I wrote the below db.my_collection.updateMany( { _id: {"$in":["1","2"] } }, [ {$set: {_id:"1", "age":11, "name":"name1"}}, {$set: {_id:"2", "age":22, "name":"name2"}} ],…
Currently a document looks like this: { "Post": "this is a post", "_id": ObjectId("630f3c32c1a580642a9ff4a0"), "iframe": ""https:/www.youtube.com/embed/RzVvThhjAKw"", "slug": "this-is-a-title", "title": "This is a title" } But I want it like this: { "Post": "this is a post", "_id": ObjectId("630f3c32c1a580642a9ff4a0"), "iframe": "https:/www.youtube.com/embed/RzVvThhjAKw",…
If I have a controller like this: const Review = require('../models/review') const Launch = require('../models/launch') async function getReviewsByUserId (req, res) { const { userId } = req.params const reviews = await Review.find({ userId }).lean() || [] return res.status(200).send(reviews.reverse()) } How…
So assume I have a document as shown below: { "_id" : ObjectId("6336d94e0330f5d48e44fb0f"), "systemId" : "5124301", "userId" : "9876543210", "tempId" : "123456da87sdafasdf", "updatedAt" : ISODate("2022-09-30T12:01:11.714+0000"), "receivedAt" : ISODate("2022-04-10T23:15:08.145+0000"), } Now I already have a tempId assigned to the doc and…
The following query updated the collection and increments the field count. I want to send the updated count as a response without making another api call. The variable usage does not project the values. handler.put(async (req, res) => { console.log("in…
Mongo Playground Lets say I have docs with 3 props, FieldA, B, C. I would like to do a match of all docs that don´t have the 3 props null. I am trying $all, $nor, $not, $ne, etc... but none…
I have a cart collection, which can have the same product with different variants. The problem is when I fetch the user cart and query for all those ids, when theres a duplicated one MongoDB is not including it in…
I have a large collection I'm searching through on mongodb. (Supports PCRE v8.42) Let's say I'm trying to find where "comment" contains "alpha bravo" where the field value of "name" doesn't immediately follow In other words, match $regex: "alpha bravo…
I have a large script, the following section is the relevant part, but if people prefer I can post the whole script on request. The script iterates through a list, looking for a field called colour and renames it color.…
I'm starting to learn Aggregate in MongoDB. I have a simple doc as below, which has 2 fields, name and examScores. examScores is an array containing multiple documents: [ { _id: ObjectId("633199db009be219a43ae426"), name: 'Max', examScores: [ { difficulty: 4, score:…