I am having 2 collections - Collection name is content Collection name is surveys I actually want to add the "type" information from the content collection to every content in every survey in the "surveys" collection. I know in SQL…
So what I want to do is group all documents having same hash whose count is more than 1 and only keep the oldest record according to startDate My db structure is as follows: [{ "_id": "82bacef1915f4a75e6a18406", "Hash": "cdb3d507734383260b1d26bd3edcdfac", "duration":…
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": {…
We have a demo site with some static data that keeps aging off and I'd like to run a mongo query to shift the dates by 30 days. Here is an example of the data. Using mongodb 4.4.3 { "_id"…
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…
My MongoDB database is very large (about 10 million items using 1000 MB of disk space), but it's documents do not have a slug based on the title. Currently a document looks like this: { "_id": { "$oid": "630f3c32c1a580642a9ff4a0" },…
I have a collection that have a field named "data" that can have any fields, and I have to get all existing fields in all collections in that "data" field or get the documents that have diferents fields in that…
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…
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…