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…
There're hundreds of items and each item contains comments. Each comment contains author, content, likes, replies. Since each item is likely to have hundreds of comments, I embedded comment's id into sub-array inside item document. const itemSchema = new mongoose.Schema(…
I have a question about the decimal support. I want to work with decimals and I know Mongo suggests to use Decimal128 type. It solves the rounding format on db but on the other hand I need to write decimal(BSON)…