Defining after SQL statements for alerts - HxGN EAM - 12.0.1 - Help - Hexagon

HxGN EAM Help

Language
English
Product
HxGN EAM
Search by Category
Help
HxGN EAM Version
12.0.1

Define SQL statements for system to execute after executing the defined grid query and after creating e-mail and work order alerts.

  1. Select Administration > Setup > Alert Management.

  2. Select the alert for which to define the after SQL statement, and then click the After SQL tab.

  3. Specify this information:

    SQL Statement - Specify the SQL statement that will be executed after the grid query and alerts.

    Comments - Specify comments regarding the SQL statement.

    Execute when Previewing Grid - Select to execute the SQL statement when Grid Preview is selected.

    Active - Select to set this SQL statement record to active. The SQL statement is processed after the grid query is processed.

    To process the after SQL statement when the alert job is run or Grid Preview is selected on the Record View page of the Alerts form, you must select Active.

  4. Click Save.

Click Test SQL to check the validity of the SQL statement.