Page 1 of 1

Influx DpGroup and timerange filter

Posted: Tue Mar 16, 2021 11:48 am
by ewoenne
Hi,

I have an issue using NGA Influx archiving and the alarm screen (3.17 patch 10).
Filtering by DpGroup or timerange is fine, but filtering by both returns no results.

eg testing the SQL queries directly:

SELECT ALERT '_alert_hdl.._text' FROM 'DPGROUP(_DpGroup00023_Public)'
-> alerts returned

SELECT ALERT '_alert_hdl.._text' FROM 'DPGROUP(_DpGroup00023_Public)' TIMERANGE("2021.03.14 18:00:00","2021.03.15 18:19:00",1,0)
-> nothing

SELECT ALERT '_alert_hdl.._text' FROM '*' TIMERANGE("2021.03.14 18:00:00","2021.03.15 18:19:00",1,0)
-> alerts returned including DPs in the DpGroup

It is also the same result when querying DPs rather than alerts.

Re: Influx DpGroup and timerange filter

Posted: Wed Mar 17, 2021 9:17 am
by leoknipp
As described in the Bugs and Limitations document delivered with the WinCC OA version dp groups are not supported for historical requests when using NGA.

Best Regards
Leopold Knipp
Senior Support Specialist

Re: Influx DpGroup and timerange filter

Posted: Wed Mar 17, 2021 11:27 am
by ewoenne
Thanks Leopold,

I didn't know about this document, available here for anyone else.

https://www.winccoa.com/downloads/detai ... ments.html

Is support for dpGroups in NGA planned?

Re: Influx DpGroup and timerange filter

Posted: Wed Mar 17, 2021 12:13 pm
by leoknipp
It is planned to support dp groups in future. At the moment it is not defined when the changes will be made.

Best Regards
Leopold Knipp
Senior Support Specialist