Specify Archive Criteria

Specify Archive Criteria

Specify the archive criteria for the table. Queries can be created for multiple columns in the selected table by using "AND" or "OR" between each individual query.

Select ... From

This box displays the archive query.  Queries must be a valid SQL query, starting with "WHERE" and can either be entered directly, or by using the Columns and Operators.

Table Name

The table the query is performed against. By default this is populated with the selected Archiving Table.

Columns

This box lists all the columns for the Table Name. Double-click a column to configure a query for it.

Operators

The list of operators to use in the query. Double-click an operator to add it to the query.

Delete Rows

Select this box to have the archived rows deleted from the source database after a successful archive.