Configure an Alert

Writing the SQL query that is used to trigger the alert requires some knowledge of the MineMarket database structure. The MineMarket Data Dictionary is provided with each MineMarket release. Contact your Datamine representative for assistance with this configuration.

If the SQL query returns any records from the MineMarket database, the alert is triggered.

Note: Alerts must be licensed to run.
Security Note: You need the Allow alert maintenance security right in the Alerts user group security rights group for this activity.

Activity Steps

  1. Open the Alert Editor.
  2. Select the Alert tab.
  3. Right-click in the Alerts field group and select New from the menu.
  4. Enter the alert message text in the Message Text field group.

    Use {} to include a field returned from the SQL query.

  5. Enter the SQL query in the Query String field group.

    Alerts cannot be saved until a valid SQL query has been entered. The query must contain at least one column heading in the SELECT clause.

  6. Click Test Sql.

    Returned records display in the Query Result field group.

  7. Complete the following fields.
    • Name
    • Enabled
    • Frequency Type—Select from Run Once and Every n Minutes.
  8. If the frequency type is Every n Minutes, enter the Query Frequency in minutes.
  9. Select the Relevant Object Field, which is the MineMarket object to be displayed when the user clicks the alert link on an alert triggered by this alert configuration.

    Select from data fields in the Key Identity Data Fields field group.

  10. Select the Relevant Object Type, which is the type of MineMarket screen to be displayed when a user clicks the alert link on an alert triggered by this alert configuration.

    Select from all MineMarket object types. Ensure that the object type is suitable for the selected Relevant Object Field. For example, an alert is configured for sales invoices. To display the sales invoice when the user clicks the alert link, the relevant object field is InvoiceID and the relevant object type is SalesInvoice.

  11. Complete the following fields.
    • Message Duration—How long the alert displays in seconds.
    • User Groups—All users in the selected user group receive the alerts.
    • Message Severity—Select from Information, Question, Warning or Critical.
    • Redisplay Triggered Alerts—If checked, the alert message is redisplayed at the specified Redisplay Frequency (in minutes) until the situation that triggered the alert is resolved.
  12. Check the fields in the Key Identity Data Fields field group that are needed to ensure that each alert instance is unique. See Alerts for examples.
  13. To send the alert as an email:
    1. Check Email Alert.
    2. Complete the following fields.
      • Email Frequency—Amount of time, in minutes, after which another email is sent if the situation that triggered the alert is not yet resolved.
      • Email Group—Select from the email groups configured on the Email Settings tab.
  14. To use a custom screen in which to display the alert instead of the default message pop-up:
    1. Check Use Custom Editor.
    2. Select the Alert Trigger Custom Form.
  15. Click Save.
  16. Click Test Alert.

    The alert is tested, including sending an email if email is configured for the alert.

    The test only includes the message as entered in the Message Text, including field names. Data returned from the SQL query test does not display in the alert test.