Filter jsonb

[louisc]

I have a filter payment method names and when i put it in string and input a value but i does not work. I ma in postgresql.

select *
from return_type_filter
where true
[[ AND payment_gateway_names ilike {{payment_gateway_names}} ]]

and I get this error:

ERROR: operator does not exist: jsonb ~~* character varying Hint: No operator matches the given name and argument types. You might need to add explicit type casts. Position: 4105

[Luiggi]

Try to check on your postgres database what's the query being sent so you can catch the error. I'm assuming that what you're trying to do is checking for a text inside a JSON, which is an object, so checking a string against an object is not supported in postgres