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…
In my data, one of the fields is an array and I want to return only a section of that array, and only that, no more fields. But when I'm using the $slice in projection, it will return all the…
I'm creating a chat app, and when a user starts a new conversation, I want to check if a conversation between those two users already exists. My Conversation modal looks something like: { members: { type: [ { username: String,…
I try to use 'mongoexport' to retrieve the 'Url' value: $ mongoexport -d "db" -c "collection" -q '{"Id":"5400490185"} | jq . return: { "_id": { "$oid": "641e8845c0a3fde195b5901b" }, "Url": "https://example.org", "Id": "5400490185", "Title": "xxx", "Description": "foobar", "Date_Time": "1679697365" } Now…