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

App Building
1

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?

2

Hi @gurpreetnanda!

This seems to work for me verbatim:

image
image1908×930 85.2 KB

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

image
image2274×1254 177 KB

3

Hi @alex-w,

This seems to be fixed now.

1 Like
4

Awesome! Glad to hear it