Article - CS292316

ThingWorx "FindDataTableEntries" and "QueryDataTableEntries" are not retrieving data when DataShape has default values and input "values" is used

Modified: 23-Jan-2024   


Applies To

  • ThingWorx Platform 8.2 to 9.5

Description

  • ThingWorx Services FindDataTableEntries and QueryDataTableEntries are not retrieving data when Data Shape has default values and input "values" is used
  • FindDataTableEntries stops working after adding a new field with a default value to the Data Shape in ThingWorx
  • Old Composer presents the default values when adding a row to "values" infotable and it allows user to remove default values, but service doesn't retrieve expected results
  • New Composer also presents the default values but it doesn't allow user to remove the default values for numbers thus not retrieving expected results
  • FindDataTableEntries stops working after adding a new field with a default value to the Data Shape in ThingWorx
  • Javascript service calling FindDataTableEntries unexpectedly returns No Data 
  • let it=me.CreateValues();
    it.AddRow({id:2});
    let result = me.FindDataTableEntries({values: it});

 
This is a printer-friendly version of Article 292316 and may be out of date. For the latest version click CS292316