MongoDB – Overwrite the whole array field instead of its item
I have this schema:{ key: [] }. I want to convert it to { key: { foo: number } }. This is the query I came up with: db.collection.update({}, [ { "$set": { key: { foo: 43 } } }…
complexity in querying over array vs Object in mongoDB
let's suppose there are 1 million documents in a collection, each document need to have some tags corresponding to it, should i be storing these tags in the form or array or in the form of object having boolean values?…
MongoDB Add Array Element with Virtual Order
Does anyone know how to add an array element to a mongodb array and set a "virtual" order to the size of the array, all in an atomic operation? So, something like: db.users.updateOne( { _id: 1}, { $addToSet: { images:…
Mongodb – Update array specific items
I want only items in list entityParameters will update in x.Params by Id , update all items of entityParameters if entityParameters.Id == x.Params.Id List<Param> entityParameters filter = Builders<MachineObj>.Filter.Where(x => x.MachineId == id); update = Builders<MachineObj>.Update .Set(x => x.Params, entityParameters);
Preserve all groups generate by first $group when using the second $group in MongoDB aggregation
I have one collection that the structure of the record look like this, { _id: ObjectId('66a544dc3a8dff9aaaf65343'), user_type: "USER", status: CREATE } The explanation of each field: _id : ID generate by MongoDB user_type : the record's user type . Can…
MongoDB filter on same object in array
I have object with column chars with such data: { "chars": [ { "count": 1, "color": "red" }, { "count": 2, "color": "green" }, { "count": 3, "color": "blue" } ] } I want to exclude records with chars like…
Reactjs – Unable to Retrieve Student Data from MongoDB in React App – 500 Internal Server Error
Issue: I'm working on a React application with a backend built using Express and MongoDB. I'm encountering issues when trying to fetch student profile data. The browser console shows a 500 Internal Server Error. Backend Setup: Backend: Express, MongoDB Relevant…
Php versions – php not loading mongodb extension in xampp
I am trying to connect my laravel project to a mongodb. My php version is 8.1. I downloaded the threadsafe x64 for php 8.1 from text and pasted the dll file in my ext folder in php folder of xampp.…
Mongodb – How to use graphLookup to get the leaves of a tree-like data spread over 3 documents?
I have the following MongoDB collections: items: _id: ObjectId boxes: _id: ObjectId items: ObjectId[] boxes: ObjectId[] containers: _id: ObjectId boxes: ObjectId[] The items can be directly contained in boxes, and boxes can contain other boxes indefinitely deep. I am trying…
Reactjs – Post request working fine in Postman but not in browser
When sending SignUp and Login data through Postman, it's getting stored in Mongodb as well as showing success message but when requested through React axios, it is showing error in console as POST http://localhost:1000/auth/signup 400 (Bad Request) Below is the…