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

I don’t suppose anyone manages to get this working initially. This should help.

Thanks - that did the trick.