Follow-On Topics

Related Topics

# About the Table Filter Expression

The Table Filter Expression dialog box displays the available columns from the selected table (see About the SQL Server Browser) to create the trigger expression. For example, a table is used to store invoices. The Task runs a report to list all invoices with a value in excess of £500.00 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.ITEMS_NET > = 500.00` to cover occurrences where the value is equal to or exceeds £500.00. | Click the image to view full size.

The dialog box contains the following for creating a filter:

|  | Columns — Displays a list of tables and columns that are created when the trigger is fired. Inserted and deleted tables and columns are created for each available column in the selected table.

|  | Logical T-SQL Expression — The expression is entered into this area. Any table and column listed in the Columns table can be dragged and dropped into the text box for inclusion in the filter expression. NOTE: At the time of writing, the use of wildcards in the T-SQL expression is not supported. Nor can you make use of task or global variables here.

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