I have setup a multi-query using complex conditions. One of those is a search filter, which uses “contains” operator.
But, the search executed on the DB is case sensitive. I searched for it and found that MySQL default to case insensitive search, but Postgres is csae sensitive.
To run case insensitive search, the query should look something like
SELECT subject FROM topics WHERE subject ~* 'eclipse';
Is there a way in Wappler to do this? The column part in conditions are dropdowns, so I can add a lowercase formatter there. Adding lowercase formatter just on the value part will not work either.