Querying the Historical Data Database Table
Use the GetHistoricalData service provided on the historical data management Thing Shape (PTC.DBConnection.HistoricalDataManagement_TS) to query the historical data database table. This service is intended to be tied into mashups for use through a user interface, rather than being used directly from ThingWorx Composer.
The GetHistoricalData service has three optional parameters:
• filter—A JSON filter can be used to filter the historical data database table to a fine degree.
• offset—Specifies the number of rows to skip before returning results.
• limit—Limits the number of results returned.
Users are not expected to use this service directly from within
ThingWorx Composer. Instead, include this service in mashups with user interface elements that allow the service to process and display the data appropriately. This means that end users do not need to construct their own JSON filter to make use of the
GetHistoricalData service. For more information, see
Using JSON Filters in Query Services.