SQL IN query

Wappler Version : 3.9.1
Operating System : Mac OS X
Server Model: Node
Database Type: MySQL
Hosting Type: Docker

Expected behavior

be able to run a IN SQL query:
WHERE id IN (1,6)

Actual behavior

What actually happens?

Tried it using the paged query and as a custom query:
In the paged query it creates
WHERE id in ‘1,6’

As a custom query it creates it wraps the param in single quotes
WHERE id in (‘1,6’)

How to reproduce

Try and run an ‘in’ query with any of the MySQL functions

Community Page
Last updated: