Article - CS363928
QueryDataTableEntries / FindDataTableEntries services with "values" parameter do not work anymore on ThingWorx (H2 / SQL Server specific)
Modified: 18-Nov-2022
Applies To
- ThingWorx Platform 9.5 SP5.
- H2, Azure SQL, SQL Server
Description
- QueryDataTableEntries / FindDataTableEntries services with values parameter do not work anymore on ThingWorx H2 and SQL Server
- The issue is faced when querying multiple key fields. For example:
var values = Things["data_table"].CreateValues();
values.f1= "aaa"; //THINGTEMPLATENAME [Primary Key]
values.f2= "bbb"; //THINGNAME [Primary Key]
//result = Things["data_table"].QueryDataTableEntries({ values: values});
result = Things["data_table"].FindDataTableEntries({ values: values });
This is a printer-friendly version of Article 363928 and may be out of date. For the latest version click CS363928