On MongoDB the _Id field for some reason is always very similar, so similar that after 20 documents I cant insert more because the _Id will be the same. What I think is happening is MongoDB generates the _Id based…
I have started the working on transaction concept of database but, I don't know when to use transaction and when we should not? Suppose, If I am running simple SELECT * FROM table_name query. So, Do I have to use…
I have a MongoDB collection which contains some data created by users. I want to get exact time from createdAt filed. Please see the below image. See the createdAt timestamp for a data created on 2023-08-17 22:30:02. I'm building a…
I am creating a user authentication site with mern and I am having problem posting to mongoDB. I have tried many options and the problem persists. It gives lots of error messages. I used nodejs, expressjs and mongodb for configuring…
exports.findByTable = (req, res) => { console.log(req); const table = req.params.table; const text = req.params.text; Employee.find({[req.params.table]: "/.*"+[req.params.text]+".*/i"}) .then(data => { if (!data) res.status(404).send({ message: "Not found Employee with id " +[req.params.text]}); else res.send(data); })`your text` .catch(err => { res .status(500)…
If there are documents with endDate,I want to fetch documents in a collection whose endDate+3 days is less than today through mongo query The below query will find records whose endDate is less then today const myCollection= DB_CONNECTION.collection(TRANSACTION); let expiredTrans…
I'm trying to make a POST request with mongoose in NextJS. I have lib/dbConnect.js, models/User.js, app/new/route.ts. app/new/route.ts is the file for the page with the form, from where we will make a POST request. Here is my lib/dbConnect.js file: import…
so I'm new to MERN Stack and I'm trying to build a booking application wherein I'm using MongoDB Atlas for my database. I'm following a youtube tutorial to learn. I am trying to connect my index.js file to .env file…
db.inventory.aggregate( [ { $lookup: { from: "order", localField: "_id", foreignField: "item_id", as: "inventory_docs" } } ] ) The $lookup is joining based on the item_id field, which is indexed. If 100,000 documents pass through this $lookup, it increased the query…
Is it possible to use a document field to key into an external object in a MongoDB update using aggregation pipeline? Here's the idea with an object that has a single key, my actual use case will be an updateMany…