I have one requirement, that my device is directly sending the data and it has been storing in MySQL database. Now I want to display the recent data in the properties of a thing so that I can create Mashup screen.
As per mu knowledge, I can retrieve the data from database into the thingworx. After that how can I show them i the properties?
Hi Mahaboob, if you are mapping each device with it's respective Thing in the ThingWorx, you assume that Thing will have it's own properties. With that assumption you can simply create your SQL service under that Thing and assign the output of that service to the property of that Thing. Or otherwise you can also simply call that service directly onto the Mashup and display the data in a Grid or a Chart as per your requirement.
Thanks for your Quick Reply,
am giving in brief about my requirement,
I think this should be achievable by
1. Writing SQL statement which will return all the required values, i.e. in this case Min, max and actual value; may be wrap that with a JS service to apply those additional logic of checking the values
2. You can now choose to put those values in an InfoTable or you could assign them individual properties of a Thing
3. Depending where you are storing those values in ThingWorx i.e. Infotable or Thing's properties you can simply use the OOTB service calls to get the property values and assign them individually to Gauge Widget.
4. Now to automate the part that the service executes every n number of secs you can use an Auto refresh widget calling that service periodically within the mashup.