<Notification Rules Report How to navigate to this page> Typical display>
Manage the properties of a specific notification rule.
General Tab
Details of the rule.
| • | Description - for the new notification; |
| • | Query - the SQL query to be commited; |
| • | Active - whether the query is activated or not. |
Operations
From here you can:
| • | Test - to test that the SQL query is valid, click the Test button (left of the Save). If the query is OK then the thumbs-up icon is displayed as shown in this example (thumbs-down if not ok); |
| • | Save - click the Save button to apply the changes. If this is a new entry it will appear on the Notification Rules report; |
| • | Delete - click the Delete button to remove the entry. |
Example
In order to create a business notification an SQL statement may be written which must return a row containing a single column for each element that is in the notification state.
For example, if you want to have a notification that agents have been ready for more than 5 minutes, you need to create an SQL query that returns a list of the users for which the condition applies:
SELECT USER_NAME
FROM user_details
WHERE AGENT_STATE='Ready'
AND STATE_START_TIME<SUBTIME(NOW(),'00:05:00')
Where there is nothing to report then the query should return no results. The system will run this query periodically and raise the notification when results are returned, and clear it when elements no longer appear in the results of the query. A notification is raised for each row returned.