Database

[{"key":1,contract_proposal_metadata:"as"},{"key":2,risk_info_request_metadata:"as"}]

Query

db.collection.update({placement:{"$nin":[-1,-2]},},[{$set:{status:{$switch:{branches:[{case:{$ifNull:["$contract_proposal_metadata",false]},then:"renewal"},{case:{$ifNull:["$risk_info_request_metadata",false]},then:"request"},],default:""}}}}],{multi:true})

Result