Skip to main content
1-Visitor
August 20, 2016
Solved

Synchronous data entries to data table

  • August 20, 2016
  • 4 replies
  • 2632 views

Hi,


Version: Thingworx 7.2

Steps: We are trying to auto update a data table in mashup, so we did following,

- created a property IsUpdated (Boolean) in data table.

- This property is set to true whenever write occurs through service.

- GetProperties of the datatable is used and also checked "Automatically update values when able"

- output of getproperties (IsUpdated) mapped to expression widget, whenever data changed a service is called to retrieve datatable.

Issue: We found that writes into data table entries are happening in asynchronous fashion​, we would like to know, how to make the data write to data table synchronous, so mashup would know exactly when the data table has updated.

Regards,

Penchalaiah

Best answer by CarlesColl

Hi,

If it's a DataTable writes are done on a Synchronous way. The Asynchronous data storage are Streams and ValueStreams.

Maybe you have more than one transaction trying to access to the same DataTable at the same time, this can make it seem to be Asynchronous, but it isn't, it's just two transactions at the same time ( the first one only sees the data how it was when it started the transaction not how the other transaction it's updating the data ).

Carles.

4 replies

1-Visitor
August 22, 2016

Hi,

If it's a DataTable writes are done on a Synchronous way. The Asynchronous data storage are Streams and ValueStreams.

Maybe you have more than one transaction trying to access to the same DataTable at the same time, this can make it seem to be Asynchronous, but it isn't, it's just two transactions at the same time ( the first one only sees the data how it was when it started the transaction not how the other transaction it's updating the data ).

Carles.

pyekula1-VisitorAuthor
1-Visitor
August 22, 2016

I am sorry I got information from team members, that we are trying to write into streams. Is it possible to synchronize it.

22-Sapphire I
August 22, 2016

Streams are asynchronous but you can specify the timestamp for the entry.