Query builder broken: Custom to Simple doesn't work

Wappler General Bugs
#1

Wappler Version : 6.1.1
Operating System : Windows 11 x64
Server Model: NodeJS
Database Type: PostgreSQL
Hosting Type: Docker

I have a simple query which has two conditions

image
image1797×963 45.8 KB

Question 1: Why in SQL query it shows ? instead of :P1 and :P2

image
image1912×978 47.5 KB

Question 2: Why parameters tab is empty?

image
image1973×1047 94.4 KB

Switching to Custom Query is now shows ? where :P1 and :P2 should be and Parameters tab is empty.
After this switch:

  1. Query doesn’t work any more
  2. Click back to Simple gives such error:
    image
    image1527×956 24.8 KB
#2

This is how it is supposed to show parameters in the query builder … that has been disccussed multiple times already.

Well for custom queries you need to define :P1 and :P2 in order to see params in the params tab!

That’s not a bug at all.

#3

The parameters values should be enclosed in double curly brackets

image
image1026×604 26.7 KB

image
image1003×602 27 KB

Please try again…

#4

Not a bug, indeed.

1 Like