Why are the street and city fields not present in the address sub-document of a new user document created using Mongoose, despite being included in the addressSchema and provided when creating the document? Here is my addressSchema: const addressSchema =…
I am trying to simply console.log the output of the mongoose function model.find() I am using node.js version 18.14.0, "express": "^4.18.2", "mongoose": "^7.0.0", I have the following issues: model.find no longer accepts callbacks, so I tried to create a variable…
I've encountered a problem while setting up mongoose. Here is my code: const { SlashCommandBuilder } = require('@discordjs/builders'); const testSchema = require(`../../Schemas.js/test`); module.exports = { data: new SlashCommandBuilder() .setName('dbtest') .setDescription('db test'), async execute(interaction) { testSchema.findOne({ GuildID: interaction.guild.id, UserID: interaction.user.id}, async(err,…
I am trying to copy a million document in a collection to another colletion. > db.source_collection.find().forEach(function(doc) { db.dest_collection.insertOne(doc)}); This works fine. but I wonder it might cause any trouble to operating Database if I loop a million documents. Can I…
I have a collection named employees with documents like. { first_name:"john", last_name:"doe" } I want to run an update query which adds a new field like {name:'john doe'} I know it can be done like this db.employees.find({}).forEach(doc=>db.employees.update({"_id":doc._id},{$set:{name:doc.first_name+"-"+doc.last_name}})) but its taking…
Given the following dataset: category date amount fruit 2023-01-01 1 fruit 2023-01-02 2 meat 2023-01-03 3 nuts 2023-01-04 4 nuts 2023-01-05 5 nuts 2023-01-06 6 Is it possible to do a multi-group aggregation in Mongo JPA that yields: One row…
all! I'm working on a project with MongoDB and Spring Boot. I want to implement a feature so that once I start running the server, there will be a fixed item (or file) stored in the collection of the MongoDB…
I am trying to sum values from different objects. Each object has its ID, but the IDs can repeat in some objects. What I need to do now is sum the values from the objects that have the same ID.…
I have the problem where I need to modify a specific field of a object that is located in a array, but I would need to filter out the object within another array to get that specific object. For example,…
Please, help , I need to find count() of all _a[]._p[] elements having at least one of: _a[]._p[].s.d.t[].dateP=2022 and _a[]._p[].s.d.t[].tF="N" and _a[]._p[].s.c.t[].dateP=2022 and _a[]._p[].s.c.t[].tF="N" in following type of document: { "_id": ObjectId("5c05984246a0201286d4b57a"), f: "x", "_a": [ { "_p": [ {…