I have this pipeline : let pipeline = [ { $match: { date: { $gte: new Date("2022-10-19"), $lte: new Date("2022-10-26") }, }, }, { $group: { _id: "$date", tasks: { $push: "$$ROOT" }, }, }, { $sort: { _id: -1…
i want to search a date like the following: 09-11 03-22 and it will search in the available documents and bring the matched documnet. an available document example : 2022-09-11T15:31:25.083+00:00 how can i do this? i tried following query but…
Here is my Controller const getCountofCenters = async (req, res) => { const result = Center.countDocuments(); await result.then(() => res.status(200).send(result)) .catch((err) => { res.status(200).send(err) }); } This is the Api call router.get("/count", CenterController.getCountofCenters); This is the output which I get…
const mongoose = require("mongoose"); mongoose.connect("mongodb://localhost:27017/fruitsDB", {useNewUrlParser: true}); const fruitSchema = new mongoose.Schema ({ name: String, rating: Number, review: String }); const Fruit = mongoose.model("Fruit", fruitSchema); Fruit.find((err, fruits) => { if (err) { console.log(err); } else { fruits.forEach((fruit) => console.log(fruit.name)); };…
exports.postDeleteProduct = (req, res, next) => { const userId = req.body.userId; User.deleteOne({ _id: userId, userId: req.session.userAuth._id }) .then(() => { console.log("DESTROYED PRODUCT"); //process reaching here whether the above deleteOne happens or not res.redirect("/users"); }) .catch((err) => console.log(err)); }; Also, the…
Linux MInt 21, I try to instal MongoDB for like 3 days but apparently I'm not doing something right. I would greatly appreciate it if you could tell me what I am doing wrong :)) I post what i did…
I have products model like this const productSchema = new mongoose.Schema({ categories:{ type: mongoose.Schema.Types.ObjectId, ref: 'Category' } }) and category model const productSchema = new mongoose.Schema({ title: { type: String, required: true } }) now I wanna Filter Products by…
Trying to return this document from a collection by checking if a variable (userId) matches the second element in users array. I created a playground. Expected result is the user document xyz as thats the only user who liked rrr…
I have a long array of docs to create. When I create them I get no errors. const docsJson =[some array of json of docs to create] const orders = await MySchema.create(ordersJSON); // orders.length returns the same number of docs…
i have a payload { "category": "Mobile", "price": { "from": "10", "to": "50" }, "location": [ "Jakrta", "Bandung", "Surabaya" ], "rating": [ "1", "2", "3" ] } i want to find all object which have rating 1 or 2 or…