Notifications Logging

This screen allows you to identify a specific field in an Ostendo Database which, when a record is added, changed, or deleted and this field is contained in that record then a Notification Log is created that records the old value and the new value along with a notification Flag.   This record and flag can then be addressed by a script and actioned accordingly. 

(For example: The Script could be a ‘Command Line Script’ and scheduled to run on a regular basis to view the Notification Log Table for ‘Sales Deliveries’.  From that the Script could generate an email and inform the Customer of the delivery)

Entry and Display fields

Table Name:  From the drop-down select the Ostendo Table Name against which you are creating a Notification Log.

Field Name:  For the Table Name selected in the previous field Ostendo will present you with a drop-down list of all Field Names used by that Table.  Select the Field Name against which you are creating a Notification Log.

SQL Type:  From the drop-down list select the screen event at which this Notification Log will be applied.  The options are Insert, Update, or Delete.

Buttons

Close: This will close the Notifications Log screen.  If you have any unsaved data then you will be asked if you wish to save it before the screen is closed.

Add: This will take you to a new line for entry of a new Notifications Log record.

Save: This will save the current data without exiting the screen

Cancel: Any changes made to the Notifications Log record or the last time the ‘Save’ Button was pressed will be lost.

Delete: This will delete the highlighted Notifications Log record