Page 1 of 1

Alarm Filtering by State

Posted: Fri Jun 01, 2018 12:58 pm
by brian@applied.co.uk
Hi,

I am working on porting from an obsolete Scada system to OA. The old system has options to filter the alarms (alerts) that are displayed by state in one of the following ways:

a. Display only Active Unacknowledged alarms
b. Display only Clear Unacknowledged alarms
c. Display only Active Acknowledged alarms

I know I can set the .Alerts.FilterState.State element of the appropriate _AESProperties datapoint to filter by state, but have found it possible to do only two of the above combinations:

State=3 displays only active unacknowledged alerts
State=4 displays only active acknowledged alerts

State=1 will display all unacknowledged alerts (both active and cleared).

Is there a State value that displays only alerts that are cleared and unacknowledged?

Re: Alarm Filtering by State

Posted: Mon Jun 04, 2018 10:20 am
by adaneau
Hi,

I guess _act_state should make it:


1 = CAME unacknowledged (Active Unacknowledged alarms)

2 = CAME acknowledged (Active Acknowledged alarms)

3 = WENT unacknowledged (Clear Unacknowledged alarms)

4 = CAME/WENT/unacknowledged (Clear Unacknowledged alarms in case of double ack required)

0 = No alert


BR
Alex

Re: Alarm Filtering by State

Posted: Mon Jun 04, 2018 2:28 pm
by brian@applied.co.uk
Alex, thanks for the response, but how do I filter by _act_state? Will I need to use a HOOK function (HOOK_aes_modifyQuery I would guess) to get at the raw SQL to apply the filter that I want?

Re: Alarm Filtering by State

Posted: Tue Jun 05, 2018 6:35 pm
by leoknipp
Brian Kelly wrote:
Is there a State value that displays only alerts that are cleared and unacknowledged?
What does "cleared" mean in detail?
Are you talking about alerts which are "gone" and "unacknowledged"?

Best Regards
Leopold Knipp
Senior Support Specialist

Re: Alarm Filtering by State

Posted: Wed Jun 06, 2018 11:28 am
by brian@applied.co.uk
Leopold: yes.

I am talking about the active alerts display, which shows alerts that are in one of three states:

1. Active (CAME) and unacknowledged
2. Active (CAME) and acknowledged
3. Cleared (WENT) and unacknowledged

We will not be using the double acknowledgement feature, so the CAME & WENT both unacknowledged mentioned by Alex is not appropriate to us.

Alex's suggestion looks like just what we want, and my reply to him questioned on how this can be implemented: do we need to implement a HOOK function to modify the query to add a filter on _act_state? Or is there some way to do this with the _AESProperties datapoint?

Brian

Re: Alarm Filtering by State

Posted: Wed Jun 06, 2018 11:48 am
by adaneau
Hi Brian,

Is it for runtime alarms or for historical?

Because in runtime it is possible to show ack / not ack with standard filter, however you cannot show only CAME or WENT ( I guess for security reason as in current mode you dont want to miss a new alarm).

But in closed intervall you can choose direction and status, thus having your filters set.

BR
Alex

Re: Alarm Filtering by State

Posted: Wed Jun 06, 2018 11:58 am
by brian@applied.co.uk
Alex,

Initial requirement is for runtime alarms.

Brian

Re: Alarm Filtering by State

Posted: Wed Jun 06, 2018 1:51 pm
by adaneau
You can have a look into

https://portal.etm.at/index.php?option= ... =8071#8071

This show you how to extend filter using HOOK_aes_modifyQuery. That should make the trick.

Re: Alarm Filtering by State

Posted: Wed Jun 06, 2018 4:02 pm
by brian@applied.co.uk
Alex, Thanks for the link. I'm now confident that I can implement the required filtering.