How to set values as parameters in SQL query. Knowing this values are coming from Kepware.

[AO_10482328]

Hello, everyone!

I have this project. Where we have a thing receving values coming from Kepware.

 

We have to replace this "values" to "text" and display to a mashup
For this reason we have a SQL query bringind all the data in a table.

 

 Questions:

1 - Is possible, somehow bring the (thing values) as input parameters in the SQL query ?

2 - The (thing values) ​​have updates. For this reason, is it possible to do it dynamically?

Let me know if you need more information. I'm not sure if I made it clear enough.

ThankYou in advanced.

[Arun_C · Accepted solution]

Hi @AO_10482328 ,

1) We can create Input parameters to SQL Command/Query by "[[VALUE FIELD]]" below image in Thingworx service,

2) For automatic update of live value, you can call this service to your Remote Thing Subscribtions based on respective live property's Data Change event we can log the data to SQL Database

Note: This method may not be advised because it will hit the database frequently based on live data updates for each parameters due to that data traffic may occurs.

Another suggestion, If you want to display the  live data on mashup means, without doing any external logging you can able to get live property values based on Thingworx default Remote Thing > Services like, You can choose based on requirement.

• GetPropertyValuesVTQ
• GetPropertyValuesVTQA
• GetPropertyValuesAsMultiRowTable

Thanks & Regards,

Arun C