Database

[{"_id":ObjectId("6036c343445f3640c53e0a00"),"shares":[{"shareId":ObjectId("6035cc6acf345f3640c53d1a"),"type":"user"},{"shareId":ObjectId("6035b536cf345f3640c53cae"),"type":"group","rule":"view","subscribe":false}],"tags":[],"lastUsed":ISODate("2021-03-09T16:51:30.059Z"),"usageCount":1,"layout":"too many values with multiple node.","instanceType":"owner","original":null,"editing":true,"filters":[{"jaql":{"table":"Xyz","column":"title","dim":"[dbo.ketan.Title]",},"disabled":false},{"jaql":{"table":"abc","column":"name","dim":"[dbo.ketan.name]","datatype":"text","merged":true,"title":"Inventor Name","filter":{"explicit":false,"multiSelection":true,"all":true},"collapsed":false},"instanceid":"1B1E4-F6DC-28","isCascading":false}],}]

Query

db.collection.update({"filters.jaql.dim":{"$regex":"dbo.ketan"}},{"$set":{"filters.$[elem].jaql.dim":"[kiran.name]"}},{"arrayFilters":[{"elem.jaql.dim":{"$regex":"dbo.ketan"}}],"multi":true})

Result