I have a mongodb query and already created all required indices. But query still scanning all the documents in the collection. Following is the query: [ { "$group": { "driverStatuses": { "$addToSet": "$driverStatus" }, "batchAddedAt": { "$first": "$batchAddedAt" }, "cityId":…
I have a collection of documents that each contain arrays. the output i want is the unwinded array elements filtered down by a certain criteria. i can do this by doing: db.collection.aggregate([ { $unwind: "$myArrayField" }, { $match: { "myArrayField.myCriteriaField":…
I have two models called session and unreadcount. I need to get that particular session count from another table. below are my two Mongodb models. var UnreadCountSchema = new mongoose.Schema({ userId: { type: String, required: true }, sessionId: { type:…
I am working on an endpoint with nodejs/express and mongoose. The endpoint should return only the found ID like this: { "id": 3000, "group": 3, "title": "", "start_time": "2023-07-31T11:00:00.000Z", "end_time": "2023-07-31T20:00:00.000Z", "category": "green" } However, when I tested (localhost:3000/api/one/3000) it…
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: {…