I have a collection in mongo having nested embedded fields. How do I get operate on a field that are within another embedded field. Here is a sample from my collection. I have to find Q: Display the baseFare for…
Below is a block from my aggregate query, { $addFields: { destinations: { $filter: { input: "$destinations", cond: { $and: [ { $or: [ { "$$this.reported_at": { $exists: false } }, { "$$this.reported_at": { $eq: null } } ], },…
I have a MongoDB collection like this: [ { "_id": 1, "price": 1 }, { "_id": 2, "price": 2 }, { "_id": 3, "price": 3 }, { "_id": 4, "price": 4 }, { "_id": 5, "price": 5 }, { "_id":…
We are using MongoDB for a POC and I am stuck with below problem. We are building a page to show filter options for data. If user selects any filter, then data needs to be filtered as per selection. If…
Companies [ { _id: 1, name: "Apple" }, { _id: 2, name: "Microsoft" }, { _id: 3, name: "Facebook" }, { _id: 4, name: "Tesla" } ] Is there a way to show name filed in query to new format?…
I am doing the project using MERN stack. So I have compiled the code successfully by running npm start on both client side and server side. It will open http://localhost:3000/ when I fill the data and click on submit. It…
Is there any better way to write this query? { $facet: { results: [ { $match: { $expr: { $and: [{ $gte: ["$var1", 1] }, { $gte: ["$var2", 200] }], }, }, }, { $sort: { var1: 1 } },…
I'm sure this issue has been discovered and figured out before, but I'm having trouble with it so please be gentle. I'm self-teaching React/Node and decided to make a MERN CRUD system. I'm having issue with the update portion of…
I am trying to store in mongodb a uuid type 4 but when I call the InsertOne function this is storing my uuid as type 0 (generic) and not type 4. I don't know exactly what I am doing wrong.…
I need a little help. I've a collection which has a field dimension and that field contains array of different objects, which looks like this Collection - 1: [ { "_id": { "$oid": "6423cddbf4db0d397b22390a" }, "dimension": [ { "_id": {…