Subscribing is a smart move!
You can subscribe to this board after you log in or create your free account.
Invite a Co-worker
Send a co-worker an invite to the portal.Just enter their email address and we'll connect them to register. After joining, they will belong to the same company.
Send Invite Cancel
Link copied. Please paste this link to share this article on your social media post.
📖 Home Back
Filtering of events and alarms based on AOI is handled differently depending on whether you are filtering alarms or events.
For alarms, the AOI is hierarchical. This means that if you include the World group in the filter, all the alarms in World and all its sub groups will be displayed.
For events, the AOI is a flat structure and you need to allow for this in the filters used. If you specify a filter to show events in the World group, you will only get events in the World group. This is because the WHERE clause of the SQL statement is formed up such that you only get events where the AOI is equal to World.
To obtain similar functionality to the alarm list, it is important to use the Begins With option in the filter dialog as this will include each sub-AOI of the top level AOI selected.
AOI_Event_List_Filter.jpgAOI_Event_List_Filter.jpg
The SQL is then modified to use the LIKE operator to allow for the hierarchy of the Areas of Interest.
Go: Home Back
Filtering of events and alarms based on AOI is handled differently depending on whether you are filtering alarms or events.
For alarms, the AOI is hierarchical. This means that if you include the World group in the filter, all the alarms in World and all its sub groups will be displayed.
For events, the AOI is a flat structure and you need to allow for this in the filters used. If you specify a filter to show events in the World group, you will only get events in the World group. This is because the WHERE clause of the SQL statement is formed up such that you only get events where the AOI is equal to World.
WHERE "AreaOfInterest" = 'World'
To obtain similar functionality to the alarm list, it is important to use the Begins With option in the filter dialog as this will include each sub-AOI of the top level AOI selected.
AOI_Event_List_Filter.jpgAOI_Event_List_Filter.jpg
The SQL is then modified to use the LIKE operator to allow for the hierarchy of the Areas of Interest.
WHERE "AreaOfInterest" LIKE 'World%'
Go: Home Back
Author
Create your free account or log in to subscribe to the board - and gain access to more than 10,000+ support articles along with insights from experts and peers.