Add a Notification Field

PREREQUISITES: The Notification Type security function and its associated sub-functions must be selected for the security role you belong to. See Security Roles for more information. Alternately, on the Employee Relates page, select Designer/Admin in the Module drop-down list and then use the Fields drop-down list to select the notification permissions you want to add. See Employee Relates for more information. You must have notification fields set up for the information you want to pull from the database. See Notification Fields for more information. This requires Cityworks 23.3 and newer.

1. From the home page, click PLL or Configure and click Notification Fields.
2. On the Notification Fields panel, click Add record.

3. Enter a 10-character (maximum) code in the Field Name field.
4. Enter a brief explanation in the Description field.

 

5. In the SQL Command field, write a SQL script that will retrieve specific information from the database to include in a notification. Click Verify SQL to check the validity of the script.

For example, the script shown above pulls from the CA_OBJECT_VW table and the "ca_object_id=SESSIONAOBJECTID" element tells the notification to pull the data from whichever case is open at the time.

NOTE: SQL commands retrieve data from the database exactly as it is stored there; Cityworks does not support data conversion in this process.

6. Click Add to create the notification, or click Add and New to create another notification.