Specify the archive criteria for the table. Create queries 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 that 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.