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)…
Please refer the attached image and help me explain this case. Why didn't cova_items column assigned value of InStock column when woo_order_id is null? query command: db.cova_order.aggregate([ { $project:{ InStock:1, woo_order_id:1, woo_order_data:1, cova_items:{ $cond: { if: { $eq:["$woo_order_id",null] }, then:"$InStock"…
I have following data in my collection { “name": “test”, "data": { “statusOne”: “enabled”, “statusTwo”: “active” } } { “name": “test”, "data": { “statusOne”: “disabled”, “statusTwo”: “active” } } { “name": “another-test”, "data": { “statusOne”: “disabled”, “statusTwo”: “active” } }…
Below is my code to save data in a mongodb const mongoose = require('mongoose') const sampleschema = new mongoose.Schema( { name:{ type:String }, age:{ type:Number } }, {collection :"Sample_collection"} ) const samplemodel = mongoose.model('sample_coll',sampleschema) const add = async () =>…
I am trying to search my MongoDB of products. The dataset has multiple of each product to record price over time. I would like to search for a phrase then limit the results to 1 of each UPC. My current…
Thanks for your valuable attention, I'm working on MERN stack & trying to do something that's not working like I am expecting it to be.(Sorry if this turns out to be a repeated question, I'm new to web dev). Here…
I have a problem with my database. I frequently (several time a day) have crash during queries. It throws this error: PoolClearedError [MongoPoolClearedError]: Connection pool for db2.prod.someDomain.com:27017 was cleared because another operation failed with: "connection <monitor> to [ip:v6:add:ress::]:27017 timed out"…
I have below 3 sample records: { "_id" : "0cc5c468-2105-11ee-ad68-15d467e62by4d", "storeId" : "3070", "paymentType" : "cash", "total" : {"$numberDecimal": "100"} }, { "_id" : "1111111-2105-11ee-ad68-15d467e62by4d", "storeId" : "3070", "paymentType" : "cash", "total" : {"$numberDecimal": "100"} }, { "_id" : "0cc5c468-2105-11ee-ad68-15d467e62by4d",…
i am getting an error like below and i tried to google it but i can't fix it i am using bcryptjs library to encrypt password but it is not able to encrypt and send to sever Error type error…