Update existing record for table with xdo format

Queries and Resources
, ,
1 
UPDATE mvpw2_26
SET xdo->>'Type' = jsonb_set(xdo, '{Type}', '{{playerEarningLog.changesetArray[0].type}}')
WHERE id = 1857;

Can someone help me with correcting this query? I am not sure how do I set the Type value to the value from the changesetArray ?

image
image735×1575 93.7 KB

2

@victoria Would you be able to help me here?