Query using IN clause

======== TEMPLATE BUG FORM ========

Wappler Version : 2.1.5
Operating System : Centos 7 / php 7.2

Expected behavior

Using a query action, the query in question should return 11 rows from the database.

The query should be:
SELECT tran, id, gl, amount, source_date FROM distros WHERE tran IN (30,1,33,32,34,2,3,4,5,39) AND instance = 2) ORDER BY source_date DESC

This shows the query results using Sequel Pro:

Screen Shot 2019-07-23 at 11.06.32 AM.jpg1758×778 177 KB

Actual behavior

The query returns two rows.

Here is the debug from the query

Screen Shot 2019-07-23 at 11.07.02 AM.png2010×470 86 KB

Here is the output:

Screen Shot 2019-07-23 at 11.07.30 AM.png1198×150 31.5 KB

Here is the query action:

Screen Shot 2019-07-23 at 11.07.58 AM.png1304×232 22.6 KB

and the paged query that provides the id’s for the IN clause:

Screen Shot 2019-07-23 at 11.20.16 AM.png1588×302 46.1 KB

How to reproduce

The id values used in the IN clause shown above come from a paged query action. It appears as though only the first item in the list is used in the subsequent query, although the debug shows the entire list.