Not able to search bundles column which has JSON string

rest

#1

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.