I have a MongoDB collection that stores some test submissions. The highlevel schema looks as follows. { "lessonType": "quiz", "userId": "639cb6d9513a420026eddca1" "courseId": "639cb6d9513a420026eddca2", "lessonId": "639cb6d9513a420026eddca3", ...some_more_fields } Now there are two indexes on this collection. first one: { courseId: 1,…
Supposed I have the following data: Time Submitted 1 True 2 True 3 True 4 False 5 False 6 False My goal is to get either the the oldest unsubmitted OR the newest submitted. This is for loading user timesheets,…
{ "offers" : [ { "name" : "min", "prices" : [ 8, 15, 18 ] }, { "name" : "max", "prices" : [ 9, 11, 18 ] } ], "nl" : [ 2, 4, 6, 7 ] } update aggregation…
I use Mongo 4.4. I'm trying to make a mongo aggregation that would return me a document with nested arrays. To specify the context: I have offers, which contain modules, which contain items, which themselves contain notes. I have a…
I have this collection: { A:1 B:2 :3 D:4 } We need to replace a whitespace with C for example, how can I achieve this? Like this { A:1 B:2 C:3 D:4 } I tried renaming, but it's not possible…
https://mongoplayground.net/p/zIhLOT8YXLl document schema: { _id: ObjectId(); array_property: [ {_id: ObjectId(), img_array: ["string", "string"] }, { }, ... ] } query: await user.updateOne( { _id: user_id, array_property: { $elemMatch: { _id: { $in: arrary_of_id } } }, }, { $push: {…
I've a mongo collection having around 550,000 documents. Document has an array field path on which i have a below query in my java code. This field is indexed. Problem is ids in below query can go up to 6000…
I have the following record: id: 119, customfields: Array (2) 0: Object value: "Mr" type: "salutation" 1: Object value: "Google" type: "company" I need to update this document so that I get: id: 119, salutation: "Mr", company: "Google" Important is:…
compound index: { A: 1, B: 1, C: 1 } query: col.aggregate([ { $match: { B: "ssome_value", C: "some_other_value, } } ]) The query does not involve A, so the compound index is not used. I can do this to…
I have Millions of documents in the mongodb collection. I want to group the documents based on minute and hour interval. I created the index for timestamp. I tried below mentioned query, but it's took too much time or timeout.…