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

Community Tip - Help us improve the PTC Community by taking this short Community Survey! X

Sql query result to infotable or property

ishrivastava-2
1-Newbie

Sql query result to infotable or property

Hello,

I am writing sql query service to retrive data from database.I want to assign service  result to infotable and thing property.Can anyone tell me how to do that.

1. Sql query service result to infotable so that i can map those result to mashup.

2. Sql query service result to thing property.

1 REPLY 1

Isha, you already have a Sql query service right? You can simply set the output of the service to INFOTABLE and then you can bind the result to a widget (be it List or Grid etc) in a Mashup. Make sure that the service type says 'Sql query' instead of the default 'Local (Javascript)'. If you are setting the values through a Mashup, you can call SetProperties in the Mashup Builder section for that specific Thing as well.

Top Tags