Creating an alert

  1. From the homepage, select Maintenance > Messaging > Alert Definitions.
  2. Click Create New Entry.
  3. Specify this information:
    Alert Name
    Specify a name for the alert.
    Description
    Provide a description for the alert.
    Start Time
    Specify a start time for the alert.
    End Time
    Specify an end time for the alert.
    Source Type
    Select Query, ROWSOURCE, or EXTENSIONSCRIPT from the list.
    Source Sql
    If you selected Query from the Source Type list, specify the SQL query for the alert.
    Note:  As of release 2025.06, you can create SQL queries longer than 4000 characters.
    Source Class
    If you selected ROWSOURCE from the Source Type list, specify the rowsource builder class for the alert.
  4. Use these fields to specify the recipients of the alert:
    Recipient User Names
    Specify the users who will receive the alert.
    Recipient Team Names
    Specify the teams that will receive the alert.
    Recipient Role Names
    Specify the roles that will receive the alert.
    Send to Self
    Optionally, select this check box to send the alert to all the employees that are selected in the alert query. Employees can only see their own information.
    Note: When the Recipient Role Names or Send to Self options are used, the alert query must always contain an EMP_ID value.
    Recipient Check Scheduled
    Optionally, select this check box to send the alert to only employees who are scheduled to work.
  5. Use these fields to configure the alert message:
    Message Subject
    Specify the subject line for the alert notification.
    Message Header
    Specify the content of the header for the alert notification.
    Message Footer
    Specify the content of the footer for the alert notification.
    Send Message If Blank
    Optionally, select this check box to send alerts even if the query returns no results.
    Message Content Type
    Specify the message format that is used. You can select one of these formats:
    • text: Uses plain text to format the message.
    • HTML: Uses HTML to format the message.
    Notification Type
    Specify how alert messages are delivered. The default is Workmail. To send the notification as a push notification in Infor Go instead of a Workmail message, specify Push.

    See Push notifications.

    Drillback Parameters
    Specify ID1=${} and include values such as emp_id or emp_name to filter results for the alert notification.
    By default, the primary key of the drillback parameter is ID1.
    Note: You can further customize the drillback parameter. For example, to view employees with a last name that starts with "ka", you can specify ID202=ka.
    Extension Script
    Click the database lookup and select a script from the list to enable alerts using Groovy Extensibility. The list contains only the alert-type scripts from the scriptable extensions.
    Note: If you select EXTENSIONSCRIPT from the Source Type list, specify the Groovy Extension script for the alert.