Allows you to define a filter expression that filters the selected source table. This way you can import only specific items that you include in the filter expression.
Field
Allows you to select a field from the current source table.
Operator
Allows you to select a filter operator. The operators are as shown below.
=
Equal to
>
Greater than
<
Less than
<>
Not equal to
>=
Greater than or equal to
=<
Less than or equal to
Like
A value that is similar to the one in the [value] field. You can use the following wildcard characters:
-
% - any combination of characters.
-
_ (underscore) - any single character
Not Like
A value that is different to the one in the [value] field. You can use the following wildcard characters:
-
% - any combination of characters.
-
_ (underscore) - any single character
Value
Allows you to type a filter value.
OR
Adds an "OR" expression to the filter.
AND
Adds an "AND" expression to the filter.
Add
Adds another expression row.
Clear Filter
Resets the current filter expression.
Data Window
Displays the current filter expression. Also, allows you to type and edit a filter expression.