kepware data storage in ThingWorx

[svisveswaraiya]

Hi,

I wanted to know where we can fetch all the historical data that we get from Kepware. I am able to read the current data during data change in Kepware but everytime the data changes where does the older data or history data gets logged in ThingWorx? Using any query can I fetch it?

Thanks in Advance,

Shalini V.

[CarlesColl]

You must set the binded properties as logged and assign a ValueStream on the Thing, then all data that comes from remote kepware will be logged on ThingWorks.

Then you can query it with the services:

• Query"baseType"PropertyHistory (one property at a time)
• QueryPropertyHistory (multiple properties at once)

Best Regards,

Carles.

[slangley]

Hi @svisveswaraiya 

If the previous response provided by @CarlesColl answered your question, please mark it as the Accepted Solution for the benefit of others with the same question.

Regards.

--Sharon

[slangley]

Hi @svisveswaraiya- 

You should be able to log all properties to the same value stream.  This page in our Help Center may provide more information.

Regards.

--Sharon

[slangley]

Hi @svisveswaraiya- 

If you have found a solution to your problem, please post it here or mark one of the previous replies as the Accepted Solution for the benefit of others with similar issues.

Regards.

--Sharon

[svisveswaraiya]

Hi CarlesColl,

Thanks for your response.

Is it possible to combine three tag's QueryPropertyHistory as a single table? 

For eg: If I have temperature tag, pressure tag and Humidity tag. Can I combine the query property history values of three tags as single table? 

Thanks in advance,

Shalini V.