I have a bundles column with some JSON data as string. In the REST API, I am calling the table with a filter.
/table/table_name endpoint.
table_name: v_all_software
filter: bundles like ‘%863dede2-7e00-4914-8600-dae636f95cb2%’
applicationId is a GUID. bundles is the column having a JSON string. An example value of bundles could be:
[{“application_id”: “863dede2-7e00-4914-8600-dae636f95cb2”}]
While executing the above REST API, I am getting an error:
“Failed to retrieve records from ‘v_all_software’.\nSQLSTATE[42883]: Undefined function: 7 ERROR: operator does not exist: json ~~ unknown\nLINE 1: …egate from "public"."v_all_software" where "bundles" LIKE $1\n ^\nHINT: No operator matches the given name and argument type(s). You might need to add explicit type casts. (SQL: select count(*) as aggregate from "public"."v_all_software" where "bundles" LIKE %863dede2-7e00-4914-8600-dae636f95cb2%)”
It looks like filter does not like a string with JSON in it. Or it does not like bundles column name.