Modifying the Stored Procedure Used by a Mobile Notification

After you have created a mobile notification and edited the mobile notification template, you must modify the stored procedure being used by the mobile notification to include the Master Customer ID and Sub Customer ID.

To modify the mobile notification stored procedure:

1. From the Notification Maintenance search screen, open the appropriate mobile notification or create a new mobile notification.

2. From the Stored Procedures section, note the name of the stored procedure used by the mobile notification.

3. Open the stored procedure in Microsoft SQL Server Management Studio or any other SQL script editor.

4. Navigate to the first SQL selection statement in your notification event procedure where you select the list of email addresses to receive the notification.

5. Modify the code to include the following code:
[CUS]. [MASTER_CUSTOMER_ID] [MASTER_CUSTOMER_ID],
[CUS]. [SUB_CUSTOMER_ID] [SUB_CUSTOMER_ID]

Ensure that you have included the correct alias in your query. For the most part, the Master Customer ID will come from the same table as EMAIL Address.

6. Repeat for each instance of a SQL selection statement in your notification event procedure where you select the list of email addresses to receive the notification.

7. Save the stored procedure.