Email Notifications: Difference between revisions

From QPR ProcessAnalyzer Wiki
Jump to navigation Jump to search
No edit summary
 
(19 intermediate revisions by the same user not shown)
Line 1: Line 1:
Notifications send automatic email messages based on defined rules, for example when there are deviations in the process requiring actions. Notifications are defined for models, and each model can contain several notifications. Notifications are sent based on the following logic:
Notifications functionality monitors processes based on defined rules and automatically send email messages to defined recipients, for example when there are deviations in the process flow requiring corrective actions. Notification rules are defined for models, and each model can contain several notification rules. When working with the notifications, the notification rules are first defined, including criteria for sending the email and message contents. When notification rules are in place, the sending of the notifications need to be scheduled using a script (alternatively users can initiate the sending in the UI).
# The optional '''filter''' is applied to the model data, or if there is not filter defined, the entire model data is used.
# If notifications are meant to be sent to different recipients with different content for each recipient, the data can be optionally divided into '''dimensions''' (notifications will be sent for each of the dimension values).
# If the email subject or body needs to contain dynamically changing information based on the actual data, '''measures''' can be defined which are calculated for each of the dimension values.
# As last, a '''criteria''' defining for example a threshold value, is applied for each of the dimension value (i.e. a potential notification), and based on it actual notification email is either sent or not. Dimensions and measures can be used in the criteria expression (as variables by their names).


== Creating notifications ==
When notifications are processed and sent, the following logic is applied, when dimensions are not used:
Notifications can be defined in '''Email notifications''' dialog, opened in the models list by selecting '''Notifications'''. The dialog contains a table of all notifications in the model, and notifications can be created, edited, deleted and sent. Defining notifications requires at least project Designer or project Administrator permissions (''GenericWrite'' permission).
# If the optional '''filter''' is defined, it's applied to the model data. If there is no filter, the entire model data is used.
# If the email subject or body needs to contain dynamically changing information, '''measures''' can be defined and used them in the email properties.
# '''Criteria''' defining for example a threshold value, is applied and based on it actual notification email is either sent or not. Measures can be used in the criteria expression (as variables by their names).


Each notification have following properties:
When dimensions are used, the logic is as follows:
* '''Name''': Name for the notification describing and identifying the notification in the table of model's notifications.
# If the optional '''filter''' is defined, it's applied to the model data. If there is no filter, the entire model data is used.
* '''To''', '''Cc''', '''Bcc''': To, cc and bcc addresses for the email message recipients. At least one valid email address needs to be defined in any of these fields.
# If notifications are to be sent to several recipients with different message for each recipient, the data can be divided into '''dimensions''' (notifications will be sent for each of the dimension values). If no dimensions is defined, maximum of one email message is sent.
* '''Subject''': Subject of the email message.
# If the email subject or body needs to contain dynamically changing information, '''measures''' can be defined and used them in the email properties. The measures are calculated for each of the dimension values.
* '''Body''': Body of the email message. The body can be defined as an html document, if the ''Body is html'' is checked.
# '''Criteria''' defining for example a threshold value, is applied for each of the dimension value (i.e. a potential notification), and based on it actual notification email is either sent or not. Dimensions and measures can be used in the criteria expression (as variables by their names).
* '''Model filter''': Model data is filtered using this filter, creating the dataset to be used for the notification calculation.
 
* '''Measures''': Measures are calculated for each of the dimension value (or the entire data, if no dimensions are defined). Measures can be used in the email fields and also in the Criteria expression.
== Defining notification rules ==
* '''Criteria''': Optional expression that determines whether the email is sent or not. For example, this can be used to define a criteria that the notification is sent only if a measure is greater than the defined threshold value.
Notification rules can be defined in '''Email notifications''' dialog, that can be opened in the models list by selecting '''Notifications'''. The dialog contains a table of all notification rules in the model, and there notifications can be created, edited, deleted and sent. Defining notifications requires at least project Designer or project Administrator permissions (''GenericWrite'' permission).
* '''Body is html''': When checked, the email body is an html document. If unchecked, the email body is plaintext.
 
Notification rules can be double-clicked or select a row and click the ''Edit'' button, to open a dialog for editing a notification rule. Each notification rule have following properties:
* '''Name''': Name for the notification rule describing it shortly and identifying it in the model notifications list.
* '''To''', '''Cc''', '''Bcc''': List of to, cc and bcc recipient addresses for the email message. At least one email address needs to be defined in any of the fields. One address is mandatory.
* '''Subject''': Subject of the email message. Cannot be empty.
* '''Body''': Body of the email message. The body can be defined as an html document, if the ''Message is html'' is checked.
* '''Model filter''': This filter is applied to the model data, creating the dataset to be used for the notification calculation. The filter can be used to narrow down the data related to which to send the notifications to.
* '''Measures''': Measures are calculated for each of the dimension value (or the entire data, if no dimensions are defined). Measures can be used in the email fields and in the criteria expression.
* '''Criteria''': Expression that determines whether the email is sent or not. For example, the criteria can be used to define that the notification is sent only if a measure is greater than the defined threshold value. The criteria expression is optional, and if not defined, the notification is always sent.
* '''Message is html''': When selected, the email body is interpreted as an html document. If unselected, the email body should contain plain text.
* '''Priority''': Priority of the email message: ''High'', ''Normal'' or ''Low''.
* '''Priority''': Priority of the email message: ''High'', ''Normal'' or ''Low''.
* '''From email address''': Email address where the notification appears to be coming from. If there is a default from address defined for the system, this field can be left empty.
* '''From email address''': Email address where the notification appears to be coming from. If there is a default from address defined for the system ([[PA_Configuration_database_table#SMTP_Server_Settings|SmtpFromAddress]]), this field can be left empty.
* '''Sender''':
* '''Reply to addresses''': One or several email addresses which appear as recipients when replying to the notification email.
* '''Reply to address''': One or several email addresses which appear as recipients when replying to the notification email.
* '''Dimensions''': Dimensions can be used if the defined notification needs to send several emails to different recipients (for example, related to each region, product, customer or other attribute). If no dimensions are defined, one notification email is sent related to the defined notification.
* '''Dimensions''': Dimensions can be used the notification definition needs to send several emails to different recipients (for example, related to each region, product or customer). If no dimension is defined, only one notification email is sent.


To add dynamically changing content to the fields defining the email message (e.g. To, Cc, Bcc, Subject, Body), it's possible to use measure and dimensions names using syntax '''${name}'''. It's also possible to define expressions inside the similar curly brackets.
To add dynamic content to the fields defining the email message (e.g. To, Cc, Bcc, Subject, Body), the measure and dimensions names can be used with syntax '''${name}'''. It's also possible to define expressions in the same curly brackets, e.g. '''${name.Substring(0,20)}'''.


Example for email subject (assuming there is a measure ''numberOfCases''):
Example for email subject (assuming there is a measure ''numberOfCases''):
Line 36: Line 42:


== Sending notifications ==
== Sending notifications ==
Notifications can be sent ("triggered") either in the ''Email notifications'' dialog by clicking the '''Send notifications''' button, or by using the '''Model.TriggerNotifications()''' function in the expression language. Note that actual emails might not necessarily be sent depending on the criteria defined by the notifications. Notifications can be triggered from the SQL scripts as follows (notifications ''Notification 1'' and ''Notification 2'' for model id 123):
Notifications can be processed and sent either in the ''Email notifications'' dialog by clicking the '''Send notifications''' button, or by using the [[QPR_ProcessAnalyzer_Objects_in_Expression_Language#TriggerNotifications|Model.TriggerNotifications()]] function in the expression language. Note that no actual emails might necessarily be sent if the the criteria for sending the emails is not fulfilled. Note also that triggering the notifications only starts the processing, so neither the Send notifications button nor the TriggerNotifications return any errors if the notification processing fails.
 
Notifications can be sent from SQL scripts as follows (notifications ''Notification 1'' and ''Notification 2'' for model id 123):
<pre>
<pre>
(SELECT 'AnalysisType', '33') UNION ALL
(SELECT 'AnalysisType', '33') UNION ALL
Line 43: Line 51:
--#GetAnalysis
--#GetAnalysis
</pre>
</pre>
== Setup walkthrough ==
Let's define a notification which is sent if a certain case attribute value occurs in a case.
# Open the '''Notifications rules''' dialog for a model and click '''Add notification rule'''.
# In the ''General'' tab, define a name for the notification rule and a '''To''' address.
# In the ''Measures'' tab, click the ''plus'' button and define a measure name ''notifiedCases''.
# Select ''Cases with specific case attribute value'', select a case attribute and a value.
# In the General tab, define a ''Subject'' with following content: ''There are ${notifiedCases} cases requiring actions!''.
# Go to the '''Preview emails''' tab to see how the email contents is created.
# Define a body text for the email message. You can either use plain text or an html document. When using plain text, uncheck the ''Message is html'' checkbox in the ''Advanced'' tab.
# Now the email is sent always when this notification rule is triggered. To define a criteria for the sending, go to the '''Sending criteria''' tab and add criteria '''notifiedCases > 10'''. This criteria means that the notification is only sent when there are more than 10 cases having that case attribute value. You can check from the Preview emails tab, that if the criteria is not fulfilled, no email is sent.
# You can then define a filter, if you want to send the notification only related to certain regions data or any other case attribute value. To do this, go to the '''Model filters''' tab and add a filter rule.
# To send several emails related to this notification rule, go to the '''Advanced''' tab and add a dimension (e.g. select a case attribute).
# Go to the Preview emails tab and see that there is a table where there is a row for each email to be sent (each case attribute value.
# You can also add the dimension value to the email message  body (to identify which value the message is related to) with syntax '''${dimensionName}'''. Again go the the Preview emails tab, to see the generated emails messages.


[[Category: QPR ProcessAnalyzer]]
[[Category: QPR ProcessAnalyzer]]

Latest revision as of 19:37, 11 December 2021

Notifications functionality monitors processes based on defined rules and automatically send email messages to defined recipients, for example when there are deviations in the process flow requiring corrective actions. Notification rules are defined for models, and each model can contain several notification rules. When working with the notifications, the notification rules are first defined, including criteria for sending the email and message contents. When notification rules are in place, the sending of the notifications need to be scheduled using a script (alternatively users can initiate the sending in the UI).

When notifications are processed and sent, the following logic is applied, when dimensions are not used:

  1. If the optional filter is defined, it's applied to the model data. If there is no filter, the entire model data is used.
  2. If the email subject or body needs to contain dynamically changing information, measures can be defined and used them in the email properties.
  3. Criteria defining for example a threshold value, is applied and based on it actual notification email is either sent or not. Measures can be used in the criteria expression (as variables by their names).

When dimensions are used, the logic is as follows:

  1. If the optional filter is defined, it's applied to the model data. If there is no filter, the entire model data is used.
  2. If notifications are to be sent to several recipients with different message for each recipient, the data can be divided into dimensions (notifications will be sent for each of the dimension values). If no dimensions is defined, maximum of one email message is sent.
  3. If the email subject or body needs to contain dynamically changing information, measures can be defined and used them in the email properties. The measures are calculated for each of the dimension values.
  4. Criteria defining for example a threshold value, is applied for each of the dimension value (i.e. a potential notification), and based on it actual notification email is either sent or not. Dimensions and measures can be used in the criteria expression (as variables by their names).

Defining notification rules

Notification rules can be defined in Email notifications dialog, that can be opened in the models list by selecting Notifications. The dialog contains a table of all notification rules in the model, and there notifications can be created, edited, deleted and sent. Defining notifications requires at least project Designer or project Administrator permissions (GenericWrite permission).

Notification rules can be double-clicked or select a row and click the Edit button, to open a dialog for editing a notification rule. Each notification rule have following properties:

  • Name: Name for the notification rule describing it shortly and identifying it in the model notifications list.
  • To, Cc, Bcc: List of to, cc and bcc recipient addresses for the email message. At least one email address needs to be defined in any of the fields. One address is mandatory.
  • Subject: Subject of the email message. Cannot be empty.
  • Body: Body of the email message. The body can be defined as an html document, if the Message is html is checked.
  • Model filter: This filter is applied to the model data, creating the dataset to be used for the notification calculation. The filter can be used to narrow down the data related to which to send the notifications to.
  • Measures: Measures are calculated for each of the dimension value (or the entire data, if no dimensions are defined). Measures can be used in the email fields and in the criteria expression.
  • Criteria: Expression that determines whether the email is sent or not. For example, the criteria can be used to define that the notification is sent only if a measure is greater than the defined threshold value. The criteria expression is optional, and if not defined, the notification is always sent.
  • Message is html: When selected, the email body is interpreted as an html document. If unselected, the email body should contain plain text.
  • Priority: Priority of the email message: High, Normal or Low.
  • From email address: Email address where the notification appears to be coming from. If there is a default from address defined for the system (SmtpFromAddress), this field can be left empty.
  • Reply to addresses: One or several email addresses which appear as recipients when replying to the notification email.
  • Dimensions: Dimensions can be used if the defined notification needs to send several emails to different recipients (for example, related to each region, product, customer or other attribute). If no dimensions are defined, one notification email is sent related to the defined notification.

To add dynamic content to the fields defining the email message (e.g. To, Cc, Bcc, Subject, Body), the measure and dimensions names can be used with syntax ${name}. It's also possible to define expressions in the same curly brackets, e.g. ${name.Substring(0,20)}.

Example for email subject (assuming there is a measure numberOfCases):

Process is blocked for total of ${numberOfCases} orders

Another example where there is an embedded expression using the ${...} syntax:

Process is blocked for total of ${Count(EventLog.Cases)} orders

Sending notifications

Notifications can be processed and sent either in the Email notifications dialog by clicking the Send notifications button, or by using the Model.TriggerNotifications() function in the expression language. Note that no actual emails might necessarily be sent if the the criteria for sending the emails is not fulfilled. Note also that triggering the notifications only starts the processing, so neither the Send notifications button nor the TriggerNotifications return any errors if the notification processing fails.

Notifications can be sent from SQL scripts as follows (notifications Notification 1 and Notification 2 for model id 123):

(SELECT 'AnalysisType', '33') UNION ALL
(SELECT 'ContextType', 'Generic') UNION ALL
(SELECT 'Configuration', '{"Root":"ModelById(123).TriggerNotifications([""Notification 1"", ""Notification 2""])"}')
--#GetAnalysis

Setup walkthrough

Let's define a notification which is sent if a certain case attribute value occurs in a case.

  1. Open the Notifications rules dialog for a model and click Add notification rule.
  2. In the General tab, define a name for the notification rule and a To address.
  3. In the Measures tab, click the plus button and define a measure name notifiedCases.
  4. Select Cases with specific case attribute value, select a case attribute and a value.
  5. In the General tab, define a Subject with following content: There are ${notifiedCases} cases requiring actions!.
  6. Go to the Preview emails tab to see how the email contents is created.
  7. Define a body text for the email message. You can either use plain text or an html document. When using plain text, uncheck the Message is html checkbox in the Advanced tab.
  8. Now the email is sent always when this notification rule is triggered. To define a criteria for the sending, go to the Sending criteria tab and add criteria notifiedCases > 10. This criteria means that the notification is only sent when there are more than 10 cases having that case attribute value. You can check from the Preview emails tab, that if the criteria is not fulfilled, no email is sent.
  9. You can then define a filter, if you want to send the notification only related to certain regions data or any other case attribute value. To do this, go to the Model filters tab and add a filter rule.
  10. To send several emails related to this notification rule, go to the Advanced tab and add a dimension (e.g. select a case attribute).
  11. Go to the Preview emails tab and see that there is a table where there is a row for each email to be sent (each case attribute value.
  12. You can also add the dimension value to the email message body (to identify which value the message is related to) with syntax ${dimensionName}. Again go the the Preview emails tab, to see the generated emails messages.