Hi Team,
Embed DP-Type are not logging in the below SQL Query. Kindly help me how to log Embed DP-Type.
SELECT ALL '_original.._value', '_original.._stime' FROM '*' WHERE _ELC = DPEL_BOOL TIMERANGE("2019.03.02 04:30:00","2019.03.02 20:38:00",1,0);
Thanks
Senthil M
SQL Query
- tmalone
- Posts:192
- Joined: Mon Nov 22, 2010 11:21 pm
Re: SQL Query
create master datapoint on embedded DPType. Put _archive config there. It will be inherited by the combined datatype.
- leoknipp
- Posts:2928
- Joined: Tue Aug 24, 2010 7:28 pm
Re: SQL Query
I do understand what the problem in detail is.
If you want to read historical data you have to add and configure an _archive config to the dp elements which shall be saved.
There is no need to use master datapoints you can add the _archive config on your own.
Please do not use SELECT ALL if you want to read data. Then it is sufficient to use SELECT.
Normally when reading historical data the _offline config is used.
Best Regards
Leopold Knipp
Senior Support Specialist
If you want to read historical data you have to add and configure an _archive config to the dp elements which shall be saved.
There is no need to use master datapoints you can add the _archive config on your own.
Please do not use SELECT ALL if you want to read data. Then it is sufficient to use SELECT.
Normally when reading historical data the _offline config is used.
Best Regards
Leopold Knipp
Senior Support Specialist