Comparing two different fields in mongoDB
How to compare two properties in MongoDB, I want to find and delete all those rows where "income per annum" is greater than "savings per annum"??
MongoDB Match Negative All
Mongo Playground Lets say I have docs with 3 props, FieldA, B, C. I would like to do a match of all docs that don´t have the 3 props null. I am trying $all, $nor, $not, $ne, etc... but none…
Mongodb – How do i group my list off stories by user details
so here is my stories model, const storySchema = new mongoose.Schema( { avatar: { type: String, default: null }, handle: { type: String, default: null }, new: { type: Boolean, default: true }, isLive: {type: Boolean, default: false}, url: {…
Mongodb – access data and run jobs using same application, is it a good practice?
I have a spring boot application that I use to access and fetch a MongoDB database, this application use also a JobRuner solotion to run some ETL jobs and write their results in the same Mongodb database, furthermore this application…
Mongoose/MongoDB: Get all records per day
I've tried all solutions I could find on here, but I am still coming up with 0 records and not sure why! Scenario: Get call records for each day. Output total calls for each day The code: const startOfMonth =…
Mongodb – Nodejs mongoose get results from multiple collections in one query
I'm very new to Nodejs and MongoDB, I have 3 collections one for chapter,one for lecture and one for asset every course have chapters, every chapter has array of lectures and every lecture have assets so I want to get…
Keeping duplicated data with MongoDB find
I have a cart collection, which can have the same product with different variants. The problem is when I fetch the user cart and query for all those ids, when theres a duplicated one MongoDB is not including it in…
Mongodb finding docs with specific value that also excluded a field value
I have a large collection I'm searching through on mongodb. (Supports PCRE v8.42) Let's say I'm trying to find where "comment" contains "alpha bravo" where the field value of "name" doesn't immediately follow In other words, match $regex: "alpha bravo…
Mongodb – how can i compare two arrays from my data json?
hello how can i compare two arrays one from my data json and the second from a array ? i need to know if the ids of "cm:taggable" exist in my secondArray JSON { "entry": { "isFile": true, "createdByUser": {…
How do I fetch data out of mongodb out of an async function?
I am relatively new to JavaScript and especially new to promise. I am struggling to get the second console.log() to output the same as the first one. Is this even possible? Do I have to do all of my code…