How to get TimeStamp from Raima DB?

[vince2e]

Hello all,

I'm currently looking for a way to query a DPE in the archive and return the value && timestamp. Is there a way to do this in OA?

I'm using the following function to get the data between a defined time range:

dpQuery("SELECT '_online.._value' FROM '_mp_ANALOG1.C1.AVG_WT0' TIMERANGE(\\""+startTime+"\\",\\""+endTime+"\\",1,0 )",raimaResult);

which returns:

WCCOAui1:[dyn_dyn_anytype 9 items
WCCOAui1: 1: dyn_anytype 2 items
WCCOAui1: 1: (Type: 0 Sys: 0 Dp: 0 El: 0 : 0..0)
WCCOAui1: 2: :_online.._value (Type: 0 Sys: 0 Dp: 0 El: 0 : _online.._value)
WCCOAui1: 2: dyn_anytype 2 items
WCCOAui1: 1: System1:_mp_ANALOG1.C1.AVG_WT0 (Type: 63 Sys: 1 Dp: 259 El: 4 : 0..0)
WCCOAui1: 2: 80.062257759331
WCCOAui1: 3: dyn_anytype 2 items
WCCOAui1: 1: System1:_mp_ANALOG1.C1.AVG_WT0 (Type: 63 Sys: 1 Dp: 259 El: 4 : 0..0)
WCCOAui1: 2: 32.2946867275
WCCOAui1: 4: dyn_anytype 2 items
WCCOAui1: 1: System1:_mp_ANALOG1.C1.AVG_WT0 (Type: 63 Sys: 1 Dp: 259 El: 4 : 0..0)
WCCOAui1: 2: 28.211310159612
WCCOAui1: 5: dyn_anytype 2 items
WCCOAui1: 1: System1:_mp_ANALOG1.C1.AVG_WT0 (Type: 63 Sys: 1 Dp: 259 El: 4 : 0..0)
WCCOAui1: 2: 92.504654072695
WCCOAui1: 6: dyn_anytype 2 items
WCCOAui1: 1: System1:_mp_ANALOG1.C1.AVG_WT0 (Type: 63 Sys: 1 Dp: 259 El: 4 : 0..0)
WCCOAui1: 2: 63.762321848201
WCCOAui1: 7: dyn_anytype 2 items
WCCOAui1: 1: System1:_mp_ANALOG1.C1.AVG_WT0 (Type: 63 Sys: 1 Dp: 259 El: 4 : 0..0)
WCCOAui1: 2: 46.803186132389
WCCOAui1: 8: dyn_anytype 2 items
WCCOAui1: 1: System1:_mp_ANALOG1.C1.AVG_WT0 (Type: 63 Sys: 1 Dp: 259 El: 4 : 0..0)
WCCOAui1: 2: 89.611499374371
WCCOAui1: 9: dyn_anytype 2 items
WCCOAui1: 1: System1:_mp_ANALOG1.C1.AVG_WT0 (Type: 63 Sys: 1 Dp: 259 El: 4 : 0..0)
WCCOAui1: 2: 88.265633106479
WCCOAui1:]

[RudiKreiner]

I recently had the same application.
Have a look at the function dpGetPeriod(), or if you need only 1 value set, then dpGetAsynch()

[leoknipp]

If you want to get the corresponding time stamp for a value you need to read the attribute _stime (e.g. _online.._stime).
Keep in mind that normally the _offline config is read when reading historical values. If the _online config is used correction values may not be returned.

The relation between _original, _online and _offline is described in the following FAQ:
https://portal.etm.at/index.php?view=it ... &Itemid=54

Best Regards
Leopold Knipp
Senior Support Specialist

[vince2e]

Wow, that was easy! Thanks

For those looking for this solution, I used this query:

dpQuery("SELECT '_offline.._stime','_offline.._value' FROM '_mp_ANALOG1.C1.AVG_WT0' TIMERANGE(\\""+startTime+"\\",\\""+endTime+"\\",1,0 )",raimaResult);

and it returned this result:

WCCOAui1:[dyn_dyn_anytype 8 items
WCCOAui1: 1: dyn_anytype 3 items
WCCOAui1: 1: (Type: 0 Sys: 0 Dp: 0 El: 0 : 0..0)
WCCOAui1: 2: :_offline.._stime (Type: 0 Sys: 0 Dp: 0 El: 0 : _offline.._stime)
WCCOAui1: 3: :_offline.._value (Type: 0 Sys: 0 Dp: 0 El: 0 : _offline.._value)
WCCOAui1: 2: dyn_anytype 3 items
WCCOAui1: 1: System1:_mp_ANALOG1.C1.AVG_WT0 (Type: 63 Sys: 1 Dp: 259 El: 4 : 0..0)
WCCOAui1: 2: 2017.06.29 07:16:55.018000000
WCCOAui1: 3: 75.386822107608
WCCOAui1: 3: dyn_anytype 3 items
WCCOAui1: 1: System1:_mp_ANALOG1.C1.AVG_WT0 (Type: 63 Sys: 1 Dp: 259 El: 4 : 0..0)
WCCOAui1: 2: 2017.06.29 07:16:55.320000000
WCCOAui1: 3: 13.806573686941
WCCOAui1: 4: dyn_anytype 3 items
WCCOAui1: 1: System1:_mp_ANALOG1.C1.AVG_WT0 (Type: 63 Sys: 1 Dp: 259 El: 4 : 0..0)
WCCOAui1: 2: 2017.06.29 07:16:55.621000000
WCCOAui1: 3: 65.132602923673
WCCOAui1: 5: dyn_anytype 3 items
WCCOAui1: 1: System1:_mp_ANALOG1.C1.AVG_WT0 (Type: 63 Sys: 1 Dp: 259 El: 4 : 0..0)
WCCOAui1: 2: 2017.06.29 07:16:55.924000000
WCCOAui1: 3: 35.572374645222
WCCOAui1: 6: dyn_anytype 3 items
WCCOAui1: 1: System1:_mp_ANALOG1.C1.AVG_WT0 (Type: 63 Sys: 1 Dp: 259 El: 4 : 0..0)
WCCOAui1: 2: 2017.06.29 07:16:56.227000000
WCCOAui1: 3: 28.507339701529
WCCOAui1: 7: dyn_anytype 3 items
WCCOAui1: 1: System1:_mp_ANALOG1.C1.AVG_WT0 (Type: 63 Sys: 1 Dp: 259 El: 4 : 0..0)
WCCOAui1: 2: 2017.06.29 07:16:56.529000000
WCCOAui1: 3: 54.454176458022
WCCOAui1: 8: dyn_anytype 3 items
WCCOAui1: 1: System1:_mp_ANALOG1.C1.AVG_WT0 (Type: 63 Sys: 1 Dp: 259 El: 4 : 0..0)
WCCOAui1: 2: 2017.06.29 07:16:56.831000000
WCCOAui1: 3: 59.755241554003
WCCOAui1:]