Article - CS253788

Datetime field in DataTable cannot be updated to null in ThingWorx

Modified: 21-Jul-2023   


Applies To

  • ThingWorx Platform 8.5 to 9.3

Description

  • Datetime field in DataTable cannot be updated to null value
  • When update via Mashup Tab of DataTable entity
    • Datetime field will be initialized with current time if no value is set
    • Datetime field can be set with a new value but user cannot remove the value
image.png
  • When update via existing services such as UpdateDataTableEntry, UpdateDataTableEntries, AddOrUpdateDataTableEntry, AddOrUpdateDataTableEntries
    • If a datetime value is set, the new value will be used
    • If no datetime value is set, the old value will be kept
image.png
  • When update via custom defined services
    • If a datetime value is set, the new value will be used
    • If datetime is set to null or undefined, the old value will be kept
This is a printer-friendly version of Article 253788 and may be out of date. For the latest version click CS253788