parse_json(xyz):data:“search value”::string as filed

What database are you using? Not all databases support parse_json.