Thursday, 29 October 2020

Tutorial - Notifications

Automated Notifications can be configured by accessing the Setup > Notifications menu.


There are 4 major configuration groups:

  1. Email Content - Mirrors the Send Email action configuration and the full set of parameters supported. 

  2. Recipients - Mirrors the Send Email action configuration.

  3. Scheduling - Mirrors the Process Definition Scheduler.

  4. Filters - You have the option to either select a Dashboard which will apply the Transaction Filters configured on the Dashboard, or to specify custom filter criteria o be reported on.


Notes:

  1. The @LastImportRuntime parameter is only available when a Dashboard filter is used and this parameter must be enclosed in single quotes when used - ‘@LastImportRuntime’

  2. Instruction Type filters are only applied to the following parameter calculations - @InstructionDeliveredUnmatchedCount & @InstructionDeliveredUnmatchedAmount

  3. On the Process Log screen, a new filter option called ‘Show Notification Processes’ can be enabled to monitor threads. All notification queries use NO LOCK hints in SQL so there are no expected database locks when using this functionality.


Sample 1:  Message Body - Notification for unmatched transactions at end of day.

Select 'ATT: Payments Team


There are '+ convert(varchar(50),@InstructionDeliveredUnmatchedCount) + ' transactions sent to the bank without a response. The value of these transactions are R' + convert(varchar(50),@InstructionDeliveredUnmatchedAmount) + '.


Regards

Central Park Notification Services'


Sample 1: Results

ATT: Payments Team


There are 45 transactions sent to the bank without a response. The value of these transactions are R22041074.16.


Regards

Central Park Notification Services




Sample 2:  Message Body - Notification for unmatched transactions at end of day that are only sent when there are unmatched transactions.

Select 'ATT: Payments Team


There are '+ convert(varchar(50),@InstructionDeliveredUnmatchedCount) + ' transactions sent to the bank without a response. The value of these transactions are R' + convert(varchar(50),@InstructionDeliveredUnmatchedAmount) + '.


Regards

Central Park Notification Services'


Where @InstructionDeliveredUnmatchedCount > 0


Sample 2: Results

If ‘@InstructionDeliveredUnmatchedCount = 0’ (indicating no unmatched transactions), no email will be sent. If ‘@InstructionDeliveredUnmatchedCount > 0’ as per the ‘Where condition’, the email body will be the same as Sample 1 Results.

No comments:

Post a Comment