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

Creating Table with dynamic data

Highlighted

Creating Table with dynamic data

Hi,

I am creating Thing using postman app. Thing inherits the properties from thing template which will inherit thing shape. Properties are updated in newly created thing. I want to update fields in Data table. Each time a thing is created, data should be updated to respective fields of data shape. Can you suggest which data storage i should use.

3 REPLIES 3

Re: Creating Table with dynamic data

Hi Isha, do you wish to change the data shape or the data in the data table with the creation of a new thing? If your question is around simply storing the values dynamically then you have to consider if these things are required to record history of values coming in you might as well use Stream/Value Stream, else should work with Data Table which you create on the fly with Data Shape created out of the data you are receiving.

If you expect incoming data to get fairly large then you might also want to review this blog Where Should I Store My Thingworx Data?

Re: Creating Table with dynamic data

I would recommend setting these Properties to Logged and assign a ValueStream

If you are only maintaining 1 row of information (last known value) you can get that based on the Properties VTQ, although if you need to store that for historical purposes you will need an accompanying property or store.

I would recommend just storing it 'flat' ie the DataShape of your store would become: ID, EntityName, PropertyName, PropertyValue (String form), DateTime

Or store it as a JSON Object.

This can be done based on a AnyDataChanged event/subscription

Re: Creating Table with dynamic data

What is the purpose for doing this?

Announcements

Thingworx Navigate content has a new home! Click here to access the new Thingworx Navigate forum! ______________________________