I am trying to follow the onlinecodeacademy online course for free to learn MERN. I am having trouble both using npx and installing it. When I try to install npx I receive the following errors: [noah@Qyain restaurant-reviews]$ npm install npx…
I have two mongodb aggregate query as shown below. The below query gives me the count of total failed and the sectionType db.Departments.aggregate([ { $match: {$and: [{"subject.failed": {$eq: 'true'}}, {"section": {$eq: 'A'}}]} }, { $group: { _id: {"sectionType": "$sectionType"}, "COUNT(*)":…
I'm trying to learn mongodb + springboot and I met issue like this: When I'm using application.properties file to config the connection, then everything seems to be fine. config below: spring.data.mongodb.username= root spring.data.mongodb.password= example spring.data.mongodb.database= database spring.data.mongodb.port= 27017 spring.data.mongodb.host= localhost…
I have a question on merging arrays into one array in same field, but they are in different objects. I hope you will understand what I wanted after looking at the code below. db.addresses.find().pretty() { "_id" : ObjectId("62a72be40c7db0af0b79d721"), "rollingStockNumber" :…
so I'm making a message count command with discord.js and MongoDB but the "messageCount" value just never gets created. I searched it up and looked at docs but I couldn't find what was wrong. Codes: message-counter.js file: const mongo =…
How to check if a field is not existing inside lookup expression? The answers in similar questions are not helpful (e.g. {$eq : null} or $exists:true). For example, I want to lookup inventory only if disabled is not existing. db.orders.aggregate([…
I'm using mongo watch() to subscribe to change stream events. I've noticed that the change stream events automatically stopped without throwing any specific error and become idle. Then have to restart the server to listen to the change stream again.…
I know I can group data inside a collection by { $group: { _id: { day: { $dayOfMonth: '$timeplay' }, month: { $month: '$timeplay' }, year: { $year: '$timeplay' } }, listeners: { $sum: '$count' } } However, it does…
I have a form here with the delete method being used: <form action="/article/<%= articles[i]._id %>" method="DELETE"><button class="btn btn-danger" type="submit">Delete</button></form> Then my routes for the article ID's look like this: const articleById = require('../controllers/article/articleById') router.get('/:id', articleById) const deleteArticleById = require('../controllers/article/deleteArticleById') router.delete('/:id',…
I have "bank account" documents in a collection "economy" for a game in this format: _id: ObjectId("62a5c5d741c1059e0f498c2c") guild: 98525515134318336 user: 595415131438508070 balance: 156 bank: 100 I want to sort all of the documents that have the same guild value by…