Alert Summary

General Discussion
1

We are at present developing a system that has over 50 water treatment and waste water treatment sites. I am trying to have the alert summary showing all the alarms from these plants on the home page but when you drill into individual sites the alert summary only shows these sites. I was trying to use SQL query

SELECT *
FROM ALERT_LOG
WHERE DISPLAYPATH=’{[Client]SITE_NAME}’

I was binding this in Alerts/Data, but its not working
anyone any ideas ?

2

It seems you are on the right track. Are all of your sites alarm history stored in a single database table? If so, you can write a query to bring back alarms for just a single site:SELECT * FROM ALERT_LOG WHERE PATH LIKE '{[Client]SITE_NAME}%' AND ACTIVE_TIMESTAMP BETWEEN '{Root Container.Date Range.startDate}' AND '{Root Container.Date Range.endDate}'I would use the LIKE operator in SQL to search for a pattern because you don’t want the display path to be the same for each alarm. Also, make sure you filter it on time as well. This is very similar to your query so if yours is not working post the details of the error that pops up.

3

Hi Travis
I tried your code, it didn’t give back an error but it didn’t filter alarms for me either i.e all alarms are still being shown no matter what page I am on.
Am I binding this code in the right place Alerts/Data ?

4

What is the value of the client tag calld “SITE_NAME”?

5

The value is a string for example 'BelturbetWWW ’ ,this name is used in the tag database alert name, there for if this string was in the Displaypath and it matched the alarm from the client SITE_NAME display all these alarms will be shown. The Site_name is enabled when you click on the button for the site you are drilling down in to.

site = ‘BELTURBET WWTW’
system.tag.writeToTag(’[Client]SITE_NAME’, site)

This was the idea but it doesn’t work.

6

You will probably have to give our tech support a quick call. That way we can look at everything you have to figure out what is going. Call them at (800) 266-7798 and press 2.