I have this data in MongoDB. { _id: "abc*hello*today*123", "value": 123 }, { _id: "abc*hello*today*999", "value": 999 }, { _id: "xyz*hello*tomorrow*123", "value": 123 } What I want is to group by the first part before "*{number}". This is what I…
I'm still learning MongoDB and I'm having a difficulty on my current problem. How can I get the most used category in collection, so in this JSON, my most used category is CIES. so what I want to do is…
I am am using ansible to add admin user in mongodb.. I used below playbook but i am getting error. Can someone suggest the solution.. i have also installed pymongo prior to adding user in order to use module. authentication…
We have a Typescript based NodeJs project that makes use of Mongoose. We are trying to find an appropriate way to define an enum field on a Mongoose schema, based on a Typescript enum. Taking an example enum: enum StatusType…
I am using prisma with mongoDb for the first time and I want to update a boolean value stored in a collection, but I am not able to find a way/query to update the value from true to false or…
I have a project with this directory structure: - other-service/ - my-service/ src/ Dockerfile .env docker-compose .env I have defined my mongoDB container & service container in a docker-compose.yml file like below: version: "3" services: my-service: depends_on: - mongodb env_file:…
I have an array of objects in my company collection holding grouped values as follows: "groups" : [ { "id" : "d278c44333", "name" : "group 1" } ], so in mongoDB it would be company > groups > 0 >…
In MongoDB (using mongosh or command-line mongo cli), you can query documents, for example using db.mycollection.find({"something":true}) and get the following result: { "someDate": ISODate("2022-10-24T17:21:44.980Z"), "something": true, "hello": "world" } This result, however, is not valid JSON (Due to ISODate). How…
I'm trying to join or call only one document from multiple documents that can be repeated, all this for a unique identifier, in this case code, which is a numerical value. [ { "_id": "6386b0e114fe6aee844af06e", "transfer": { "code": 2, "author":…
I am trying to get data from the db into node js but getting error . I have got the data from the frontend and stored it in the backend but when I try to get the stored data I…