thiscodeWorks - Organizing the best of code online

List view

#aggregation #mongodb #map #filter #size

[
    {
        "$match": {
            "authorization": {
                "$ne": null
            }
        }
    },
    {
        "$match": {
            "email": {
                "$not": {
                    "$regularExpression": {
                        "pattern": "deleted",
                        "options": ""
                    }
                }
            }
        }
    },
 
    {
        "$lookup": {
            "from": "participant",
            "localField": "email",
            "foreignField": "email",
            "as": "userParticipant"
        }
    },
    {
        "$match": {}
    },
    {
        "$lookup": {
            "from": "masterSlot",
            "localField": "userParticipant._id",
            "foreignField": "navigatorId",
            "as": "slots"
        }
    },
    {
        "$lookup": {
            "from": "userCoachMapping",
            "localField": "userParticipant._id",
            "foreignField": "coachID",
            "as": "userCoachMapping"
        }
    },
    {
        "$project": {
        
            "isCoachActive": {
                "$arrayElemAt": [
                    "$userParticipant.active",
                    0
                ]
            },
        
            "email": {
                "$arrayElemAt": [
                    "$userParticipant.email",
                    0
                ]
            },
            "firstName": {
                "$arrayElemAt": [
                    "$userParticipant.firstName",
                    0
                ]
            },
            "coachProfileDescription": {
                "$arrayElemAt": [
                    "$userParticipant.coachProfileDescription",
                    0
                ]
            },
    
            "middleName": {
                "$arrayElemAt": [
                    "$userParticipant.middleName",
                    0
                ]
            },
            "lastName": {
                "$arrayElemAt": [
                    "$userParticipant.lastName",
                    0
                ]
            },
            "partnerShortCode": {
                "$arrayElemAt": [
                    "$userParticipant.partnerShortCode",
                    0
                ]
            },
    
            "role": {
                "$arrayElemAt": [
                    "$userParticipant.role",
                    0
                ]
            },
            "templateName": "$authorization.name",
            "servicePartnerShortCode": "$servicePartnerShortCode",
            "userVisibility": "$userVisibility",
    
            "Total Users": {
                "$size": {
                    "$filter": {
                        "input": "$userCoachMapping",
                        "as": "coach",
                        "cond": { "$eq": ["$$coach.userStatus", "ACTIVE"] }
                    }
                }
            }
            _id:0
        }
    },
    {
        $match:{
            "Total Users": { "$gt": 0 }
        }
    }
]

#aggregation #mongodb #date #map #filter

Map and filter on some conditoin

[
    {
        "$match": {
            "startDate": {
                "$gte": {
                    "$date": "2018-03-12T03:26:21.997Z"
                },
                "$lte": {
                    "$date": "2024-03-10T04:50:35Z"
                }
            }
        }
    },
    {
        "$lookup": {
            "from": "participant",
            "localField": "userId",
            "foreignField": "_id",
            "as": "participantData"
        }
    },
    {
        "$unwind": "$participantData"
    },
    {
        "$match": {
            "participantData.email": {
                "$regularExpression": {
                    "pattern": "@jiva.user",
                    "options": ""
                }
            }
        }
    },
    {
        "$match": {
            "participantData.userStatus": {
                "$ne": "TEST"
            }
        }
    },
    {
        "$match": {
            "$and": [
                {
                    "participantData.email": {
                        "$not": {
                            "$regularExpression": {
                                "pattern": "deleted",
                                "options": ""
                            }
                        }
                    }
                },
                {
                    "participantData.email": {
                        "$not": {
                            "$regularExpression": {
                                "pattern": "@smit\\.fit$",
                                "options": ""
                            }
                        }
                    }
                }
            ]
        }
    },
    {
        "$lookup": {
            "from": "participantBaselineAndFollowupData",
            "localField": "userId",
            "foreignField": "participantId",
            "as": "baselineData"
        }
    },
    {
        "$unwind": "$baselineData"
    },
    {
        "$lookup": {
            "from": "blood_glucose",
            "localField": "userId",
            "foreignField": "participantId",
            "as": "glucoseData"
        }
    },
    {
        "$unwind": "$glucoseData\", \"preserveNullAndEmptyArrays\" : true}"
    },
    {
        "$project": {
            "subscriptionId": "$_id",
            "baselineId": "$baselineData._id",
            "userId": 1,
            "startDate": 1,
            "programStartDate": "$baselineData.programStartDate",
            "planCode1": "$subscriptionPlan.programCode",
            "journeyStatus": "$journeyTrackerObject.status",
            "planCode2": "$baselineData.programCode",
            "followUps": "$baselineData.followUps",
            "glucoseData": 1
        }
    },
    {
        "$match": {
            "$and": [
                {
                    "$expr": {
                        "$and": [
                            {
                                "$eq": [
                                    "$planCode1",
                                    "$planCode2"
                                ]
                            },
                            {
                                "$eq": [
                                    "$startDate",
                                    "$programStartDate"
                                ]
                            }
                        ]
                    }
                }
            ]
        }
    },
    {
        "$group": {
            "_id": {
                "userId": "$userId",
                "startDate": "$startDate",
                "planCode1": "$planCode1"
            },
            "userId": {
                "$last": "$userId"
            },
            "baselineId": {
                "$last": "$baselineId"
            },
            "startDate": {
                "$last": "$startDate"
            },
            "programStartDate": {
                "$last": "$programStartDate"
            },
            "subscriptionId": {
                "$last": "$subscriptionId"
            },
            "journeyStatus": {
                "$last": "$journeyStatus"
            },
            "followUps": {
                "$last": "$followUps"
            },
            "glucoseData": {
                "$push": "$glucoseData"
            }
        }
    },
    {
        "$project": {
            "userId": 1,
            "baselineId": 1,
            "startDate": 1,
            "programStartDate": 1,
            "subscriptionId": 1,
            "journeyStatus": 1,
            "followUps": 1,
            "field": {
                "$add": [
                    "$_id.startDate",
                    {
                        "$multiply": [
                            14,
                            24,
                            60,
                            60,
                            1000
                        ]
                    }
                ]
            },
            "glucoseData": {
                "$filter": {
                    "input": "$glucoseData",
                    "as": "glucose",
                    "cond": {
                        "$and": [
                            {
                                "$lt": [
                                    "$$glucose.date",
                                    {
                                        "$add": [
                                            "$_id.startDate",
                                            {
                                                "$multiply": [
                                                    14,
                                                    24,
                                                    60,
                                                    60,
                                                    1000
                                                ]
                                            }
                                        ]
                                    }
                                ]
                            },
                            {
                                "$gte": [
                                    "$$glucose.date",
                                    "$_id.startDate"
                                ]
                            }
                        ]
                    }
                }
            }
        }
    },
    {
        "$project": {
            "userId": 1,
            "baselineId": 1,
            "startDate": 1,
            "programStartDate": 1,
            "subscriptionId": 1,
            "journeyStatus": 1,
            "followUps": 1,
            "glucoseData": {
                "$map": {
                    "input": "$glucoseData",
                    "as": "obj",
                    "in": {
                        "participantId": "$$obj.participantId",
                        "reading": "$$obj.reading",
                        "date": "$$obj.date"
                    }
                }
            }
        }
    }
]

#aggregation #mongodb #date

Date (addition) mongodb

[
    {
        "$match": {
            "participantId": ObjectId("6481b5f27050063532a46021")
        }
    },
    {
        "$match": {
            "date": { "$gt": { "$add": [ISODate("2023-06-01T00:00:00.000Z"), { "$multiply": [14, 24, 60, 60, 1000] }] } }
        }
    }
]

#aggregation #mongodb #arrayfilter #array

meal plan updation/ updating object fileds insided array in mongodb

db.participantDietMealPlanDetails.updateMany({
    "mealPlan.dishVariation": "Milkshake",
	"_id":ObjectId("60d4258c4adb9a4b6fe4d99b")
},
    {
    $set: {
        "mealPlan.$[elem].dishVariation": "Milkshake",
        "mealPlan.$[elem].dishVariationId":  "660ea659e1645e032a289770",
        "mealPlan.$[elem].sizes": [{
                "calories": {
                    "value": "184",
                    "unit": "kcal"
                },
                "cookedWeight": "200",
                "name": "Medium Glass",
                "fat": {
                    "value": "5.0",
                    "unit": "gms"
                },
                "calcium": {
                    "value": "0.0",
                    "unit": "mg"
                },
                "iron": {
                    "value": "0.0",
                    "unit": "mg"
                },
                "fibre": {
                    "value": "0.0",
                    "unit": "mg"
                },
                "sodium": {
                    "value": "0.0",
                    "unit": "mg"
                },
                "sugars": {
                    "value": "0.0",
                    "unit": "mg"
                },
                "protein": {
                    "value": "4.7",
                    "unit": "gms"
                },
                "carbs": {
                    "value": "30.4",
                    "unit": "gms"
                }
            }
        ]

    }
}, {
    arrayFilters: [{
            "elem.dishVariation": "Milkshake"
        }
    ]
})

#aggregation #mongodb #$push #exp

Expression

[
    {
        "$match": {
            "$expr": {
                "$ne": ["$foodStatus", "APPROVED"]
            }
        }
    },
    {
        "$lookup": {
            "from": "mastermealplan",
            "localField": "dishVariation",
            "foreignField": "mealPlan.dishVariation",
            "as": "mealData"
        }
    },
    {
        "$match": {
            "$expr": {
                "$gt": [{ "$size": "$mealData" }, 0]
            }
        }
    },
    {
        "$project": {
            "mealData": "$mealData.planName",
            "dishVariation": 1
        }
    }
]

#aggregation #mongodb #$push

$push operator in mongodb

[
    {
        "$match": {
            "partnerShortCode": {
                "$in": []
            }
        }
    },
    {
        "$group": {
            "_id": "$partnerShortCode",
            "clinics": {
                "$push": {
                    "clinicName": "$name",
                    "clinicId": "$_id"
                }
            }
        }
    },
    {
        "$project": {
            _id:0,
            "partnerShortCode": "$_id",
            "clinics": 1
        }
    }
]

#aggregation #mongodb

checking type in variable and length

[
  {
    $match: {
  $and: [
    { "age": { $type: "string" } },
    { $expr: { $gt: [{ $strLenCP: "$age" }, 5] } }
  ]
}
  },
    {
      $project: {
        email:1
      
    }
    }
  
]

##jupyter #aggregation #mongodb

group by

[
    {
        $group: {
            _id: "$participantId",
            documents: { $push: "$$ROOT" },
            count: { $sum: 1 }
        }
    },
    {
        $match: {
            count: { $gt: 1 }
        }
    },
    {
        $unwind: "$documents"
    },
    {
        $match: {
            "documents.programCode": { $ne: "" }
        }
    },
    {
        $group: {
            _id: {
                participantId: "$_id",
                programCode: "$documents.programCode",
                programStartDate: "$documents.programStartDate"
            },
            baselineId: { $first: "$_id" },
            documentIds: { $push: "$documents._id" }, 
            documents: { $push: "$documents" },
            count: { $sum: 1 }
        }
    },
    {
        $match: {
            count: { $gt: 1 }
        }
    },
    {
        $project: {
            _id: 1,
            participantId: "$_id.participantId",
            programCode: "$_id.programCode",
            programStartDate: "$_id.programStartDate",
            baselineId: 1,
            documentIds: 1 
        }
    },
    {
        $lookup: {
            "from": "participant",
            "localField": "participantId",
            "foreignField": "_id",
            "as": "temp"
        }
    },
    {
        $match: {
            "temp.userStatus": { $ne: "TEST" },
            $and: [
                { "temp.email": { $nin: [/deleted/] } },
                { "temp": { $ne: null } }
            ]
        }
    },
    {
        $unwind:"$documentIds"
    }
    {
        $project: {
            _id:0
            "participantId": { $arrayElemAt: ["$temp._id", 0] },
            "email": { $arrayElemAt: ["$temp.email", 0] },
            "documentIds": 1 
        }
    }
]

##jupyter #aggregation #mongodb

Group by in same collection

[
    {
        $group: {
            _id: "$participantId",
            documents: { $push: "$$ROOT" },
            count: { $sum: 1 }
        }
    },
    {
        $match: {
            count: { $gt: 1 }
        }
    },
    {
        $unwind: "$documents"
    },
    {
        $match: {
            "documents.programCode": { $ne: "" }
        }
    },
    {
        $group: {
            _id: {
                participantId: "$_id",
                programCode: "$documents.programCode",
                programStartDate: "$documents.programStartDate"
            },
            documents: { $push: "$documents" },
            count: { $sum: 1 }
        }
    },
    {
        $match: {
            count: { $gt: 1 }
        }
    },
    {
        $project: {
            _id: 0,
            participantId: "$_id.participantId",
            programCode: "$_id.programCode",
            programStartDate: "$_id.programStartDate"
        }
    },
    {
        $lookup: {
            "from": "participant",
            "localField": "participantId",
            "foreignField": "_id",
            "as": "temp"
        }
    },
    {
        $match: {
            "temp.userStatus": { $ne: "TEST" }
        }
    },
    {
        $project: {
            "id":{ $arrayElemAt: ["$temp._id", 0] }
            "email": { $arrayElemAt: ["$temp.email", 0] }
        }
    }
]

##jupyter #aggregation #mongodb

Mongo $ne and $ifNull while projection

[
    {
      "$lookup": {
        "from": "Assessment",
        "localField": "assessmentId",
        "foreignField": "_id",
        "as": "assessment"
      }
    },
    {
      "$unwind": {
        "path": "$assessment",
        "preserveNullAndEmptyArrays": true
      }
    },
    {
      "$match": {
        "$and": [
          {
            "assessmentId": {
              "$oid": "622072b1aaeb4e5955319304"
            },
            "endCode": {
              "$ne": ""
            }
          }
        ]
      }
    },
   {
  "$project": {
    "_id": 1,
    "name": {
      "$cond": {
        "if": { "$ifNull": ["$assessmentType", false] },
        "then": "$assessmentType",
        "else": "IDRS"
      }
    },
    "assessmentId": "$_id",
    "ok": "$assessment.type",
    "createdAt": 1
  }
}
,
   {
      "$sort": {
        "createdAt": -1
      }
    }

  ]

##jupyter #aggregation

Metabase date

[
    {
        "$match": {
            "userId": 
                ObjectId("64d1ee7758a82e63a46206fe")
            ,
            "$and": [
                {
                    "insertedFor": {
                        "$gte": {
                            "$date": "2024-02-18T09:52:03Z"
                        }
                    }
                },
                {
                    "insertedFor": {
                        "$lte": {
                            "$date": "2024-02-20T09:52:03Z"
                        }
                    }
                }
            ]
        }
    },
    {
        "$project": {
            "insertedFor": 1
        }
    },
  {
    $count:"toot"
  }
]

##jupyter #aggregation

jupyter 1

# 1- > Deleting based on _id in baselineTable

from bson import ObjectId
import json

file_path = 'delete_ids'

with open(file_path, 'r') as file:
    data = json.load(file)

data_array = data['data']

delete_object_ids = [ObjectId(item) for item in data_array]
db["participantBaselineAndFollowupData"].delete_many({"_id": {"$in": delete_object_ids}})
#to check
# records = db["participantBaselineAndFollowupData"].find({"_id": {"$in": delete_object_ids}})
# count=0
# for record in records:
#     count=count+1
#     print(record["_id"])
# print(count)

##jupyter #aggregation

jupyter 4

#4-> Refer Subscription based on date.(2 subscription)

import json
from datetime import datetime
from bson.objectid import ObjectId

with open('referSubByDate.json', 'r') as file:
    data = json.load(file)

not_found_ids = []
not_updated_ids = []

for item in data['data']:
    _id = item['id']
    date = item['date']
    date_object = datetime.strptime(date, "%d/%m/%Y")
    new_date = date_object.strftime("%Y-%m-%dT%H:%M:%S.000+00:00")
    
    participant_record = db["participantBaselineAndFollowupData"].find_one({"_id": ObjectId(_id)})
    
    if participant_record:
        user_id = participant_record["participantId"]
        
        subscription_record = db["subscription"].find_one({"userId": user_id, "startDate": new_date})
        
        if subscription_record:
            startDate = subscription_record["startDate"]
            program_code = subscription_record["subscriptionPlan"].get("programCode")
            
            result = db["participantBaselineAndFollowupData"].update_one(
                {"_id": participant_record["_id"]},
                {"$set": {"programCode": program_code, "programStartDate": startDate}}
            )
            
            if result.modified_count == 0:
                not_updated_ids.append(_id)
        else:
            not_updated_ids.append(_id)
    else:
        not_found_ids.append(_id)

print("Completed")

if not_found_ids:
    print(f"IDs not found: {not_found_ids}")

if not_updated_ids:
    print(f"IDs not updated: {not_updated_ids}")

##jupyter #aggregation

jupyter 3

#3-> one baseline 2 subs refer the given program code
import json

file_path = "oneBase2Sub"
try:
    with open(file_path, "r") as file:
        data1 = json.load(file)
        # print(data)

    data_list = list(data1.items())
    # print(data_list)
except Exception as e:
    print("Error:", e)


print(len(data_list))









from bson.objectid import ObjectId

not_found_ids = []
not_updated_ids = []

for data_tuple in data_list:
    _id, program_code = data_tuple

    participant_record = db["participantBaselineAndFollowupData"].find_one({"_id": ObjectId(_id)})

    if participant_record:
        user_id = participant_record["participantId"]

        subscription_record = db["subscription"].find_one({"userId": user_id, "subscriptionPlan.programCode": program_code})
        
        if subscription_record:
            program_start_date = subscription_record.get("startDate", "")
            program_code_from_subscription = subscription_record["subscriptionPlan"].get("programCode", "")
            
            result = db["participantBaselineAndFollowupData"].update_one(
                {"_id": participant_record["_id"]},
                {"$set": {"programCode": program_code, "programStartDate": program_start_date}}
            )
            
            if result.modified_count == 0:
                not_updated_ids.append(_id)
        else:
            not_updated_ids.append(_id)
    else:
        not_found_ids.append(_id)

print("Completed")


if not_found_ids:
    print(f"IDs not found: {len(not_found_ids)}")
    print(f"IDs not found: {not_found_ids}")

if not_updated_ids:
    print(f"IDs not updated: {len(not_updated_ids)}")
    print(f"IDs not updated: {not_updated_ids}")

##jupyter #aggregation

jupyter query 2

# 2-> 1 subs 1 baseline
import json

file_path = "referOneSub"

with open(file_path, 'r') as file:
    data = json.load(file)

data_array = data['data']
insert_object_ids = [ObjectId(_id) for _id in data_array]
print(len(insert_object_ids))
# print(insert_object_ids)




from bson.objectid import ObjectId

not_found_ids = []
not_updated_ids = []

for _id in insert_object_ids:
    record = db["participantBaselineAndFollowupData"].find_one({"_id": _id})
    
    if record:
        user_id = record["participantId"]
        
        subscription = db["subscription"].find_one({"userId": user_id})
        
        if subscription:
            program_start_date = subscription.get("startDate", "")
            program_code = subscription["subscriptionPlan"].get("programCode", "")
            
            result = db["participantBaselineAndFollowupData"].update_one(
                {"_id": _id},
                {"$set": {"programCode": program_code, "programStartDate": program_start_date}}
            )
            
            if result.modified_count == 0:
                not_updated_ids.append(_id)
        else:
            not_updated_ids.append(_id)
    else:
        not_found_ids.append(_id)

print("Completed")

if not_found_ids:
    print(f"IDs not found: {print(not_found_ids)}")

if not_updated_ids:
    print(f"IDs not updated: {len(not_updated_ids)}")
    print(f"IDs not updated: {not_updated_ids}")

##jupyter #aggregation

Dashboard script

#3-> one baseline 2 subs refer the given program code
import json

file_path = "oneBase2Sub"
try:
    with open(file_path, "r") as file:
        data1 = json.load(file)
        # print(data)

    data_list = list(data1.items())
    # print(data_list)
except Exception as e:
    print("Error:", e)


print(len(data_list))

for data_tuple in data_list:
    _id, program_code = data_tuple

    participant_record = db["participantBaselineAndFollowupData"].find_one({"_id": ObjectId(_id)})

    if participant_record:
        user_id = participant_record["participantId"]

        subscription_record = db["subscription"].find_one({"userId": user_id, "subscriptionPlan.programCode": program_code})
        
        if subscription_record:
            program_start_date = subscription_record.get("startDate", "")
            program_code_from_subscription = subscription_record["subscriptionPlan"].get("programCode", "")
#             print(program_start_date)
#             print(program_code_from_subscription)
            db["participantBaselineAndFollowupData"].update_one(
                {"_id": participant_record["_id"]},
                {"$set": {"programCode": program_code, "programStartDate": program_start_date}}
            )
print("Completed")

##jupyter #aggregation

Dashboard script

# 2-> 1 subs 1 baseline
import json

file_path = "referOneSub"

with open(file_path, 'r') as file:
    data = json.load(file)

data_array = data['data']
insert_object_ids = [ObjectId(_id) for _id in data_array]
print(len(insert_object_ids))
# print(insert_object_ids)

from bson.objectid import ObjectId

for _id in insert_object_ids:
#     print("one")
    record = db["participantBaselineAndFollowupData"].find_one({"_id": _id})
    
    if record:
        user_id = record["participantId"]
        
        subscription = db["subscription"].find_one({"userId": user_id})
        
        if subscription:
            program_start_date = subscription.get("startDate", "")
            program_code = subscription["subscriptionPlan"].get("programCode", "")
            
            db["participantBaselineAndFollowupData"].update_one(
                {"_id": _id},
                {"$set": {"programCode": program_code, "programStartDate": program_start_date}}
            )
print("completed")

##jupyter #aggregation

Dashboarad->script

# 1- > Deleting based on _id in baselineTable

from bson import ObjectId
import json

file_path = 'delete_ids'

with open(file_path, 'r') as file:
    data = json.load(file)

data_array = data['data']

delete_object_ids = [ObjectId(item) for item in data_array]
db["participantBaselineAndFollowupData"].delete_many({"_id": {"$in": delete_object_ids}})
#to check
# records = db["participantBaselineAndFollowupData"].find({"_id": {"$in": delete_object_ids}})
# count=0
# for record in records:
#     count=count+1
#     print(record["_id"])
# print(count)

#aggregation #mongodb #pagination

MongoDB aggregation for pagination

db.Order.aggregate([
    { '$match'    : { "company_id" : ObjectId("54c0...") } },
    { '$sort'     : { 'order_number' : -1 } },
    { '$facet'    : {
        metadata: [ { $count: "total" }, { $addFields: { page: NumberInt(3) } } ],
        data: [ { $skip: 20 }, { $limit: 10 } ] // add projection here wish you re-shape the docs
    } }
] )

Filter with size

Thu Apr 25 2024 04:12:30 GMT+0000 (Coordinated Universal Time) http://34.74.16.180:3000/question#eyJkYXRhc2V0X3F1ZXJ5Ijp7InR5cGUiOiJuYXRpdmUiLCJuYXRpdmUiOnsiY29sbGVjdGlvbiI6InVzZXJzIiwicXVlcnkiOiJbXHJcbiAgICB7XHJcbiAgICAgICAgXCIkbWF0Y2hcIjoge1xyXG4gICAgICAgICAgICBcImF1dGhvcml6YXRpb25cIjoge1xyXG4gICAgICAgICAgICAgICAgXCIkbmVcIjogbnVsbFxyXG4gICAgICAgICAgICB9XHJcbiAgICAgICAgfVxyXG4gICAgfSxcclxuICAgIHtcclxuICAgICAgICBcIiRtYXRjaFwiOiB7XHJcbiAgICAgICAgICAgIFwiZW1haWxcIjoge1xyXG4gICAgICAgICAgICAgICAgXCIkbm90XCI6IHtcclxuICAgICAgICAgICAgICAgICAgICBcIiRyZWd1bGFyRXhwcmVzc2lvblwiOiB7XHJcbiAgICAgICAgICAgICAgICAgICAgICAgIFwicGF0dGVyblwiOiBcImRlbGV0ZWRcIixcclxuICAgICAgICAgICAgICAgICAgICAgICAgXCJvcHRpb25zXCI6IFwiXCJcclxuICAgICAgICAgICAgICAgICAgICB9XHJcbiAgICAgICAgICAgICAgICB9XHJcbiAgICAgICAgICAgIH1cclxuICAgICAgICB9XHJcbiAgICB9LFxyXG4gXHJcbiAgICB7XHJcbiAgICAgICAgXCIkbG9va3VwXCI6IHtcclxuICAgICAgICAgICAgXCJmcm9tXCI6IFwicGFydGljaXBhbnRcIixcclxuICAgICAgICAgICAgXCJsb2NhbEZpZWxkXCI6IFwiZW1haWxcIixcclxuICAgICAgICAgICAgXCJmb3JlaWduRmllbGRcIjogXCJlbWFpbFwiLFxyXG4gICAgICAgICAgICBcImFzXCI6IFwidXNlclBhcnRpY2lwYW50XCJcclxuICAgICAgICB9XHJcbiAgICB9LFxyXG4gICAge1xyXG4gICAgICAgIFwiJG1hdGNoXCI6IHt9XHJcbiAgICB9LFxyXG4gICAge1xyXG4gICAgICAgIFwiJGxvb2t1cFwiOiB7XHJcbiAgICAgICAgICAgIFwiZnJvbVwiOiBcIm1hc3RlclNsb3RcIixcclxuICAgICAgICAgICAgXCJsb2NhbEZpZWxkXCI6IFwidXNlclBhcnRpY2lwYW50Ll9pZFwiLFxyXG4gICAgICAgICAgICBcImZvcmVpZ25GaWVsZFwiOiBcIm5hdmlnYXRvcklkXCIsXHJcbiAgICAgICAgICAgIFwiYXNcIjogXCJzbG90c1wiXHJcbiAgICAgICAgfVxyXG4gICAgfSxcclxuICAgIHtcclxuICAgICAgICBcIiRsb29rdXBcIjoge1xyXG4gICAgICAgICAgICBcImZyb21cIjogXCJ1c2VyQ29hY2hNYXBwaW5nXCIsXHJcbiAgICAgICAgICAgIFwibG9jYWxGaWVsZFwiOiBcInVzZXJQYXJ0aWNpcGFudC5faWRcIixcclxuICAgICAgICAgICAgXCJmb3JlaWduRmllbGRcIjogXCJjb2FjaElEXCIsXHJcbiAgICAgICAgICAgIFwiYXNcIjogXCJ1c2VyQ29hY2hNYXBwaW5nXCJcclxuICAgICAgICB9XHJcbiAgICB9LFxyXG4gICAge1xyXG4gICAgICAgIFwiJHByb2plY3RcIjoge1xyXG4gICAgICAgIFxyXG4gICAgICAgICAgICBcImlzQ29hY2hBY3RpdmVcIjoge1xyXG4gICAgICAgICAgICAgICAgXCIkYXJyYXlFbGVtQXRcIjogW1xyXG4gICAgICAgICAgICAgICAgICAgIFwiJHVzZXJQYXJ0aWNpcGFudC5hY3RpdmVcIixcclxuICAgICAgICAgICAgICAgICAgICAwXHJcbiAgICAgICAgICAgICAgICBdXHJcbiAgICAgICAgICAgIH0sXHJcbiAgICAgICAgXHJcbiAgICAgICAgICAgIFwiZW1haWxcIjoge1xyXG4gICAgICAgICAgICAgICAgXCIkYXJyYXlFbGVtQXRcIjogW1xyXG4gICAgICAgICAgICAgICAgICAgIFwiJHVzZXJQYXJ0aWNpcGFudC5lbWFpbFwiLFxyXG4gICAgICAgICAgICAgICAgICAgIDBcclxuICAgICAgICAgICAgICAgIF1cclxuICAgICAgICAgICAgfSxcclxuICAgICAgICAgICAgXCJmaXJzdE5hbWVcIjoge1xyXG4gICAgICAgICAgICAgICAgXCIkYXJyYXlFbGVtQXRcIjogW1xyXG4gICAgICAgICAgICAgICAgICAgIFwiJHVzZXJQYXJ0aWNpcGFudC5maXJzdE5hbWVcIixcclxuICAgICAgICAgICAgICAgICAgICAwXHJcbiAgICAgICAgICAgICAgICBdXHJcbiAgICAgICAgICAgIH0sXHJcbiAgICAgICAgICAgIFwiY29hY2hQcm9maWxlRGVzY3JpcHRpb25cIjoge1xyXG4gICAgICAgICAgICAgICAgXCIkYXJyYXlFbGVtQXRcIjogW1xyXG4gICAgICAgICAgICAgICAgICAgIFwiJHVzZXJQYXJ0aWNpcGFudC5jb2FjaFByb2ZpbGVEZXNjcmlwdGlvblwiLFxyXG4gICAgICAgICAgICAgICAgICAgIDBcclxuICAgICAgICAgICAgICAgIF1cclxuICAgICAgICAgICAgfSxcclxuICAgIFxyXG4gICAgICAgICAgICBcIm1pZGRsZU5hbWVcIjoge1xyXG4gICAgICAgICAgICAgICAgXCIkYXJyYXlFbGVtQXRcIjogW1xyXG4gICAgICAgICAgICAgICAgICAgIFwiJHVzZXJQYXJ0aWNpcGFudC5taWRkbGVOYW1lXCIsXHJcbiAgICAgICAgICAgICAgICAgICAgMFxyXG4gICAgICAgICAgICAgICAgXVxyXG4gICAgICAgICAgICB9LFxyXG4gICAgICAgICAgICBcImxhc3ROYW1lXCI6IHtcclxuICAgICAgICAgICAgICAgIFwiJGFycmF5RWxlbUF0XCI6IFtcclxuICAgICAgICAgICAgICAgICAgICBcIiR1c2VyUGFydGljaXBhbnQubGFzdE5hbWVcIixcclxuICAgICAgICAgICAgICAgICAgICAwXHJcbiAgICAgICAgICAgICAgICBdXHJcbiAgICAgICAgICAgIH0sXHJcbiAgICAgICAgICAgIFwicGFydG5lclNob3J0Q29kZVwiOiB7XHJcbiAgICAgICAgICAgICAgICBcIiRhcnJheUVsZW1BdFwiOiBbXHJcbiAgICAgICAgICAgICAgICAgICAgXCIkdXNlclBhcnRpY2lwYW50LnBhcnRuZXJTaG9ydENvZGVcIixcclxuICAgICAgICAgICAgICAgICAgICAwXHJcbiAgICAgICAgICAgICAgICBdXHJcbiAgICAgICAgICAgIH0sXHJcbiAgICBcclxuICAgICAgICAgICAgXCJyb2xlXCI6IHtcclxuICAgICAgICAgICAgICAgIFwiJGFycmF5RWxlbUF0XCI6IFtcclxuICAgICAgICAgICAgICAgICAgICBcIiR1c2VyUGFydGljaXBhbnQucm9sZVwiLFxyXG4gICAgICAgICAgICAgICAgICAgIDBcclxuICAgICAgICAgICAgICAgIF1cclxuICAgICAgICAgICAgfSxcclxuICAgICAgICAgICAgXCJ0ZW1wbGF0ZU5hbWVcIjogXCIkYXV0aG9yaXphdGlvbi5uYW1lXCIsXHJcbiAgICAgICAgICAgIFwic2VydmljZVBhcnRuZXJTaG9ydENvZGVcIjogXCIkc2VydmljZVBhcnRuZXJTaG9ydENvZGVcIixcclxuICAgICAgICAgICAgXCJ1c2VyVmlzaWJpbGl0eVwiOiBcIiR1c2VyVmlzaWJpbGl0eVwiLFxyXG4gICAgXHJcbiAgICAgICAgICAgIFwiVG90YWwgVXNlcnNcIjoge1xyXG4gICAgICAgICAgICAgICAgXCIkc2l6ZVwiOiB7XHJcbiAgICAgICAgICAgICAgICAgICAgXCIkZmlsdGVyXCI6IHtcclxuICAgICAgICAgICAgICAgICAgICAgICAgXCJpbnB1dFwiOiBcIiR1c2VyQ29hY2hNYXBwaW5nXCIsXHJcbiAgICAgICAgICAgICAgICAgICAgICAgIFwiYXNcIjogXCJjb2FjaFwiLFxyXG4gICAgICAgICAgICAgICAgICAgICAgICBcImNvbmRcIjogeyBcIiRlcVwiOiBbXCIkJGNvYWNoLnVzZXJTdGF0dXNcIiwgXCJBQ1RJVkVcIl0gfVxyXG4gICAgICAgICAgICAgICAgICAgIH1cclxuICAgICAgICAgICAgICAgIH1cclxuICAgICAgICAgICAgfVxyXG4gICAgICAgICAgICBfaWQ6MFxyXG4gICAgICAgIH1cclxuICAgIH0sXHJcbiAgICB7XHJcbiAgICAgICAgJG1hdGNoOntcclxuICAgICAgICAgICAgXCJUb3RhbCBVc2Vyc1wiOiB7IFwiJGd0XCI6IDAgfVxyXG4gICAgICAgIH1cclxuICAgIH1cclxuXSIsInRlbXBsYXRlLXRhZ3MiOnt9fSwiZGF0YWJhc2UiOjJ9LCJkaXNwbGF5IjoidGFibGUiLCJ2aXN1YWxpemF0aW9uX3NldHRpbmdzIjp7fX0=

#aggregation #mongodb #map #filter #size

Map and filter on some conditoin

Fri Apr 12 2024 03:17:10 GMT+0000 (Coordinated Universal Time)

#aggregation #mongodb #date #map #filter

Date (addition) mongodb

Fri Apr 12 2024 03:15:55 GMT+0000 (Coordinated Universal Time) eyJkYXRhc2V0X3F1ZXJ5Ijp7InR5cGUiOiJuYXRpdmUiLCJuYXRpdmUiOnsiY29sbGVjdGlvbiI6ImJsb29kX2dsdWNvc2UiLCJxdWVyeSI6IltcclxuICAgIHtcclxuICAgICAgICBcIiRtYXRjaFwiOiB7XHJcbiAgICAgICAgICAgIFwicGFydGljaXBhbnRJZFwiOiBPYmplY3RJZChcIjY0ODFiNWYyNzA1MDA2MzUzMmE0NjAyMVwiKVxyXG4gICAgICAgIH1cclxuICAgIH0sXHJcbiAgICB7XHJcbiAgICAgICAgXCIkbWF0Y2hcIjoge1xyXG4gICAgICAgICAgICBcImRhdGVcIjogeyBcIiRndFwiOiBJU09EYXRlKFwiMjAyMy0wNi0xNVQwMDowMDowMC4wMDBaXCIpIH1cclxuICAgICAgICB9XHJcbiAgICB9XHJcbl1cclxuIiwidGVtcGxhdGUtdGFncyI6e319LCJkYXRhYmFzZSI6MTI5fSwiZGlzcGxheSI6InRhYmxlIiwidmlzdWFsaXphdGlvbl9zZXR0aW5ncyI6e319

#aggregation #mongodb #date

meal plan updation/ updating object fileds insided array in mongodb

Fri Apr 05 2024 10:03:33 GMT+0000 (Coordinated Universal Time)

#aggregation #mongodb #arrayfilter #array

Expression

Thu Apr 04 2024 17:09:21 GMT+0000 (Coordinated Universal Time) http://34.74.16.180:3000/question#eyJkYXRhc2V0X3F1ZXJ5Ijp7InR5cGUiOiJuYXRpdmUiLCJuYXRpdmUiOnsiY29sbGVjdGlvbiI6ImRpZXRMaWJyYXJ5IiwicXVlcnkiOiJbXHJcbiAgICB7XHJcbiAgICAgICAgXCIkbWF0Y2hcIjoge1xyXG4gICAgICAgICAgICBcIiRleHByXCI6IHtcclxuICAgICAgICAgICAgICAgIFwiJG5lXCI6IFtcIiRmb29kU3RhdHVzXCIsIFwiQVBQUk9WRURcIl1cclxuICAgICAgICAgICAgfVxyXG4gICAgICAgIH1cclxuICAgIH0sXHJcbiAgICB7XHJcbiAgICAgICAgXCIkbG9va3VwXCI6IHtcclxuICAgICAgICAgICAgXCJmcm9tXCI6IFwibWFzdGVybWVhbHBsYW5cIixcclxuICAgICAgICAgICAgXCJsb2NhbEZpZWxkXCI6IFwiZGlzaFZhcmlhdGlvblwiLFxyXG4gICAgICAgICAgICBcImZvcmVpZ25GaWVsZFwiOiBcIm1lYWxQbGFuLmRpc2hWYXJpYXRpb25cIixcclxuICAgICAgICAgICAgXCJhc1wiOiBcIm1lYWxEYXRhXCJcclxuICAgICAgICB9XHJcbiAgICB9LFxyXG4gICAge1xyXG4gICAgICAgIFwiJG1hdGNoXCI6IHtcclxuICAgICAgICAgICAgXCIkZXhwclwiOiB7XHJcbiAgICAgICAgICAgICAgICBcIiRndFwiOiBbeyBcIiRzaXplXCI6IFwiJG1lYWxEYXRhXCIgfSwgMF1cclxuICAgICAgICAgICAgfVxyXG4gICAgICAgIH1cclxuICAgIH0sXHJcbiAgICB7XHJcbiAgICAgICAgXCIkcHJvamVjdFwiOiB7XHJcbiAgICAgICAgICAgIFwibWVhbERhdGFcIjogXCIkbWVhbERhdGEucGxhbk5hbWVcIixcclxuICAgICAgICAgICAgXCJkaXNoVmFyaWF0aW9uXCI6IDFcclxuICAgICAgICB9XHJcbiAgICB9XHJcbl1cclxuIiwidGVtcGxhdGUtdGFncyI6e319LCJkYXRhYmFzZSI6Mn0sImRpc3BsYXkiOiJ0YWJsZSIsInZpc3VhbGl6YXRpb25fc2V0dGluZ3MiOnt9fQ==

#aggregation #mongodb #$push #exp

$push operator in mongodb

Fri Mar 22 2024 16:37:26 GMT+0000 (Coordinated Universal Time) http://34.74.16.180:3000/question#eyJkYXRhc2V0X3F1ZXJ5Ijp7InR5cGUiOiJuYXRpdmUiLCJuYXRpdmUiOnsiY29sbGVjdGlvbiI6ImNsaW5pY3MiLCJxdWVyeSI6IltcclxuICAgIHtcclxuICAgICAgICBcIiRtYXRjaFwiOiB7XHJcbiAgICAgICAgICAgIFwicGFydG5lclNob3J0Q29kZVwiOiB7XHJcbiAgICAgICAgICAgICAgICBcIiRpblwiOiBbXVxyXG4gICAgICAgICAgICB9XHJcbiAgICAgICAgfVxyXG4gICAgfSxcclxuICAgIHtcclxuICAgICAgICBcIiRncm91cFwiOiB7XHJcbiAgICAgICAgICAgIFwiX2lkXCI6IFwiJHBhcnRuZXJTaG9ydENvZGVcIixcclxuICAgICAgICAgICAgXCJjbGluaWNzXCI6IHtcclxuICAgICAgICAgICAgICAgIFwiJHB1c2hcIjoge1xyXG4gICAgICAgICAgICAgICAgICAgIFwiY2xpbmljTmFtZVwiOiBcIiRuYW1lXCIsXHJcbiAgICAgICAgICAgICAgICAgICAgXCJjbGluaWNJZFwiOiBcIiRfaWRcIlxyXG4gICAgICAgICAgICAgICAgfVxyXG4gICAgICAgICAgICB9XHJcbiAgICAgICAgfVxyXG4gICAgfSxcclxuICAgIHtcclxuICAgICAgICBcIiRwcm9qZWN0XCI6IHtcclxuICAgICAgICAgICAgX2lkOjAsXHJcbiAgICAgICAgICAgIFwicGFydG5lclNob3J0Q29kZVwiOiBcIiRfaWRcIixcclxuICAgICAgICAgICAgXCJjbGluaWNzXCI6IDFcclxuICAgICAgICB9XHJcbiAgICB9XHJcbl1cclxuIiwidGVtcGxhdGUtdGFncyI6e319LCJkYXRhYmFzZSI6Mn0sImRpc3BsYXkiOiJ0YWJsZSIsInZpc3VhbGl6YXRpb25fc2V0dGluZ3MiOnt9fQ==

#aggregation #mongodb #$push

checking type in variable and length

Tue Mar 19 2024 16:09:32 GMT+0000 (Coordinated Universal Time)

#aggregation #mongodb

group by

Tue Mar 12 2024 14:39:42 GMT+0000 (Coordinated Universal Time) http://34.74.16.180:3000/question#eyJkYXRhc2V0X3F1ZXJ5Ijp7ImRhdGFiYXNlIjoyLCJuYXRpdmUiOnsidGVtcGxhdGUtdGFncyI6e30sInF1ZXJ5IjoiW1xyXG4gICAge1xyXG4gICAgICAgICRncm91cDoge1xyXG4gICAgICAgICAgICBfaWQ6IFwiJHBhcnRpY2lwYW50SWRcIixcclxuICAgICAgICAgICAgZG9jdW1lbnRzOiB7ICRwdXNoOiBcIiQkUk9PVFwiIH0sXHJcbiAgICAgICAgICAgIGNvdW50OiB7ICRzdW06IDEgfVxyXG4gICAgICAgIH1cclxuICAgIH0sXHJcbiAgICB7XHJcbiAgICAgICAgJG1hdGNoOiB7XHJcbiAgICAgICAgICAgIGNvdW50OiB7ICRndDogMSB9XHJcbiAgICAgICAgfVxyXG4gICAgfSxcclxuICAgIHtcclxuICAgICAgICAkdW53aW5kOiBcIiRkb2N1bWVudHNcIlxyXG4gICAgfSxcclxuICAgIHtcclxuICAgICAgICAkbWF0Y2g6IHtcclxuICAgICAgICAgICAgXCJkb2N1bWVudHMucHJvZ3JhbUNvZGVcIjogeyAkbmU6IFwiXCIgfVxyXG4gICAgICAgIH1cclxuICAgIH0sXHJcbiAgICB7XHJcbiAgICAgICAgJGdyb3VwOiB7XHJcbiAgICAgICAgICAgIF9pZDoge1xyXG4gICAgICAgICAgICAgICAgcGFydGljaXBhbnRJZDogXCIkX2lkXCIsXHJcbiAgICAgICAgICAgICAgICBwcm9ncmFtQ29kZTogXCIkZG9jdW1lbnRzLnByb2dyYW1Db2RlXCIsXHJcbiAgICAgICAgICAgICAgICBwcm9ncmFtU3RhcnREYXRlOiBcIiRkb2N1bWVudHMucHJvZ3JhbVN0YXJ0RGF0ZVwiXHJcbiAgICAgICAgICAgIH0sXHJcbiAgICAgICAgICAgIGJhc2VsaW5lSWQ6IHsgJGZpcnN0OiBcIiRfaWRcIiB9LFxyXG4gICAgICAgICAgICBkb2N1bWVudElkczogeyAkcHVzaDogXCIkZG9jdW1lbnRzLl9pZFwiIH0sIFxyXG4gICAgICAgICAgICBkb2N1bWVudHM6IHsgJHB1c2g6IFwiJGRvY3VtZW50c1wiIH0sXHJcbiAgICAgICAgICAgIGNvdW50OiB7ICRzdW06IDEgfVxyXG4gICAgICAgIH1cclxuICAgIH0sXHJcbiAgICB7XHJcbiAgICAgICAgJG1hdGNoOiB7XHJcbiAgICAgICAgICAgIGNvdW50OiB7ICRndDogMSB9XHJcbiAgICAgICAgfVxyXG4gICAgfSxcclxuICAgIHtcclxuICAgICAgICAkcHJvamVjdDoge1xyXG4gICAgICAgICAgICBfaWQ6IDEsXHJcbiAgICAgICAgICAgIHBhcnRpY2lwYW50SWQ6IFwiJF9pZC5wYXJ0aWNpcGFudElkXCIsXHJcbiAgICAgICAgICAgIHByb2dyYW1Db2RlOiBcIiRfaWQucHJvZ3JhbUNvZGVcIixcclxuICAgICAgICAgICAgcHJvZ3JhbVN0YXJ0RGF0ZTogXCIkX2lkLnByb2dyYW1TdGFydERhdGVcIixcclxuICAgICAgICAgICAgYmFzZWxpbmVJZDogMSxcclxuICAgICAgICAgICAgZG9jdW1lbnRJZHM6IDEgXHJcbiAgICAgICAgfVxyXG4gICAgfSxcclxuICAgIHtcclxuICAgICAgICAkbG9va3VwOiB7XHJcbiAgICAgICAgICAgIFwiZnJvbVwiOiBcInBhcnRpY2lwYW50XCIsXHJcbiAgICAgICAgICAgIFwibG9jYWxGaWVsZFwiOiBcInBhcnRpY2lwYW50SWRcIixcclxuICAgICAgICAgICAgXCJmb3JlaWduRmllbGRcIjogXCJfaWRcIixcclxuICAgICAgICAgICAgXCJhc1wiOiBcInRlbXBcIlxyXG4gICAgICAgIH1cclxuICAgIH0sXHJcbiAgICB7XHJcbiAgICAgICAgJG1hdGNoOiB7XHJcbiAgICAgICAgICAgIFwidGVtcC51c2VyU3RhdHVzXCI6IHsgJG5lOiBcIlRFU1RcIiB9LFxyXG4gICAgICAgICAgICAkYW5kOiBbXHJcbiAgICAgICAgICAgICAgICB7IFwidGVtcC5lbWFpbFwiOiB7ICRuaW46IFsvZGVsZXRlZC9dIH0gfSxcclxuICAgICAgICAgICAgICAgIHsgXCJ0ZW1wXCI6IHsgJG5lOiBudWxsIH0gfVxyXG4gICAgICAgICAgICBdXHJcbiAgICAgICAgfVxyXG4gICAgfSxcclxuICAgIHtcclxuICAgICAgICAkdW53aW5kOlwiJGRvY3VtZW50SWRzXCJcclxuICAgIH1cclxuICAgIHtcclxuICAgICAgICAkcHJvamVjdDoge1xyXG4gICAgICAgICAgICBfaWQ6MFxyXG4gICAgICAgICAgICBcInBhcnRpY2lwYW50SWRcIjogeyAkYXJyYXlFbGVtQXQ6IFtcIiR0ZW1wLl9pZFwiLCAwXSB9LFxyXG4gICAgICAgICAgICBcImVtYWlsXCI6IHsgJGFycmF5RWxlbUF0OiBbXCIkdGVtcC5lbWFpbFwiLCAwXSB9LFxyXG4gICAgICAgICAgICBcImRvY3VtZW50SWRzXCI6IDEgXHJcbiAgICAgICAgfVxyXG4gICAgfVxyXG5dXHJcbiIsImNvbGxlY3Rpb24iOiJwYXJ0aWNpcGFudEJhc2VsaW5lQW5kRm9sbG93dXBEYXRhIn0sInR5cGUiOiJuYXRpdmUifSwiZGlzcGxheSI6InRhYmxlIiwidmlzdWFsaXphdGlvbl9zZXR0aW5ncyI6e319

##jupyter #aggregation #mongodb

Group by in same collection

Fri Mar 08 2024 10:24:18 GMT+0000 (Coordinated Universal Time) http://34.74.16.180:3000/question#eyJkYXRhc2V0X3F1ZXJ5Ijp7ImRhdGFiYXNlIjoyLCJuYXRpdmUiOnsidGVtcGxhdGUtdGFncyI6e30sInF1ZXJ5IjoiW1xyXG4gICAge1xyXG4gICAgICAgIFwiJG1hdGNoXCI6IHtcclxuICAgICAgICAgICAgXCJlbWFpbFwiOiBcInByb2R1Y3RAc21pdC5maXRcIlxyXG4gICAgICAgIH1cclxuICAgIH0sXHJcbiAgICB7XHJcbiAgICAgICAgXCIkbG9va3VwXCI6IHtcclxuICAgICAgICAgICAgXCJmcm9tXCI6IFwidXNlcnNcIixcclxuICAgICAgICAgICAgXCJsb2NhbEZpZWxkXCI6IFwiZW1haWxcIixcclxuICAgICAgICAgICAgXCJmb3JlaWduRmllbGRcIjogXCJlbWFpbFwiLFxyXG4gICAgICAgICAgICBcImFzXCI6IFwidXNlckxrcFwiXHJcbiAgICAgICAgfVxyXG4gICAgfSxcclxuICAgIHtcclxuICAgICAgICBcIiR1bndpbmRcIjoge1xyXG4gICAgICAgICAgICBcInBhdGhcIjogXCIkdXNlckxrcFwiLFxyXG4gICAgICAgICAgICBcInByZXNlcnZlTnVsbEFuZEVtcHR5QXJyYXlzXCI6IHRydWVcclxuICAgICAgICB9XHJcbiAgICB9LFxyXG4gICAge1xyXG4gICAgICAgIFwiJG1hdGNoXCI6IHtcclxuICAgICAgICAgICAgXCJ1c2VyTGtwLnBvcnRhbFBhc3N3b3JkXCI6IFwic21pdEBwcm9kdWN0I0AxMjFcIlxyXG4gICAgICAgIH1cclxuICAgIH0sXHJcbiAgICB7XHJcbiAgICAgICAgXCIkcHJvamVjdFwiOiB7XHJcbiAgICAgICAgICAgIFwiZmlyc3ROYW1lXCI6IDEsXHJcbiAgICAgICAgICAgIFwibWlkZGxlTmFtZVwiOiAxLFxyXG4gICAgICAgICAgICBcImxhc3ROYW1lXCI6IDEsXHJcbiAgICAgICAgICAgIFwiZW1haWxcIjogMSxcclxuICAgICAgICAgICAgXCJtb2JpbGVcIjogMSxcclxuICAgICAgICAgICAgXCJyb2xlXCI6IDEsXHJcbiAgICAgICAgICAgIFwicGFydG5lclNob3J0Q29kZVwiOiAxLFxyXG4gICAgICAgICAgICBcInVzZXJHcm91cHNcIjogXCIkdXNlckxrcC51c2VyR3JvdXBzXCIsXHJcbiAgICAgICAgICAgIFwicHJvZmlsZVBpY3R1cmVVUkxcIjogMSxcclxuICAgICAgICAgICAgXCJwb3J0YWxQYXNzd29yZFwiOiBcIiR1c2VyTGtwLnBvcnRhbFBhc3N3b3JkXCIsXHJcbiAgICAgICAgICAgIFwiYXV0aG9yaXphdGlvblwiOiBcIiR1c2VyTGtwLmF1dGhvcml6YXRpb25cIlxyXG4gICAgICAgIH1cclxuICAgIH1cclxuXSIsImNvbGxlY3Rpb24iOiJ1c2VycyJ9LCJ0eXBlIjoibmF0aXZlIn0sImRpc3BsYXkiOiJ0YWJsZSIsInZpc3VhbGl6YXRpb25fc2V0dGluZ3MiOnt9fQ==

##jupyter #aggregation #mongodb

Mongo $ne and $ifNull while projection

Fri Mar 01 2024 04:29:49 GMT+0000 (Coordinated Universal Time) http://34.74.16.180:3000/question#eyJkYXRhc2V0X3F1ZXJ5Ijp7InR5cGUiOiJuYXRpdmUiLCJuYXRpdmUiOnsiY29sbGVjdGlvbiI6InVzZXJBc3Nlc3NtZW50TWFwcGluZyIsInF1ZXJ5IjoiW1xuICAgIHtcbiAgICAgIFwiJGxvb2t1cFwiOiB7XG4gICAgICAgIFwiZnJvbVwiOiBcIkFzc2Vzc21lbnRcIixcbiAgICAgICAgXCJsb2NhbEZpZWxkXCI6IFwiYXNzZXNzbWVudElkXCIsXG4gICAgICAgIFwiZm9yZWlnbkZpZWxkXCI6IFwiX2lkXCIsXG4gICAgICAgIFwiYXNcIjogXCJhc3Nlc3NtZW50XCJcbiAgICAgIH1cbiAgICB9LFxuICAgIHtcbiAgICAgIFwiJHVud2luZFwiOiB7XG4gICAgICAgIFwicGF0aFwiOiBcIiRhc3Nlc3NtZW50XCIsXG4gICAgICAgIFwicHJlc2VydmVOdWxsQW5kRW1wdHlBcnJheXNcIjogdHJ1ZVxuICAgICAgfVxuICAgIH0sXG4gICAge1xuICAgICAgXCIkbWF0Y2hcIjoge1xuICAgICAgICBcIiRhbmRcIjogW1xuICAgICAgICAgIHtcbiAgICAgICAgICAgIFwiYXNzZXNzbWVudElkXCI6IHtcbiAgICAgICAgICAgICAgXCIkb2lkXCI6IFwiNjIyMDcyYjFhYWViNGU1OTU1MzE5MzA0XCJcbiAgICAgICAgICAgIH0sXG4gICAgICAgICAgICBcImVuZENvZGVcIjoge1xuICAgICAgICAgICAgICBcIiRuZVwiOiBcIlwiXG4gICAgICAgICAgICB9XG4gICAgICAgICAgfVxuICAgICAgICBdXG4gICAgICB9XG4gICAgfSxcbiAgIHtcbiAgXCIkcHJvamVjdFwiOiB7XG4gICAgXCJfaWRcIjogMSxcbiAgICBcIm5hbWVcIjoge1xuICAgICAgXCIkY29uZFwiOiB7XG4gICAgICAgIFwiaWZcIjogeyBcIiRpZk51bGxcIjogW1wiJGFzc2Vzc21lbnRUeXBlXCIsIGZhbHNlXSB9LFxuICAgICAgICBcInRoZW5cIjogXCIkYXNzZXNzbWVudFR5cGVcIixcbiAgICAgICAgXCJlbHNlXCI6IFwiSURSU1wiXG4gICAgICB9XG4gICAgfSxcbiAgICBcImFzc2Vzc21lbnRJZFwiOiBcIiRfaWRcIixcbiAgICBcIm9rXCI6IFwiJGFzc2Vzc21lbnQudHlwZVwiLFxuICAgIFwiY3JlYXRlZEF0XCI6IDFcbiAgfVxufVxuLFxuICAge1xuICAgICAgXCIkc29ydFwiOiB7XG4gICAgICAgIFwiY3JlYXRlZEF0XCI6IC0xXG4gICAgICB9XG4gICAgfVxuXG4gIF0iLCJ0ZW1wbGF0ZS10YWdzIjp7fX0sImRhdGFiYXNlIjoyfSwiZGlzcGxheSI6InRhYmxlIiwidmlzdWFsaXphdGlvbl9zZXR0aW5ncyI6e319

##jupyter #aggregation #mongodb

Filter with size

Map and filter on some conditoin

Date (addition) mongodb

meal plan updation/ updating object fileds insided array in mongodb

Expression

$push operator in mongodb

checking type in variable and length

group by

Group by in same collection

Mongo $ne and $ifNull while projection

Metabase date

jupyter 1

jupyter 4

jupyter 3

jupyter query 2

Dashboard script

Dashboard script

Dashboarad->script

MongoDB aggregation for pagination

Save snippets that work with our extensions