Skip to main content
V
Vimal_Rawat14-Alexandrite
14-Alexandrite
August 2, 2023
Solved

Thingworx mashup auto refresh on data table update/add/delete entry

  • August 2, 2023
  • 2 replies
  • 3745 views

Hi, 

I have a mashup that displays data from a Data table. I need mashup to auto refresh/update data whenever a row is added/deleted/updated in the Data table.

I can use auto-refresh function, but i need data to refresh only in case of changes to row in Data table.

 

 

 

Best answer by Vimal_Rawat

Taking help from your comments, this is what i did:-

 

  1. I created a property called 'mashup_updater' in helper thing, which i update with timestamp whenever data table is updated using subscription on data table.
  2. I created a container and put 'text' widget in that container. Then binded the 'text' with 'mashu_updater' property and enabled 'automatically update...' 
  3. Then on the change event of 'text' widget, i called a service to get latest data from data table and update the mashup.

2 replies

V
19-Tanzanite
Velkumar19-Tanzanite
19-Tanzanite
August 3, 2023

Hi @Vimal_Rawat 

 

Currently, we don't get any events triggered when DataTable gets altered. Based on how you are altering DataTable we can find some workaround.

 

Could you please explain when data will be added/deleted/updated in DataTable?

 

/VR

V
Vimal_Rawat14-AlexandriteAuthor
14-Alexandrite
August 3, 2023

Hi, 

I have a subscription on an entity from AMU application. whenever a new alarm is created in AMU application an entry is made in data table for the alarm using the subscription code.

Now whenever an entry is made in data table i need to refresh my mashup to show latest status of datatable.

V
19-Tanzanite
Velkumar19-Tanzanite
19-Tanzanite
August 3, 2023

Hi @Vimal_Rawat 

 

  1. Create a DateTime property in DataTable say 'lastUpdatedTime'
  2. Whenever DataTable gets altered, update this property value with an altered timestamp value
  3. In mashup, put a DateTime Picker and make it invisible (which will be used for lastMashupRefreshedTime)
  4. Get 'lastUpdatedTime' property value in mashup ( use autorefresh function to fetch value )
  5. Create a validator function that checks lastMashupRefreshedTime & lastUpdatedTime property
  6. If lastUpdatedTime  is greater than lastMashupRefreshedTime, using validator true event to pull data from DataTable 
  7. Update lastMashupRefreshedTime  value with lastUpdatedTime time

In this case, you will be using the AutoRefresh function but you won't query the dataTable value frequently.

 

/VR

V
VladimirRosu_11662719-Tanzanite
19-Tanzanite
August 3, 2023

Technically speaking (and not changing the workaround suggested below), if you are speaking about ThingWorx Data Tables, they do have events for row CRUD operations:

VladimirRosu_0-1691055243376.png

The issue though, is that these events are server-side, perfectly usable in subscriptions, but unusable for client-side (mashups).

You can not trigger a Mashup activity (eg: service execution) based on a server-side event (even if they share the same name, "event", they happen in different places and are incompatible with each other).

If you're speaking about pure SQL tables. then it is correct we don't have directly in ThingWorx a way to detect when a CRUD event happened, but you can definitely create a trigger in PostgreSQL for example, that will issue a REST call to ThingWorx to let it know an add event happened (though this approach is not useful here, more in cases when rows are created by other systems).

There is another workaround you can use:

  • create a session variable, type DateTime
  • In backend, update this DateTime variable each time when a new row is added / deleted
  • Use an AutoRefresh to execute the GetGlobalSessionValues

I suggest following Velkumar's approach, as at the end of the day you will find a way to reduce the widget impact on the layout and if you set the AutoRefresh at 1 second interval, it won't have such a big impact on the system.

 

V
19-Tanzanite
Velkumar19-Tanzanite
19-Tanzanite
August 4, 2023

Hi @VladimirRosu_116627 

 

I have a small question about Session Value. If User1 updates the DataTable and session value gets updated for User1. Will User1's session value be accessible by User2?

 

/VR

 

V
VladimirRosu_11662719-Tanzanite
19-Tanzanite
August 4, 2023

Hi @Velkumar ,

I'm sorry about the confusion, I did not read carefully all my reply before posting.

You can disregard this part below because it is effectively the same as your workaround.

I started writing it, then realized while writing it was not really useful, but forgot to delete it.

 

"There is another workaround you can use:

create a session variable, type DateTime
In backend, update this DateTime variable each time when a new row is added / deleted
Use an AutoRefresh to execute the GetGlobalSessionValues"

    Terms & ConditionsCookie settingsAccessibility statement