Database

[{"_id":{"$oid":"623a985aa0545e57fcd7d401"},"botID":2003633449,"userid":[{"_id":{"$oid":"623a985aa0545e57fcd7d402"},"tgid":923886862,"exam_year":null,"stream":null,"phone_no":null,"approvedpdf":[],"pendingpdf":[{"_id":{"$oid":"623b46052392fe1b98b39af0"},"requestid":"923886862007001","filename":"ssssssssss","fileid":"BQACAgUAAxkBAAJU_2I7Rfc6mhvMYvE3Why8w7AbBJ5JAAJWBQACcCLIVaxiOTpd60LHIwQ","bid":6,"botssendpdf_messageid":21762,"buttonpath":"Pdf Location = one > four","submitdatetime":1648051717990}]},{"_id":{"$oid":"623b45992392fe1b98b39adf"},"tgid":1260219595,"exam_year":2023,"stream":"maths","phone_no":null,"datetime":1648051609814,"pendingpdf":[],"approvedpdf":[]}],"createdAt":{"$date":"2022-03-23T03:47:38.369Z"},"updatedAt":{"$date":"2022-03-23T16:08:37.990Z"},"__v":0}]

Query

db.collection.update({"botID":2003633449},[{"$set":{"userid":{"$map":{"input":"$userid","as":"user","in":{"$cond":{"if":{"$eq":[923886862,"$$user.tgid"]},"then":{"_id":"$$user._id","tgid":"$$user.tgid","exam_year":"$$user.exam_year","stream":"$$user.stream","phone_no":"$$user.phone_no","datetime":"$$user.datetime","approvedpdf":"$$user.approvedpdf","pendingpdf":{"$filter":{"input":"$$user.pendingpdf","as":"pdf","cond":{"$ne":["$$pdf.requestid","923886862007001"]}}}},"else":"$user"}}}}}}])

Result