cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Community Tip - Your Friends List is a way to easily have access to the community members that you interact with the most! X

Primary Key in DataShape automatically typecasted in Thingworx

kramesh
1-Newbie

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!.

0 REPLIES 0
Top Tags