Creating a Learning Enrollment Notification
using Alert Composer (Resource Alerts)
V1.0
Version
21-Jul-2019
Date
Archana Murthy
Author
Step 1: Go to Navigator -> Tools -> Alert Composer
Step 2: Click on Add (as shown below) and select Resource Alert.
Step 3: Give the Alert a name – for this example I have chosen: Enrollment Confirmation Demo.
Select learnerLearningRecords for the Resource field. It is the REST resource for which we are creating
an alert (in this example – since it is Learning select learnerLearningRecords)
Note: Character limit for name is 80 and description is 2000 as of 20 July 2019.
Step 4: Select the Filter tab and click on Add Filter.
Step 5: Like in Step 3 select the Resource as learnerLearningRecords.
Step 6: Click on Add expression and follow the below steps as shown:
Step 7: Select the attribute and its corresponding column
Step 8: Select the operator and key in the code for the respective value.
ORA_JOIN_ASSIGNMENT
ORA_REQUIRE_ASSIGNMENT
Step 9: Give the expression(filter) a name as shown.
Step 10: By adding the above filter your alert is bound to trigger when a voluntary or required
assignment occurs (Make sure to select Any and NOT All).
But you would also want to add the filter that will send the alert notification to all the learners since its
last run.
Thus, add the below filter. To do so, we must first save our alert to obtain the ALERT_CODE.
Step 11: Select the Alert code as highlighted above. Click on Add filter. Select learnerLearning Records as
the resource. Click on Add Expression
And paste the below condition in the expression and give it a name for example LastRun (as shown
below)
exists (SELECT 'x' from dual where ${assignmentCreatedDate} >= (select
nvl(max(runs.run_end),sysdate-1) from hrc_alert_runs runs, hrc_alerts_b alerts where
runs.alert_id = alerts.alert_id and alerts.alert_code = '88110C4993E571F0E053C46D3B0A12C9'))
Step 12: Select the Templates tab and click on Add Template
Step 13: Give the Template a name and make sure to select Yes under Enabled and click on Edit ->
Manage Recipients and Message.
Click on Add Recipients
And add the below for the respective communication methods
Mail: ${[Link]([Link]).WorkEmail}
Worklist: ${[Link]([Link]).UserName}
For the message:
Dear ${[Link]([Link])},
Below course has been assigned to you:
${[Link]("<table border=\"1\"><tr><th>Learning Item Title</th> <th>Assigner Name</th><th>Due
Date</th><th>Assigned On</th><th>Deep Link</th></tr>")}
${[Link]('learnerLearningRecords','<tr><td>${learningItemTitle}</td><td>${assignerDisplayName}
</td><td>${[Link](assignmentDueDate,\'dd-MMM-
yyyy\')}</td><td>${[Link](assignmentCreatedDate,\'dd-MMM-yyyy\')}</td><td><a
${href}="${learningItemDeepLink}">${learningItemTitle}</a></td></tr>')}
${[Link]("</table>")}
Thanks,
${[Link]([Link])}
In order to add additional fields, click on insert expression as shown below.
The added expression has to be re-written to the below(remove formatXML and insert write)
Step 13: Click on Apply and save and close the alert. Reopen the alert and select the Run Options Tab
If you select Yes for Simulate, the alerts will not be triggered to the learners but merely just identifies
the learners and estimates the count. Thus when you are absolutely sure you can change the option to
No.
Select Yes for Log Activity History to check the logs when the alert is processed.
Select Automatically Run: Schedule if the purpose of the notification is dynamic.
Set the frequency as per requirement, here I have chosen hourly.
Click on Schedule.
Step 14: Make sure to enable the alert.
Email received by the learners
When assigned by the Office of the CEO
When assigned by an individual/self enrolled.