Mongo graphLookup problem. I want the num of degrees separation between jerry and superman, the answer should be 2. In my bi-directional node structure, jerry is connected to lois, louis is connected to superman. My data { "from" : "jerry",…
How to replace the first n occurance of string in mongodb database. sample JSON : [{ "NAME":"Peter Parker", "NUMBER":"6882859392" }, { "NAME":"Jhon Ripper", "NUMBER":"9285346361" }, { "NAME":"James", "NUMBER":"8754859390" }] i want to update 1st 5 occurence of NUMBER field of…
I have an aggregation query whose MongoDB repsonse is : _id: ObjectId('5e822d6c87502b3a9b751786') I would like to get the string inside the ObjectId which is 5e822d6c87502b3a9b751786. [ Problem ] I have searched this question but so far there are only three…
{ name: "use_name", grades: [ {class: "math": grade: 100}, {class: "english": grade: 90} ] } How do I write an aggregation pipeline to output: { name: "use_name", grades: {class: "math": grade: 100}, } The grades field has been reduced to…
I'm performing MongoDB aggregation to create a new collection from an existing one, and I'm struggling to find a way to group elements by count, rather than by values. I want to achieve something like this: data: [ {"_id": "my_id_0"},…
Stages of MongoDB aggregation pipeline are always executed sequentially. Can the documents that the pipeline processes be changed between the stages? E.g. if stage1 matches some docs from collection1 and stage2 matches some docs from collection2 can some documents from…
I have a groups collection with documents of the form { "_id": "g123" ..., "invites": [ { "senderAccountId": "a456", "recipientAccountId": "a789" }, ... ] } I want to be able to list all the invites received by a user. I…
I have these collections: author [ { _id: "63c242130b17d5516e0cb499", author_name:'Vyom', book_ids:["63c242330b17d5516e0cb49a","63c242410b17d5516e0cb49b"] } ] book [ { _id:"63c242330b17d5516e0cb49a", author_id:'63c242130b17d5516e0cb499', book_name:'True Love', genere:'horror' }, { _id:"63c242410b17d5516e0cb49b", author_id:'63c242130b17d5516e0cb499', book_name:'Monster Strike', genere:'romance' }, ] I want to fetch details of books in author collection…
I've done this sometime last year, but now I really can't recall and can't find any helpful resources. I want to get the statistics of my collection based on types. This is my data object { "_id": { "$oid": "63bfc374378c59a5328f229e"…
I am trying to merge an object inside an array with the same date but with a different key name for the status key. I have 2 collections users and canteens The query I am trying to get the result…