Skip to main content
1-Visitor
October 9, 2017
Question

Map multiple gauge widgets data to multiple rows from same datatable

  • October 9, 2017
  • 1 reply
  • 2290 views

Hello,

I am Thingworx newbie and have run into a blocker using gauges. So I need to display two gauges(eg. Gauge A and Gauge B), both displaying data from the same data table (eg. DataTable_Gauge). I I have the gauge and the datatable mapping done in the Mashup, but I need to map Gauge A to Row_Id = "1" in DataTable_Gauge and Gauge B to Row_Id="2" in DataTable_Gauge. Any help would be much appreciated.

1 reply

5-Regular Member
October 10, 2017

Sudesh, does this DataTable only store 2 rows? You can use service like GetDataTableEntry to fetch 1 single row given you only have structure of 1 row and a column. If you have multiple columns then you'd need to query for particular field / column

ssubba-21-VisitorAuthor
1-Visitor
October 18, 2017

Hi Sushant,

Thanks for your response, but the table can have more than 1 rows as well, so based off a key, there could be 1 or more than 1 rows returned. But I found a different workaround. Just wanted to share. So what I did was create the gauge as the only widget in a mashup, then created a repeater in a new mashup and used the gauge mashup there. So this way I could bind the data to the repeater, with each row mapping to a gauge mashup.

5-Regular Member
October 18, 2017

Thank you Sudesh for updating details to your use case and the workaround you found.