I have MongoDB model called candidates appliedJobs: [ { job: { type: Schema.ObjectId, ref: "JobPost" }, date:Date }, ], candidate may have multiple records in appliedJobs array. There I refer to the jobPost. jobPost has the companyName, property. companyName: String,…
I have a document from mongo database looking like this: { "_id": "00000001", "category": "Weather", "city": "Salt Lake City", "date": { "$date": { "$numberLong": "1663236000000" } }, "logs": { "2022-09-14 12:00:00": { "temp": 55, "humidity": 25 }, "2022-09-14 14:00:00": {…
I'm trying to find Users who logged in the last day. The userActivity field is an object on User. The userActivity object contains a field called hourly which is an array of dates. I want the find any users who's…
Suppose a collection contains the following 3 documents: [ { "_id": 1, "prop": 1 }, { "_id": 2, "prop": 4 }, { "_id": 3, "prop": [1, 2, 3] } ] The query { $match: { prop: 1 } } returns…
I have grouped all the users by country, but I would also like to have a row showing the grand total (users are tagged to a single country in our use case). Data Model / Sample Input The collection is…
Documents { color: 'red', value: { red: { level1: { level2: 5 }}}} { color: 'blue', value: { blue: { level1: { level2: 8 }}}} How to aggregate the values of value.red.level1.level2 and value.blue.level1.level2? The keys red and blue come…
I would like to check if a field is not present in an array of objects. Let's say I have an array inside documents called attributes: [ { attributes: [ { name: "Cool", value: true } ] } ] And…
I have data saved in db as follow: collection name: movies: [ {id:1, name:"abch", start:"12:00 pm", end:"03:00 pm"}, {id:2, name:"Annabelle", start:"08:30 am", end:"10:00 am"}, {id:3, name:"Spider Man homecoming", start:"11:30 am", end:"03:00 pm"}, {id:4, name:"Grudge", start:"10:00 pm", end"00:00 am"} ] I…
So I have a collection called Cars that have some fields that are the same, but I want to be able to only get one of the documents based on that field. [ { _id:'12345', model:'Honda' }, { _id:'12346', model:'Honda'…
I need to get total count of objects in the "photo" array field, and compare it to the value in "mls_media_count" field, so that I can detect when the values do not match. open_houses:null open_houses_lock:false photos:Array 0:Object 1:Object 2:Object 3:Object…