I have a function defined like this: export async function removeUser(deleteUserId: Types.ObjectId) When I mistakenly called this function and pass a Mongoose object's id parameter, which is a string, it triggered a runtime exception further in the code when I…
I have a collection of say questions like below - { question: "what's the question?", answer: "some answer", points: 10 }, { question: "what's the question again?", answer: "some answer again", points: 40 }, ... The questions which are answered…
I am trying to update the like count of job posts in my application using the $inc operator and the findByIdAndUpdate method from Mongoose. The correct document is being retrieved and returned but the like count for the job post…
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 want to sum of values inside array of objects which have another array of objects. In my case; how can I count 'url' values in all documents inside 'urls' array under 'iocs' array; Mongo playground: open Here is document…
I've got a head-scratcher here that I'd like to share with you all. So here's the model: _id: ObjectId() name: String, columns: [ { name: String, _id: ObjectId() tasks: [ { title: String, description: String, status: String, _id: ObjectId() subtasks:…
i have a collection with more then 1000 documents and there are some documents with same value in some fields, i need to get those the collection is: [{_id,fields1,fields2,fields3,etc...}] what query can i use to get all the elements that…
I have a collection "product_reviews" with this document structure { _id: 'B000000OE4', 'product/title': 'Working Class Hero', 'product/price': '16.99', reviews: [ { 'review/userId': 'unknown', 'review/profileName': 'unknown', 'review/helpfulness': '2/3', 'review/score': '4.0', 'review/time': '27/05/1999/00:00:00', 'review/summary': 'Worth it for one song', 'review/text': "I really…
I have a collection in MongoDb someCollection containing field field1. I want to add another field with values equal to field1. I do it like this: db.someCollection.updateMany({}, {$set:{"newField": "$field1"}}) But the after update I got row like this {"field1": "value1",…
How can I get all the sum of fields in an array in Mongoose? I want to sum up all the amounts in the payments array. DB: [ { "_id": 0, "name": "shoe", "payments": [ { "type": "a", "amount": 10…