Between Operator Not Working In Update Query Builder UI

Wappler General Bugs
#1

Wappler Version : 4.2.2
Operating System : Windows 10
Server Model: NodeJS
Database Type: MySQL

Expected behavior

Using BETWEEN operator in Update Query Builder should save.

Actual behavior

image
image955×411 13.8 KB

Clicking “OK” does not do anything. I tried running Wappler with logs, but nothing showed up in the logs.

How to reproduce

Create an update query and try to add a BETWEEN condition with bindings in parameters.
Putting static value works.
Have tried with both experimental on & off, does not work in both cases.
Don’t have latest version, so can’t test on that.

#2

I was able to recreate this - i see two problems there, one - the data picker icon for the first input is missing and the second is when clicking the OK button, we will check that and fix it in the next update.

As a workaround you can achieve the same using 2 conditions there - greater than and less than.

#3
#4
#5
#6

Thanks. I actually did the same way. :sweat_smile:

#7

Bump

#8
#9

This has been fixed already in the latest updates.

#10