MongoDB Collection A contains documents with an array with some document ids of collection B: Collection A: { some_ids_of_b: ["id1", ...] } Collection B: { _id: "id1" }, { _id: "id2" }, ... How do I query all documents from…
Does anyone who knows how to filter data and only keep those history_doc.data.objectId equals _id? I have tried so many methods but none of them works {'history_doc.data.objectId': {$eq: '$_id'}} {'history_doc.data.objectId': {$eq: {$toString: '$_id'}}}
If I have a document that looks like this: { "firstName": "John", "lastName": "Doe", "favoriteFoods": [{"name": "Cheeseburgers"}, {"name": "Broccoli"}] } And I want to create a search expression in NodeJS to return just the element's of favoriteFood name matches req.body.term,…
I need to duplicate a document from my collection orders by filtering the field cd_order with value "7650614875". Collection orders look like this: { ... "cd_order": "7650614875" ... } I will copy this document more than 50 times (I will…
Array field in collection: "fruits": [ "fruits": [ "fruits": [ {"fruit1": "banana"}, {"fruit2": "apple"}, {"fruit3": "pear"}, {"fruit2": "apple"}, {"fruit4": "orange"}, {"fruit2": "apple"}, {"fruit3": "pear"}, {"fruit1": "banana"}, {"fruit4": "orange"}, {"fruit4": "orange"} {"fruit3": "pear"} {"fruit1": "banana"} ] I need to find those…
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 a collection of User documents, containing several fields and an array of Bets. I am trying to set up an update that I will run on a schedule. In the User documents, the Balance field needs to be…
{ 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 have a list of documents that looks like this: config: { _id: ObjectId('63c6a4b858612f44f37d4771'), type: "TypeA", priority: 1 } config: { _id: ObjectId('627279d3ba7aef5d6418c867'), type: "TypeB", priority: 3 } config: { _id: ObjectId('628b4d3ff5b1c1736c0b654a'), type: "TypeC", priority: 4 } The type is…