"like" query with wildcards to postgres breaking for exact match

Hi there,

Recently encountered an issue in queries to Postgres.

Say you have a table with an entry:
id = 1
name = ‘TEST_NAME’

select * from auth_group where name ilike ‘%TEST_NAME%’
The above query will yield no results in Retool, although does return you the record with ID 1 if queried to the DB.

Also, it seemed to work in earlier versions.

Is this expected?

Hi @gurpreetnanda!

This seems to work for me verbatim:

Is there a {{ }} tag being incorporated here? If so I normally use that like this:

Hi @alex-w,

This seems to be fixed now.

1 Like

Awesome! Glad to hear it