Basically I want to update all documents inside one collection. The update is just adding 2 hours to date fields present in each document. The documents all follow a basic structure like this : { code : 1, file :…
Let's say I have the following collection with _id and traits. [ { _id: 1, traits: { Rarity: { infoin: 15, }, Type: { iron: 3, sliver: 5, wood: 7, }, }, }, { _id: 2, traits: { Cloth: {…
Is there a way to ignore a parameter when querying documents using PyMongo in one line? For example: db.find_one( { "first_name": firstname, "last_name": lastname, "age": age if age else <ignore this field from querying all together> } ):
I want to request a certain userId via NodeJs but I always receive all documents from MongoDb, independent of the userId I provide. This is my route: router.get('/wallet/showWallet/', walletController.showWallet) Controller: const showWallet = async(req,res)=>{ try { let user = req.query.userId;…
I'm trying to find all the documents with first name starting with Ram or Shyam. I tried the following which actually worked in mongoDb db.collection.find({ $or: [ { name: { $regex: "^Ram" } }, { "name": { "$regex": "^Shyam" }…
I'm trying to get a list of current holders at specific times from a collection. My collection looks like this: [ { "time": 1, "holdings": [ { "owner": "A", "tokens": 2 }, { "owner": "B", "tokens": 1 } ] },…
I want to search for records using the below-mentioned Field and code I have used, returning nothing. I'm sure I'm querying wrongly, and can anyone help me build the correct query code? Code I have used: const { id }…
I have one data example like this one in MongoDB. { id: 628a8683fc489c315b330ade, examName : 'Final Exam', schedule: { scheduleDate : '2021-10-18T17:00:00.000+00:00' scheduleName : 'Package Test' package:[ { exclude_question:[1,2], namePackage:testing packageId:628a89c2fc489c315b330b01 } ] }, question:[ { id:1, question:'hello can u…
i need to join two documents where in the first there a property as array of _ids and in the second documents to join db={ "tipo_pratica": [ { "_id": "618981a4c1b8b3bc67ff80b6", "descrizione": "anticipata", "modulo": [ "628015cd2fd9dfee86ac6820", "62801a4c2fd9dfee86ac6821", "6278f8d9d4aa4f4cef1a8266" ]}, { "_id":…
I was trying run a conditional group and push. I don’t know if it is possible with MongoDb aggregate or with NodeJs. I have attendance collection and shifts collection like below. And also created Playground for my current try Mongo…