Follow-On Topics

Related Topics

# About the Filter Table Expression

Click the image to view full size.

The Filter Table Expression dialog box is displayed when the Filter button is selected in the Trigger tab. In the Main tab of the Tool an Oracle database and table are selected. You can configure the trigger to fire when a specific column is updated but through the Filter Table Expression dialog box you may also create a filter expression on column values.

For example, a table is used to store the value of orders received in a column called Value. The Task runs a report to list all orders received with a value in excess of £10,000 and then sends it to the Sales Manager.

The report could be scheduled to run on a regular basis but the manager requires the report to be run each time a new large value order is received.

The following expression is therefore created for the trigger Inserted.Value > = 10000 to cover occurrences where the value is equal to or exceeds £10,000.

The dialog box contains the following for creating a filter:

|  | Columns — Displays a list of columns available for the selected table.

|  | Logical Expression — The expression is manually entered into this area. Any columns listed in the Columns table may be dragged and dropped into the text box for inclusion in the filter expression.

Copyright © 2018 Quadrant Software B.V. All rights reserved.