[{"_id":{"$oid":"6459f1020162e7e3649729c9"},"user_id":{"$oid":"644fd02b7add0a888e2e8e84"},"creditTotal":500,"debitTotal":0,"creditDebitTotal":500,"userWallet":[{"userName":"hhjj","mobileNumber":"6666699888","sumTotal":500,"debit":{"totalDebit":0,"transactions":[]},"credit":{"totalCredit":500,"transactions":[{"amount":500,"date":"2023-05-17","description":"didi","_id":{"$oid":"64644941a6a3a7abdbf90316"}}]},"_id":{"$oid":"6462f70a2ff97a1eac2290a8"}}]},{"_id":{"$oid":"6459f1020162e7e3649729ce"},"user_id":{"$oid":"6459ecf2dcb04e1d845bb6f2"},"creditTotal":2500,"debitTotal":1000,"creditDebitTotal":1500,"userWallet":[{"userName":"h","mobileNumber":"22222222222","sumTotal":1500,"debit":{"totalDebit":1000,"transactions":[{"amount":1000,"date":"2023-05-16","description":"rt","_id":{"$oid":"64635ad2a6a3a7abdbf8f4b1"}}]},"credit":{"totalCredit":2500,"transactions":[{"amount":500,"date":"2023-05-16","description":"ft","_id":{"$oid":"646359e3a6a3a7abdbf8f4ac"}},{"amount":2000,"date":"2023-05-16","description":"rt","_id":{"$oid":"64635ba6a6a3a7abdbf8f4c7"}}]},"_id":{"$oid":"64630eb92ff97a1eac229517"}}]}]

db.collection.update({"user_id":{"$oid":"6459ecf2dcb04e1d845bb6f2"},"userWallet._id":{"$oid":"64630eb92ff97a1eac229517"},"userWallet.credit.transactions._id":{"$oid":"646359e3a6a3a7abdbf8f4ac"}},{"$set":{"userWallet.$[wId].credit.transactions.$[tId].amount":5000}},{"arrayFilters":[{"wId._id":{"$oid":"64630eb92ff97a1eac229517"}},{"tId._id":{"$oid":"646359e3a6a3a7abdbf8f4ac"}}]})