I am new to MongoDB. I have a VIEW created on a collection, I need to make a modification to this VIEW. Say we have a collection CollectionName. It has an array field aArray. This arrays has 2 fields, arrayField1…
Messing around with aggregations in MongoDB in a Node / Express app with Mongoose. Here's the route: router.get("/search", async (req, res) => { let movies; if(req.query.search){ escapeRegex(req.query.search); const regex = new RegExp(escapeRegex(req.query.search), 'gi'); movies = await Movie.aggregate( [ { '$match':…
I have a MongoDB collection containing documents like these: { "id": "62cd5de762c595905e37821b", "letterNo": "122233", "letterDate": "2023-03-01", "metaData": { "name": "test", "family ": "test" } }, { "id": "62cd5de762c595905e37821a", "letterNo": "122233", "letterDate": "2023-03-01", "metaData": { "type": "xxxx", "where": "test" } }…
I have a collection which has one of the fields in it as a nested dictionary. Sample: { "_id": ObjectId(""), "family_member": { "mother":{ "name": "Mary", "age": 40, "address": { "city": "Dover", "state": "Delaware", "zip_code": "19901" } }, "father":{ "name": "John",…
Given a mongoose object. How can I do a full text search in document object { "product" :[ { "_id": "633d32c4ea9b06177e183388", "document": { "_id": "633d32c4ea9b06177e183388", "category": [ "62bacb137e6e0b6ac850b9ce", "633d19260b72ba127d928e74" ], "name": "Iphone 13", "slug": "iphone-13", "__v": 0, "price": 2000.5, "images":…
I have a MongoDB collection with around 20K articles with an "articledate" string field with dates in the "dd/mm/YYYY" format. Want to query the collection and get the sum of the count of articles in each mm/YYYY. This is the…
I am unable to connect Atlas MongoDB while using --host option, But i'm able to connect while using --uri option where did i made a mistake? For example: --uri option It's working fine mongodump --uri="mongodb+srv://<username>:<password>@<hostname>/<dbname>" --gzip --out=/dir1/dir2 --host option getting…
My mongodb user collection is of following schema: { _id: ObjectId("6420eb68cd0df40a33b0ead7"), FirstName: 'Ashutosh', LastName: 'Garg', Email: '[email protected]', Password: 'password', Role: 'Tenant', Properties: [ ObjectId("6420eeb8cd0df40a33b0eadb") ] } My User.cs is: using MongoDB.Bson; using MongoDB.Bson.Serialization.Attributes; using MongoDB.Driver; using System.Text.Json.Serialization; namespace webapi.Models {…
I have an asynchronous route at /api/dashboard the code is below: router.get("/", async (req, res, next) => { let userID try { const jwt = req.headers.authorisation.split(" ")[1]; const { payload } = verifyToken(jwt, res); userID = payload?.id; } catch (err)…
Schema: { img: // array of minimum length 1 of ObjectIds or field is "missing" to indicate that array is empty tar: [ { img: // array of minimum length 1 of ObjectIds or field is "missing" to indicate that…