I am trying to find a way to query a mongodb collection: all documents whose state value of 'running' is also the latest entry inside the 'history' array should be returned. I was able to do this in C# with…
I have the following mongo model: { "_id" : "5f5a1c1f6976570001783ab7", "date" : NumberLong(1590624000), "source" : "here", } I would like to have the number of documents, group by date, that have source field at here value for example: { "date"…
Below is sample doc of collection. { name:"sam", age:20, hobbies: [ {id:1, value: "football"}, {id:2 value:"chess"} ] }, { "name": "Bob", "age": 30, "hobbies": [ { "id": 1, "value": "painting" }, { "id": 2, "value": "gardening" } ] }, {…
How to use $unset when a key contains dots in its name? const key = "test" const result = await db.collection(collection).updateOne( { [key]: { $exists: true } }, { $unset: { [pathToKey]: 1 } } ); given this document: {…
I have the following BSON : [ { arr: [ { age: 24 }, { age: 55 } ] }, { arr: [ { age: 12 }, { age: 14 }, { age: 17 } ] }, { arr: […
I need a query to find any documents exists in users collection which has groups._id which is not present in _id of groups collection users collection - docs { "_id": ObjectId("65c35a039773c8593fc45ddb"), "email": "email", "name": "name", "groups": [ { "_id": ObjectId("65c1b7716f130b7c4190104a"),…
{ _id: ObjectId("65bc98f235375d1d97621e06"), name: 'Aspirin', type: 'Pain Relief', forms: [ { formType: 'TabletsData', strength: '100mg', dosageInstructions: [ { time: 'Morning', instructions: [ { step: 1, text: 'Take 1 tablet with breakfast.', _id: ObjectId("65bc98f235375d1d97621e09") }, { step: 2, text: 'Drink a…
time: { $currentDate: { $type: "timestamp" } } }); It's not working for insert() can you help me, anyone?
I'm learning back end development and need some help in mongodb, axios my project is a simple todo app which stores the created tasks in a mongoDB database. link of repository is here My problem is when I create a…
I have used find to fetch record which was giving me a mongoose record, then I used toJson() to convert to object so I can modify the fields. body = req.body; const data = model.find({target: body.target}); I am getting mongoose…