Article - CS289219
Unable to pass dynamic input parameters for IN clause while executing an SQL query in ThingWorx
Modified: 22-Jul-2024
Applies To
- ThingWorx Platform 4.2 to 9.3
Description
- How to pass input parameter for an IN clause in SQL query where values in the IN clause are uncertain and dynamic
- How to pass dynamic input parameters to an SQL query service defined in a Database Thing
- DatabaseThing only support static SQL Query, when will DatabaseThing supports dynamic query, including dynamic WHERE clause, dynamic FROM clause
This is a printer-friendly version of Article 289219 and may be out of date. For the latest version click CS289219