Hello, I'd like to get all the documents where categories array has an element with key CONSULTANT_AGREEMENT and the respective subCategories array inside the CONSULTANT_AGREEMENT category contains only one element. Is this possible in MongoDB or should I write a…
I am trying to get the last document in a MongoDB collection. The following works in the Mongo shell: db.collection.find().limit(1).sort({$natural:-1}) Results in the last object like so: { "_id" : ObjectId("62c8817075c9400469b1fc3a"), "token" : "135e53ebb05aa2b6055513843cb8e0dca1", "createdAt" : ISODate("2022-07-08T19:11:44.730Z"), "updatedAt" : ISODate("2022-07-08T19:11:44.730Z"),…
i m creating a small shop app with: node.js & express and mongoose and I m facing a problem when I try to send the data to the mongoose database this is my product class const mongoose = require("mongoose"); const…
Suppose I have these documents: [ { _id: 132143124, orders: [true, false, false], }, { _id: 3123, orders: [true, true, true], }, ]; How do I get only the documents that dont have 'false' in their orders array. I need…
i would like to store a post as a document in mongodb. I’m using mongoose for modelling and the content is created by a user using a form. The content of the form is append to FormData and sending to…
I have 2 arrays with different ids : bikesWithNoOrders [id , id1 , id2] filteredResult [id3 , id5] How do I make a query that finds them all I have this : queryBuilder.find({ _id: { $in: bikesWithNoOrders } }); queryBuilder.find({…
On a NodeJs application, I've a snippet which: - check if an element exist (1 query) - if present, update some value of it (1 query) - else, add a new record (1 query) and delete an older one (1…
I am currently using Nest's SchemaFactory to setup my MongoDB models. Here is a link to their documentation: https://docs.nestjs.com/techniques/mongodb#mongo I was wondering how I could set a TTL index using this abstraction. I want every instance of a specific model…
This is my code in userController.js const registerUser = asyncHandler(async (req, res) => { const {name, email, password, phoneNumber} = req.body if(!name || !email || !password || !phoneNumber) { res.status(400) throw new Error('Please add all fields') } res.json({ message: 'Register…
I am storing a parking detail with a merchant id in the mongoose schema since a parking belongs to a certain merchant user and it cannot be empty or null. Here is the model: const parkingSchema = new mongoose.Schema({ merchantId:…