Skip to main content
S
Surajkumar4-Participant
4-Participant
September 22, 2022
Question

dynamic data handling with info table mapped to mashup

  • September 22, 2022
  • 1 reply
  • 1103 views

Hi All,

 

I am trying to design an mashup which will fetch data from MS-SQL database to info table, and further info table is mapped to mashup. Things are working fine when data is static i.e. in all iteration if data set is same. But my requirement is the data fetched from Database will be dynamic, each time it depends on user input. 

 

I would like to know how to handle dynamic data with info table mapped to mashup

1 reply

S
17-Peridot
Sathishkumar_C17-Peridot
17-Peridot
September 22, 2022

get the user input value as thing service input and do the logic accordingly.

S
SKannapiran12-Amethyst
12-Amethyst
September 23, 2022

@Sathishkumar_C  - We have tried to approach which will help us to bind the dataset to the info table to show a Report in the ThingWorx. 

Our scenario "dynamic data handling" applies to ThingWorx Graph.

A Graph has a "series" property that takes value at the design time. But in our use case, the series property value should be assigned from the dataset value. 

Please assist.

S
17-Peridot
Sathishkumar_C17-Peridot
17-Peridot
September 23, 2022

Use Line Chart or Bar Chart

There is a widget property called "NumberOfSeries". By default, automatic setting displays all data series in the infotable data. No need to map the field in design time.

Terms & ConditionsAccessibility statement