Custom query with IF

Wappler Version : v.4.1.1
Operating System : Win 10 Pro
Server Model: NodeJS
Database Type: MySQL
Hosting Type: Docker

Custom query is very simple:

SELECT id, make, IF (:P1 = 2, model, null)
FROM cars

Steps to recreate:

1. Define Set Value:

   

   1934×228 19.9 KB

2. Create a parameter with a binding:

   

   21402×741 66.4 KB

3. Get an error:

   

   3964×615 49.3 KB

For some reason, query does not see the binding of the parameter, which is why it cannot check the condition.