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.
|
Operator |
Description |
|---|---|
|
= |
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. |
|
Not Like |
A value that is different to the one in the [value] field. You can use the following wildcard characters: |
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.