I am trying to do a lookup from multiple references Here is a Mongo Playground Here is my data Insp The Insp document contains an array of references to Users (by user ID) [ { "_id": { "$oid": "6359a12fb9450da3d8d8cdd2" },…
I have a nested array, I have to remove the one object , based upon the condition using aggregation here is the JSON I get from mongodb { "_id": "633d275ceb34a28755974032", "name": "free", "products": [ { "title": "Product 1", "phone": […
I have the following aggregation pipeline running in the latest version of mongoDB and pymongo: [ { "$project": { "union": { "$setUnion": [ "$query_a", "$query_b" ] } } }, { "$unwind": "$union" }, { "$group": { "_id": "$union.ID", "date_a": {…
Employee has multiple employeeActions, the employeeActions data looks like this: [ { "email": "[email protected]", "companyRegNo": 105, "event": { "created": ISODate("2022-09-16T06:42:04.387Z"), "desc": "COMPLETED_APPLICATIONS", "note": "Direct apply" } }, { "email": "[email protected]", "companyRegNo": 105, "event": { "created": ISODate("2022-09-20T06:42:42.761Z"), "desc": "ASKED_TO_REVIEW", } },…
I want to find the rate of negative and zero profits from a column. I tried to do it using aggregate and subquery but it doesn't seem to work as both method return 0 values. The code is as follows…
I have a couple of tables where I'm applying inner join to fetch matching rows: event (id, url, name, eventStart, eventEnd)` slot (id, event_id date, start_time, end_time, location_type, location_id)` Query: select * from event as evnt inner join slot as…
I'm a bit confused on how to group using aggregation but still be able to extract specific values from arrays: db.collection.aggregate([ { "$unwind": f"${stat_type}" }, { "$group": { "_id": "$userId", "value" : { "$max" : f"${stat_type}.stat_value" }, "character" : f"${stat_type}.character_name",…
I was wondering if it was possible to somehow use the $match operator within the $sum function for aggregation. { "$unwind": "$info.avatarInfoList" }, { "$unwind": "$info.avatarInfoList.equipList" }, { "$unwind": "$info.avatarInfoList.equipList.flat.reliquarySubstats" }, { "$project": { "name" : "$name", "character" : "$info.avatarInfoList.avatarId",…
I have the following document type: { "_id": 1, "_a": [ { "_aId": { "CC": "CA" }, "_p": [ { "_pId": { "CC": "CA", "SN": 1 }, "s": { "c": { "t": [ { "sId": 1, "language": "CA", "format": "A4"…
I have two mongodb aggregate query as shown below. The below query gives me the count of total failed and the sectionType db.Departments.aggregate([ { $match: {$and: [{"subject.failed": {$eq: 'true'}}, {"section": {$eq: 'A'}}]} }, { $group: { _id: {"sectionType": "$sectionType"}, "COUNT(*)":…