Navigation :

SQL

The historical data are stored on a SQL data base. One way to access the data is over the MS SQL. You can run this only locally on the platform provided. Attached a tutorial.

Below you see an example of an sql query.

Getting metadata

USE [NestTest]
GO
EXECUTE[usp].[uspSingleLine36] 
   @listOfSystemId='EXP03'
  ,@listOfDeviceId='E100,P890'
  ,@listOfNumericId=''
  ,@theStartDate='2019-11-01'
  ,@theEndDate='2019-11-03'
  ,@WithData=0
  ,@WithPivot=0
  ,@Language=0
GO

Getting actual measurement values

USE [NestTest]
GO
EXECUTE[usp].[uspSingleLine36] 
   @listOfSystemId='EXP03'
  ,@listOfDeviceId='E100,P890'
  ,@listOfNumericId='40120196,40120195,40120172'
  ,@theStartDate='2019-11-01'
  ,@theEndDate='2019-11-03'
  ,@WithData=1
  ,@WithPivot=1
  ,@Language=1
GO