sql how to select row based on json format field value? – Postgresql
I have a table ,one of the table filed is json format: my_table id json_field 1 { "to_status": 7, "to_status_name": "In Progress", "role": "admin"} 2 { "to_status": 3, "to_status_name": "Completed", "role": "admin"} 3 { "to_status": 2, "to_status_name": "Completed", "role": "customer"}…