Consider I have the following collection: [ { "total": 48.0, "status": "CO" }, { "total": 11.0, "status": "CA" }, { "total": 15916.0, "status": "PE" } ] I need to realize the difference of PE status - (CO + CA). The…
for your understanding i attached w3school screenshot. enter image description here if u have ever visited w3school website u will understand my requirement easily. i want to create these html sidebar dynamic from my admin dashboard. first i will create…
so i have document for users with this structure in JSON format: [ { "_id": { "$oid": "6369aeb83ce0f8168520f42f" }, "fullname": "Jokona", "password": "$2b$10$MUAe7XIc/xtJTGVh/y1DeuShCARbwxCSejUbHaqIPZfjekNrn0.Yy", "NIK": "MT220047", "status": "active", "department": "Logistic", "position": "Management Trainee", "Group_Shift": "Non Shift", "role": "admin", "createdAt": 1667870392, "updatedAt":…
I am attempting to combine two regex operators when querying my MongoDB, the second of which (id) being a number field, hence the weird conversions. Both of these work individually, and if I replace the $where regex with a more…
When I run it on my local computer I don't get any problem, I encounter this error when I deploy it to Heroku. I don't fully understand the reason. MongoParseError URI malformed, cannot be parsed I just get this on…
I'm developing a site with MERN stack and I want to do all the things with Docker. But I have trouble with connecting to MongoDB with Docker. Here's my docker-compose.yml file. version: "3.7" services: backend: build: context: ./node_backend dockerfile: Dockerfile.dev…
I was working with the MongoDB Atlas Server... and encountered this error... What does it mean...? Can someone explain in simple words plz... This was the query i was trying... db.posts.find({}, {title: 1, date: 0}) The structure of the posts…
If i have two models: Model_1.objects.all() Model_2.objects.all() Model_1 contains all the elements, Model_2 contains a part of these elements. How can i find the elements contained in Model_1 but not in Model_2? I tried: Model_1.objects.exclude(pk=Model_2.objects.order_by('pk')) It doesn't work.
I have the mongo collection like this [ /* 1 */ { "_id" : 1, "data_id" : 1, "data_test" : "sample1", "data_list" : [ "sun" ], } /* 2 */ { "_id" : 2, "data_id" : 1, "data_test" : "sample2",…
I have 3 collections User, Attendance, Detection User collection Document { "_id": "60dd781d4524e6c116e234d2", "workerFirstName": "AMIT", "workerSurname": "SHAH", "workerId": "1001", "locationName": "HEAD OFFICE", "workerDesignation": "IT", "workerDepartment": "IT", }, Attendance Document { "_id": "61307cee85b5055a15cf01b7", "employeeId":"60dd781d4524e6c116e234d2", "Date": "2022-11-01T00:00:00.000Z", "duration": null, "createdAs": "FULL-DAY", "detections":…