Filter Table Window

The Filter Table window lets you set rules to retrieve specific results for data in a document or report.

To open this window, open the document or report and choose (Filter Table...).

Note Note

This topic documents fields and other elements in this window that either are not self-explanatory or require additional information.

End of the note.

Field
Displays the fields of the selected report or document, for example, G/L Accounts and Business Partners.

Rule

Select the rule according to which you want to filter the records.

Note Note

The following table explains the various available filter rules.

Filter Rules
Filter Value	Description
Equal	Displays all rows with records that equal the value in the Value field.
Not Equal	Displays all rows with records that do not equal the value in the Value field.
In Range	Displays all rows with records that are within the range of values between the Value and To Value fields.
Out of Range	Displays all rows with records that are outside the range of values between the Value and To Value fields.
Greater than	Displays all rows with records that are larger than the value in the Value field.
Greater or Equal	Displays all rows with records that are larger than or the same as the value in the Value field.
Smaller than	Displays all rows with records that are smaller than the value in the Value field.
Smaller or Equal	Displays all rows with records that are smaller than or the same as the one in the Value field.
Is Empty	Displays all rows that do not contain any records.
Is Not Empty	Displays all rows that contain records.

End of the note.

Value
From the dropdown list, select a value to match the rule. Alternatively, you can enter a value in the field. To do this, select the blank option from the dropdown list.

To Value
If the rule that you have selected is either In Range, or Out of Range, select a value. For all other rules the field is disabled.

Filter
Confirms filter definitions. After confirming, choose OK to close the window.

Cancel
Cancels the selections you just made and closes the window.

Clear
Deletes all filter definitions that you have made. For this deletion to take effect, you must choose OK.