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": {…
I have the following project: { '$project': { '_id': 1, 'applicationIds': { 'type': 'linux', 'refId': '$applicationIds' }, 'configurationIds': { 'type': 'linux', 'refId': '$configurationIds' } } } As long as there is at least one record in $configurationIds I will get…
I have this attendance data for a particular student. If he was present then marked 1 else marked 0 in the respected subject. How I can calculate the total attendance out of it. Please help me out... { "CGMM": {…
I want to find the max and min values of the myUpdateTime field. It's a timestamp but stored as a string. "myUpdateTime": "2021-11-08T17:42:30.650Z",