Use the fields in the Filter Builder window to construct filter expressions. Click any area of the filter expression to change the values. Click Filter to add a condition or group, or use the Click this Button to Add a New Condition button to add a new condition. You can create multiple levels of filters with various conditions.
Select a column and then select an operand to limit your selection to a particular value or range of values. In the filter parameter field, enter the value or values to apply against the column. Based on the selections of the filter, the Data View grid displays the results.
The following condition operands and operands are available.
|
Condition Operand |
Function |
|
AND |
Use this condition operand to join two filters. Both conditions must apply. |
|
OR |
Use this condition operand to join two filters. Either condition can apply. |
|
NOT AND |
Use this condition operand to join two filters, the opposite of which applies (used with AND).
For example, the following filter displays all records that do not contain the employee first name of Ann and the last name of Smith.
First Name equals Ann NOT AND Last Name equals Smith |
|
NOT OR |
Use this condition operand to join two filters, the opposite of which applies (used with OR).
For example, the following filter displays all records that do not contain the employee first name of Ann or the last name of Smith.
First Name equals Ann NOT OR Last Name equals Smith |
|
Operand |
Function |
|
equals |
The filter using this operand displays rows in the Data View grid where the value for the selected column equals the value entered in the filter parameter field. |
|
does not equal |
The filter using this operand displays rows in the Data View grid where the value for the selected column is not equal to the value entered at the filter parameter field. |
|
is less than |
The filter using this operand displays rows in the Data View grid where the value for the selected column is less than and not equal to the value entered in the filter parameter field. |
|
is less than or equal to |
The filter using this operand displays rows in the Data View grid where the value for the selected column is less than or equal to the value entered in the filter parameter field. |
|
is greater than |
The filter using this operand displays rows in the Data View grid where the value for the selected column is greater than and not equal to the value entered in the filter parameter field. |
|
is greater than or equal to |
The filter using this operand displays rows in the Data View grid where the value for the selected column is greater than or equal to the value entered in the filter parameter field. |
|
like |
The filter using this operand displays rows in the Data View grid where the value for the selected column is like the value entered in the filter parameter field (where the character string matches a specified pattern). |
|
not like |
The filter using this operand displays rows in the Data View grid where the value for the selected column is not like the value entered in the filter parameter field (where the character string does not match a specified pattern). |
|
is blank |
The filter using this operand displays rows in the Data View grid where the value for the selected column is blank. |
|
is not blank |
The filter using this operand displays rows in the Data View grid where the value for the selected column is not blank. |
|
between |
The filter using this operand displays rows in the Data View grid where the value for the selected column is between the values entered in the filter parameter fields. |
|
not between |
The filter using this operand displays rows in the Data View grid where the value for the selected column is not between the values entered at the filter parameter fields. |
|
in |
The filter using this operand displays rows in the Data View grid where the value for the selected column is equal to one of a list of expressions entered in the filter parameter fields. |
|
not in |
The filter using this operand displays rows in the Data View grid where the value for the selected column is not equal to one of a list of expressions entered in the filter parameter fields. |
|
is yesterday |
The filter using this operand displays rows in the Data View grid where the value for the selected column is equal to yesterday's date.
Note This operand is available only for date type fields. |
|
is today |
The filter using this operand displays rows in the Data View grid where the value for the selected column is equal to today's date.
Note This operand is available only for date type fields. |
|
is tomorrow |
The filter using this operand displays rows in the Data View grid where the value for the selected column is equal to tomorrow's date.
Note This operand is available only for date type fields. |
|
is last week |
The filter using this operand displays rows in the Data View grid where the value for the selected column is any date in the last week.
Note This operand is available only for date type fields. |
|
is last month |
The filter using this operand displays rows in the Data View grid where the value for the selected column is any date in the last month.
Note This operand is available only for date type fields. |
|
is last year |
The filter using this operand displays rows in the Data View grid where the value for the selected column is any date in the last year.
Note This operand is available only for date type fields. |
|
is this week |
The filter using this operand displays rows in the Data View grid where the value for the selected column is any date in the current week.
Note This operand is available only for date type fields. |
|
is this month |
The filter using this operand displays rows in the Data View grid where the value for the selected column is any date in the current month.
Note This operand is available only for date type fields. |
|
is this year |
The filter using this operand displays rows in the Data View grid where the value for the selected column is any date in the current year.
Note This operand is available only for date type fields. |
|
is next week |
The filter using this operand displays rows in the Data View grid where the value for the selected column is any date in the next week.
Note This operand is available only for date type fields. |
|
is next month |
The filter using this operand displays rows in the Data View grid where the value for the selected column is any date in the next month.
Note This operand is available only for date type fields. |
|
is next year |
The filter using this operand displays rows in the Data View grid where the value for the selected column is any date in the next year.
Note This operand is available only for date type fields. |
