Early Warning Query (EWQ) - Intergraph Smart Materials - Version 10.1 - Administration & Configuration - Hexagon

Intergraph Smart Materials Classic Administration (10.1)

Language
English
Product
Intergraph Smart Materials
Subproduct
Classic
Search by Category
Administration & Configuration
Smart Materials/Smart Reference Data Version
10.1

On the A.60.10 Early Warning Queries screen, you can define early warning queries for early warning alerts. On this screen, you write the query and specify the interval or frequency for it to be run.

These queries are assigned to users and/or roles and are started on the A.60.11 Early Warning Setup screen or by defining a job on the A.60.45 DBMS Jobs screen, executing the m_pck_ewn.process_warnings procedure.

Specify an alert name for the query in the Alert Code field. This name identifies the query and appears in the subject of the warning e-mail.

Select an interval from the drop-down list in the Interval field. The available values are:

  • Every 15 minutes

  • Hourly

  • Daily

  • Weekly

  • Monthly

  • Annually

The interval determines how often the query is run. The query is only executed if the system date is greater or equal to the last execution date + interval.

Select a value from the drop-down list in the Mail Content field. The available values are:

  • ALL - All new, modified, and deleted items are listed.

  • CHANGES - Only modified items are listed.

  • NEW - Only new items are listed.

  • DELETED - Only deleted items are listed.

  • CURRENT - Only new and changed items are listed.

The selected value controls the information that is included in the generated alert message. This content is related to the previous generated alerts.

The Last Execution field displays the date and time of the previous run of this query.

Select the Active check box to activate the selected early warning query. If the check box is not selected, the query is turned off and is not executed.

Select the eMail check box to activate the sending of emails containing the alert information. If this check box is not selected, e-mails are not sent.

If you select the Separate check box, the early warning query is excluded from the general processing done by the command m_pck_ewn.process_warnings on A.60.45 DBMS Jobs. Instead, the query can be executed by m_pck_ewn.process_warning(<ALERT CODE>, <PROJ_ID>) on A.60.45; the parameters are the alert code and the definition project of the query on A.60.10. An example is displayed in the picture below.

Using this command causes the execution of the job according to the definitions on A.60.45. The execution interval set on A.60.10 is not considered.

Jobs defined with the interval ‘Daily’ will be executed each day at the time originally specified in the Start Date field.

By default, the One mail per record check box is not selected, which means that only one e-mail is sent containing all records. Select this check box to send an e-mail for each record selected by the query statement.

Select the Generate Link check box to activate the sending of an e-mail containing the URL for the macro login. This macro login functionality is only available and can only be set for the following screens: P.20.01, R.30.01, P.30.11, P.50.01, and S.50.06. The corresponding screen must be entered from the Direct Link Form field. For more information, see Macro Login Setup

Enter a brief explanation or description about the early warning query in the Alert Description field.

The Direct Link Form field allows you to assign the alert to a specific screen. Select the screen from the drop-down list in this field. If you specify a direct link form for a query, you must include the ID column related to that form in your query. The available screens with their related IDs are listed in the table below.

Direct Link Form

Required ID Column

C200102

MRR_ID

C2001

LOC_ID

P2001

SUP_ID

P3011

INQ_ID

P5001

POH_ID

P6003

ECI_ID

R3001

R_ID

S5006

SPEC_HEADER_ID

SM2001

POH_ID

SM2011

POH_ID

SM3001

SFI_ID/SFN_ID

SM3002

CSR_ID

SM3003

CSL_ID

SM3004

ITW_ID

SM3005

POH_ID

SM3006

TPW_ID

SM3007

NCR_ID

SM3008

IW_ID

SM3009

NTC_ID

SM4001

PCO_ID

SM4002

CNR_ID

SM4003

FWD_ID

SM4004

CNR_ID

SM4005

BN_ID

In the Query Text box, write the SELECT statement or PL/SQL block used to perform the query. Write the statement in PL/SQL syntax. Do not use semi-colons (;). For example:

SELECT count(*) FROM m_users

Click the Parse Query button to check the consistency of the query text. If the statement is valid, you receive the ‘Statement successfully compiled’ message. Otherwise, you receive the ‘Statement compiled with errors’ message.

Click the Validate Settings button to check all settings required for the automatic execution of early warning queries. The result of this check is displayed in the Validation Results window as shown in the picture below.

All packages and java classes shown in the result list must be in a valid state. These objects are part of the standard installation of Smart Materials.

The ‘Scheduled Jobs’ section displays the jobs that will execute early warning queries. For more information, see Automatic Early Warning Execution.

In the Email Header field, enter the text for the subject line of the generated email.

In the Message Returned box, you can define a customized message in which the query results are included. This field is very important because it defines how the query results are included in the body of the e-mail message. For example: ‘There are at the moment %1 users registered’. The %1 in this text will be replaced by the return value of the query statement.

Click the button to open window 3 where you can assign additional email addresses.

Each e-mail generated by the selected early warning query is sent to these e-mail addresses as CC (carbon copy).

Select the e-mail address of a user defined on A.20.05 from the LOV in the Email field.