0 Replies Latest reply on Sep 15, 2015 11:07 PM by karthikr RSS
    karthikr Explorer

    Primary Key in DataShape automatically typecasted in Thingworx

    I have created a DataShape with an integer as a Primary Key. But it is stored as a decimal value and any query to the data table requires the key ending with the decimal.

    For example 1 (integer) is stored as 1.0 (Key) and thus the query search based on key should be 1.0.

    This gets worse when there are 2 primary keys in a data shape. It is stored as 1.02.

    I dont know what's a good way to get around it....pass every key as a text.string ..i'm not sure what problems this would create. For one, validation based on key is out of the window!.