I have mongo documents like below, want to perform aggregation to find the errorcodes count for each unique contacts. { "_id": { "$oid": "" }, "campId": "61baef7817cd8ff66518", //camp1 "contactId": "61aa6fbf77490b0007714273", // contact 1 "title": "Happy Holidays!", "communicationType": "EMAIL", "contactedOnTime": {…
compound index { A: 1, B: 1 } In this query, the compound index is not used: db.user.aggregate([ { $match: { B: { $gt: 100 } } }, { $sort: { A: 1 } }, { $limit: 1000 } ])…
I have a document structure like this: [ { "country": "UK", "shops": [ {"city": "London", "fruits": ["banana", "apple"]}, {"city": "Birmingham", "fruits": ["banana", "pineapple"]}, ], }, { "country": "DE", "shops": [ {"city": "Munich", "fruits": ["banana", "strawberry"]}, {"city": "Berlin", "fruits": ["kiwi", "pineapple"]},…
I am having issues with projecting some fields with mongodb $project my colection has the following datas [{num:"SI-0101",mob:6289141515},...] and my $project query [{ $project: { "Id No.": "$num", "Mobile No.": "$mob" // note on that ., i need it in…
I have a Mongo collection as such: db.items.find({}): [{ "_id": { "$oid": "64e929386a2bff904d86118a" }, "name": "Copies", "legacy_id": 181 }, { "_id": { "$oid": "64e929386a2bff904d86118b" }, "name": "Temp", "legacy_id": 182 }, { "_id": { "$oid": "64e929386a2bff904d86118c" }, "name": "Test", "legacy_id": 183…
I'm trying to find all unique strings of some subdocument in MongoDB, as long as at least one of them contains a certain substring. These strings are localized though. I want to have the results for all possible languages. So,…
Please refer the attached image and help me explain this case. Why didn't cova_items column assigned value of InStock column when woo_order_id is null? query command: db.cova_order.aggregate([ { $project:{ InStock:1, woo_order_id:1, woo_order_data:1, cova_items:{ $cond: { if: { $eq:["$woo_order_id",null] }, then:"$InStock"…
Our DB has hundreds of thousands of rows of data where a particular entity amasses points in a certain entry based on certain constraints. Let us call the entities A1, A2…A1000. Let the constraints be X1, X2, X3…Xn. The constraints…
I have the nested fields for many ingredients and would like to add all the corresponding fields nutrients: { vitaminB: { type: Number, default: 0, }, vitaminC: { type: Number, default: 0, }, //more I have the following code Ingredient.aggregate([…
I have a bunch of records in this format on mongodb [ {_id: 1, date:'2023-07-28',sales:1,ad_id:1,status: 'Active'}, {_id: 2 , date:'2023-07-29',sales:2,ad_id:1,status: 'Active'}, {_id: 3, date: '2023-07-30',sales: 4,ad_id:1,status: 'Paused'} ] Now if I want data from date 2023-07-28 to 2023-07-29 . I…