Working with the database query IN filter

[nshkrsh]

Hi.

@Quy

copy the SQL statement

Add the "test": true, line in your server action to view the final query in the Open In Browser output.

Different Result for Query on Server & Wappler

The JSON generated in you action will look like { "name": "query3", "module": "dbconnector", "action": "select", "options": { "connection": "mysql", "sql": { "type": "SELECT", "columns": [], "table": { "name": "articles" }, "joins": [], "wheres": {}, "query": "SELECT * FROM articles", "params": [] } }, "output…

As for the question:

@Quy

SELECT id, username FROM users WHERE id IN (1,2,3)

In my experience, IN does not always work with hard-coded values. Try running this query directly in your MySQL/MSSQL client (phpMyAdmin or SSMS) and compare the outputs.