Lets say I have an array ['123', '456', '789'] I want to Aggregate and look through every document with the field books and only return the values that are NOT in any documents. For example if '123' is in a…
I have the following documents: _id: "Team 1" count: 1200 _id: "Team 2" count: 1170 _id: "Team 3" count: 1006 _id: "Team 4" count: 932 _id: "Team 5" count: 931 _id: "Team 6" count: 899 _id: "Team 7" count: 895…
I want to exclude for example email and address using populate() function from mongodb, just get the name from it: Example: const results = await Seller.aggregate(aggregatePipeline).exec(); const sellers = await Seller.populate(results, { path: "user" }); When populating the user instead…
I have one data example like this one in MongoDB. { id: 628a8683fc489c315b330ade, examName : 'Final Exam', schedule: { scheduleDate : '2021-10-18T17:00:00.000+00:00' scheduleName : 'Package Test' package:[ { exclude_question:[1,2], namePackage:testing packageId:628a89c2fc489c315b330b01 } ] }, question:[ { id:1, question:'hello can u…
I have this type of MongoDB collection { "uploaded_video": [ { "_id": "622a03e66d59f72b72358069", "user_id": "Ec3FNhk45Lh1xk92cO9eoXDiWEk2", "uploaded_video": { "_id": "622a0616242e5b2e65e8b3b4", "video_description": "test", "created_At": "2022-03-10T14:05:29.000Z", "recordedVideo": false, "thumbnailCreated": true }, "activityType": "uploaded_video" } ], "comment_video": [ { "_id": "622a03e66d59f72b72358069", "user_id": "Ec3FNhk45Lh1xk92cO9eoXDiWEk2", "comment_video":…
I'm working with this query: customers.aggregate: [ {$lookup: { from: "users", localField: "_id", foreignField: "customerId", as: "users" }}, {$lookup: { from: "templates", let: {localField: "$_id"}, pipeline: [{ $match: { $and: [{ $expr: { $eq: ["$customerId", "$$localField"]}}, {module: false}] }}], as:…
I have a collection like this: { '_id' : ObjectId('6251f8556e75125f9260f333'), 'name': 'jojo', 'profile': 'jojo profile', 'date': ISODate("2022-04-09T21:18:40.473Z"), 'look': [ { 'art': 'group-id', 'data': 'alma', 'dt': '1'}, { 'art': 'called', 'data': 'central', 'dt': '1'}, { 'art': 'access-time', 'data': 108000, 'dt': '1'}…
I want to sort data based on date and the createdFor property. I want the sum of the data in group of createdFor and all specifc itemName for each createdFor. date = [Tue Apr 05 2022 11:10:41 GMT-0400 (Eastern Daylight…
I have following json data in mongodb. [ { "_id": 1, "name": "user1", "userActivities": [ { "actionTaken": "Sign in.", "progress": "Success." }, { "actionTaken": "logout", "progress": "Success." } ] }, { "_id": 2, "name": "user2", "userActivities": [ { "actionTaken": "Sign…
I have a collection: { "_id": 1, "_deleted": false, "customFields": [{ "fieldName": "sapID", "value": "" }, { "fieldName": "salesTerritory", "value": "" }, { "fieldName": "clientType", "value": "Corporate" }], } How can I project(aggregate) only the value field of the element…