Query with variable not prepared

Hello everyone,

I currently use the following query which I execute on form submission. The problem is that it will always result in an error when I'm using a variable. (In this case the value of my search_query input).

You'll see the variable below. However, if I leave the variable away and just manually enter for example, my name, it seems to be working. So the issue does not lay with the query. At least, that's what I think.

The error I get is

bind message supplies 1 parameters, but prepared statement "" requires 0

If I hover over the variable in the query editor, I can confirm that the variable is working. I do get the input value, however when Queried, it returns in a broken query.

What am I doing wrong here?

  INNER JOIN user_settings ON "user".id = user_settings.owner_id
  lower(concat("user".first_name, "user".last_name)) LIKE '%{{search_query.value}}%'

Hi @pascalboschma Welcome to the community!

Can you try refactoring the dynamic input like this: {{'%'+textInput1.value+'%'}}

Let me know if that helps!