aggregation-framework Questions

MongoDB : – $lookup array inside object

November 15, 2022
chirag prajapati
2 Answers

I have 3 collections User, Attendance, Detection User collection Document { "_id": "60dd781d4524e6c116e234d2", "workerFirstName": "AMIT", "workerSurname": "SHAH", "workerId": "1001", "locationName": "HEAD OFFICE", "workerDesignation": "IT", "workerDepartment": "IT", }, Attendance Document { "_id": "61307cee85b5055a15cf01b7", "employeeId":"60dd781d4524e6c116e234d2", "Date": "2022-11-01T00:00:00.000Z", "duration": null, "createdAs": "FULL-DAY", "detections":…

VIEW QUESTION

How do I access variables inside a document in mongodb?

November 13, 2022
steadysteady123
3 Answers

I am trying to do the following questions. Find the ISBN and title of books that was published in 2022. Find the ISBN, title of book and publisher of books that have at least two authors and at most three…

VIEW QUESTION

Project a field based on condition MongoDB

November 11, 2022
Ahmet-Salman
2 Answers

My schema in MongoDB looks like this: { "_id": "be9e9198-86ab-456e-97e1-f1039cb07b59", "isDeleted": false, "user": { "name": "john2", "surname": "doe2", "email": "[email protected]", "phone": "+012345678912", "age": 20, "gender": "male", "nationality": "smth", "universityMajor": "ENGINEERING", "preferences": null, "highPrivacy": false, } (Other stuff) . . .…

VIEW QUESTION

How can I find a value from an array using another object value in MongoDB group aggregation?

November 10, 2022
Zillur Rahman
2 Answers

I have a collection where I want to find one data based on another object data: const data = [ { _id :0, name:"jane", joined : ISODate("2011-03-02"), likes : 30, dislikes: 9}, { _id :1, name: "joe", joined : ISODate("2012-07-02"),…

VIEW QUESTION

How can I populate nested array objects in mongoDB or mongoose?

November 9, 2022
Alex T.
2 Answers

I have an orders collection where each order has the following shape: { "_id": "5252875356f64d6d28000001", "lineItems": [ { productId: 'prod_007', quantity: 3 }, { productId: 'prod_003', quantity: 2 } ] // other fields omitted } I also have a products…

VIEW QUESTION

Mongodb Aggregation :- Get specific fields from $lookup nested array

November 8, 2022
chirag prajapati
3 Answers

I am trying to get specific fields from the array I got after aggregate, lookup and some cond Below you can see my query const attendanceData = await User.aggregate([ { $match: { lastLocationId: Mongoose.Types.ObjectId(typeId), isActive: true, }, }, { $project:…

VIEW QUESTION

MongoDB: Aggregation/Grouping for poll votes

November 3, 2022
Sherif Mo Shalaby
2 Answers

Am trying to create a poll results aggregation I have two collections poll - here is one document { "_id": { "$oid": "636027704f7a15587ef74f26" }, "question": "question 1", "ended": false, "options": [ { "id": "1", "option": "option 1" }, { "id":…

VIEW QUESTION

Mongodb – Mongo Aggregate by multiple props

October 31, 2022
Sergey Lobanov
2 Answers

I need to generate stats from users collection in Mongodb. USER schema: { _id: ObjectId, name: string, city: string, gender: enunm["Male", "Female"], } STATS schema: [ { city: string, Male: number, (number of males in that $city) Female: number, (number…

VIEW QUESTION

Mongodb: check that all the fields of the elements of an array of objects respect a condition

October 30, 2022
Romano
2 Answers

I have a database of a the employees of a company that looks like this: { _id: 7698, name: 'Blake', job: 'manager', manager: 7839, hired: ISODate("1981-05-01T00:00:00.000Z"), salary: 2850, department: {name: 'Sales', location: 'Chicago'}, missions: [ {company: 'Mac Donald', location: 'Chicago'},…

VIEW QUESTION

mongodb. how map strings to integers from another collection

October 28, 2022
MrOldSir
2 Answers

I have collection with documents, for example: [ { 'id':'1' 'some_field':'test', 'rates':[ {'user_id':'12','rate':'very_good'}, {'user_id':'13','rate':'very_good'} {'user_id':'14','rate':'bad'}, {'user_id':'15','rate':'normal'} ] } ] And i have collection with values of rates in string: [ { "rate_name" : "bad", "rate_value" : 1 }, { "rate_name"…

VIEW QUESTION