I have a Postgres database, and the labels are an array in a JSONB field. If I run a custom query, for example:
SELECT
id,
url,
provider,
company,
provisioned,
hosting_service,
php_version,
labels
FROM
sites
WHERE
labels::jsonb ? '4'
To filter the results with the query above works fine inside my DB management software.
But if I try to run that same query inside Wappler, it handles the ? like a parameter that results in an error:
How can I add a query with a Postgres ? array operator inside Wappler?
Community Page
Last updated:
Last updated: