I have this document structure in my collection: { "grades": [ { "grade": "A", "score": 8 }, {"grade": "A", "score": 7 } ] } I need to filter for those documents when their score is divided by 7 has 0…
When an optional key in a collection is queried , performance varied with respect to the following two queries. Good response : When it queried with a specific value - a value other than null, it resulted good response time.…
Given multiples documents containing a key named userId, where this key is always an object: { "_id": { "$oid": "22fc6b11a0ff111d598b114f" }, "userId": { "KEY1" : ["..."], "KEY2" : ["..."], "KEY3" : ["..."], "KEY4" : ["..."] }, } It will always…
I have a collection of data like this: { "items": [ { "product": { "name": "prod1", "price": { "pledge": 1, "cost": 19 } } }, { "product": { "name": "prod2", "price": { "pledge": 2, "cost": 10 } } } ]…
I have list of mongo documents [ { "created_at": "2024-03-15T18:11:18.687", "updated_at": "2024-03-15T18:11:28.945", "fields": { "contract_first": [], "contract_second": [ { "position": "Bob" } ], "uuid": "bf031b46-ec33-4c61-ad33-a3ad2cbeb9cb" }, "id": "65f46520928f6fd496ffbe6d" }, { "created_at": "2024-03-15T18:11:18.687", "updated_at": "2024-03-15T18:15:26.838", "fields": { "contract_first": [ { "position":…
I have a mongodb collection called "Users" and I want to create a query to get the first and the last document from this collection based in a datetime field called InsertedAt. I know how to get the first and…
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: {…