i am working on a problem where in my database there supposed to be multiple entries from day to day. each entry includes a timestamp. the problem is im supposed to find how many days in each month a data…
Here is my Data in DB { name: abc pro: 1 }, { name:cde, pro: 2 }, { name:fgh, pro:3 }, { name:ijk, pro:4 }, here is my query to aggregate the result I've successfully get the count of name…
I have a collection in MongoDB that looks something like this: [ { "machine": 1, "status": true, "comments": [ { "machine": 1, "status": false, "emp": "158", "comment": "testing the latest update" }, { "machine": 1, "status": false, "emp": "007", "comment":…
Suppose I have this MongoDB document: { "_id": { "$oid": "628f739398580cae9c21b44f" }, "place":"Amsterdam", "events": [ { "eventName": "Event one", "eventText": "Event", "eventDate": "010101" "host":"Bob" }, { "eventName": "E2", "eventText": "e2", "eventDate": "020202" "host":"John" } ] } { "_id": { "$oid":…
I'm using MongoDb with Node.js. And I'm having trouble with aggregation.This is the Example of data in Collection in Database: { "name": "abcdef", "address": ghijk, "reli":"A", "prov:"a" , } { "name": "xyz", "address": "vwz", "reli":"B", "prov:"b" , } { "name":…
I have to sort objects according to value from select option. How I should do this? //This is my select element in another file <select class="form-select" aria-label="Default select example"> <option id="sorting" selected>Sort by</option> <option value="1">Low to High price</option> <option value="2">High…
my code is; ` router.post("/login", async (req, res)=>{ try { const user = await User.findOne({ email: req.body.email }); !user && res.status(401).json("Wrong password or username !"); const bytes = CryptoJS.AES.decrypt(user.password, process.env.SECRET_KEY); const originalPassword= bytes.toString(CryptoJS.enc.Utf8); originalPassword !== req.body.password && res.status(401).json('Wrong Password or…
I am new to Openshift 3.11 deployment, I created a Multistage Dockerfile for a React application, the build want correctly on my local machine, but when I run on the openshift cluster I get the error below: > [email protected] build…
I'm trying to build an express server. In the app.js file I create the server and try to connect to my mongodb. import express from "express"; import dbo from "./db/conn.js"; const app = express(); app.listen(PORT, async () => { await…
I am trying to update ObjectId using mongodb extended json. I am using the below to insert the document. collection.insertMany([{ parentQueryGroupId: { $oid : "628fadb4d370987ac789c0cd" } }]) So it is storing as is like parentQueryGroupId: { $oid : "628fadb4d370987ac789c0cd". But…