Unable to use fields from cmn_rota_roster in On-Call Reminder notification (which is for cmn_rota_roster table). The substitution for field references such as ${rota.group.name} return a blank value instead of the expected value.

Steps to Reproduce

  1. Add ${rota.group.name} to the subject or body of the notification named On-Call Reminder.
  2. Trigger the notification by navigating to a rota record (cmn_rota.list) that has value for group and clicking the Resend Reminders UI action.
  3. Review the sys_email record that is generated after the rota.on_call.reminder event is processed.


  1. Open the OnCallRemindersNG Script Include: sys_script_include.do?sys_id=737302d60a0a2c9648e2880d323fa067.
  2. Find the sendEmails method and change: 

    gs.eventQueue("rota.on_call.reminder", users[userID], userID, html + this.getStyle(userID));   
    gs.eventQueue("rota.on_call.reminder", rotaGR, userID, html + this.getStyle(userID));

  3. Open the On-Call Reminder email record: sysevent_email_action.do?sys_id=9eec63600a0a0b4c00e829e2f0691f95.
  4. Change the Table from Roster [cmn_rota_roster] to Rota [cmn_rota]
  5. Now you have access to the Rota record within the Message mail_script and Subject, so you can add the following the Subject in the What it will contain tab: 

    On-Call Schedule: ${group.name}

    Note: Please remove update records from this list to ensure you receive future fixes and feature enhancements:


Related Problem: PRB663497

Seen In

Fuji Patch 11
Fuji Patch 7 Hot Fix 5

Fixed In


Associated Community Threads

There is no data to report.

Article Information

Last Updated:2016-06-27 14:32:59