Influx DpGroup and timerange filter

Discussions about product bugs & problems!
Note: This is no replacement for the Official ETM Support!
Search

Post Reply
4 posts • Page 1 of 1
ewoenne
Posts: 62
Joined: Thu May 12, 2016 10:35 am

Influx DpGroup and timerange filter

Post 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.

User avatar
leoknipp
Posts: 2926
Joined: Tue Aug 24, 2010 7:28 pm

Re: Influx DpGroup and timerange filter

Post 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

ewoenne
Posts: 62
Joined: Thu May 12, 2016 10:35 am

Re: Influx DpGroup and timerange filter

Post 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?

User avatar
leoknipp
Posts: 2926
Joined: Tue Aug 24, 2010 7:28 pm

Re: Influx DpGroup and timerange filter

Post 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

Post Reply
4 posts • Page 1 of 1