How to filter data between year and month in mongodb?
I want to filter data by year in MongoDB. If I pass year 2022 then show only 2022 year data and when I pass 2023 show 2023 data only. I am not getting how to filter. I use $gte and…
How to compare two objects in MongoDB (ignoring order of keys)?
What is the best way to find all the documents where objA is the same as objB (order of keys is not important)? Inspired by another question by @Digvijay, I was looking for a way to compare two objects on…
Mongodb – Can a unique field be a prefix in a compound index?
Does it make any sense at all, since the each value of the prefix will have only one value of any suffix, there is no further sorting that can be done after the prefix?
How to populate nested fields in schema mongodb
I have a summary schema with a structure like this { sender: { type: mongoose.Schema.Types.ObjectId, ref: "User", required: true, }, summary: { type: String, }, sent: { type: Date, default: Date.now, }, } ); then a convo schema: NOTE: summary…
Mongodb – read queries becoming slower the more indexes I add
It seems that the more compound index I add to my collection it gets better to some point and then beyond that the more indexes the slower it becomes. Is this possible? If so why? EDITED: I am referring to…
Update more than one inner document in MongoDb
In my example project, I have employees under manager. Db schema is like this; { "employees": [ { "name": "Adam", "_id": "5ea36b27d7ae560845afb88e", "bananas": "allowed" }, { "name": "Smith", "_id": "5ea36b27d7ae560845afb88f", "bananas": "not-allowed" }, { "name": "John", "_id": "5ea36b27d7ae560845afb88g", "bananas": "not-allowed"…
MongoDB Query: Find documents which match a given value
I have Mongo DB collection which contains items like below: { "_id" : ObjectId("123123123123123123"), "title" : "Item-001", "tags" : [ "red" ], } { "_id" : ObjectId("234234234234234"), "title" : "Item-002", "tags" : [ "red,yellow" ], } Objective: I want to…
Mongodb – Search mongo document based on filter
I need to search documents using mongo query. I am working on fetching documents that have a list of objects. I am using Spring Data Mongo. I am trying to get documents using the condition but getting this error. Due…
Limit number of objects pushed to array in MongoDB aggregation
I've been trying to find a way to limit the number of objects i'm pushing to arrays I'm creating while using "aggregate" on a MongoDB collection. I have a collection of students - each has these relevant keys: class number…
Get Array containing objects to normal object which have value as key in MongoDb result
I have this in [ { "date": "2022-12-03T12:16:52.403Z", "configs": [ { "name": "Shubham", "values": [ { "text": "172cm", "type": "Height", }, { "text": "80kg", "type": "Weight", }, { "text": "male", "type": "Gender", }, ], } ] }, {....},{....} ] Want…