I have the collection sessions: [ { "_id": "", "members": [ { "user_id": "11", "joined_at": "2023-06-15T04:50:06.298Z" }, { "user_id": "23", "joined_at": "2023-06-15T04:50:06.298Z" }, { "user_id": "73", "joined_at": "2023-06-15T04:50:06.298Z" } ] }, { "_id": "", "members": [ { "user_id": "59", "joined_at":…
I am trying to make a container where I install Mongo DB server as well as python 3.8 with pymongo module but it does not work. In the dumps folder I am trying to create a backup of tar.gz file…
My aggregate query '$dateDiff': { 'startDate': '$updatedAt', 'endDate': new Date(), 'unit': "hour" } Example: My updatedAt is 10:00 (2023-06-08T10:00:00.502+00:00) and my now is 1:50 (2023-06-08T13:54:00.502+00:00 ) My expected dateDiff is 3 but this is returning me 4. Its rounding off…
I'm running some tests of transform rules for the AWS Database Migration Service (DMS). The source database is MongoDB (I'm using AWS DocumentDB) and the target database is PostgreSQL (I'm using AWS RDS). I'm using "document mode" (as opposed to…
I am new to MERN stack and am trying to create a helpdesk ticketing system for IT department of a company. I want to allow the user to be able to add a new ticket and view all previous tickets…
I have a web site app that generates a simple object with 4 props. It posts to an Azure Serverless Function A. Function A takes the post, and sends it to an Azure PubSub instance running in Azure. I have…
I want to delete 20 collection from MongoDB all in one go. Is there any way or through scripts to delete them all?
I have below aggregate mongo query & want to use mongo count instead of sum to check the performance. collection sample : [ { "rate": 500, "orderDate": 20230101, "username": "Brad" }, { "rate": 20, "orderDate": 20230101, "username": "Lewis" }, {…
I have highly unstructured dynamic data where I have a field that is a multidimensional string array. The exact size of the outer or inner arrays is not known beforehand and can vary. I would like to find all documents…
When I am executing other funcitons like find, add in database then they are running perfectly fine , but when I am updating the database entry then I am getting this error , I am using mongodb atlas, can someone…