Local custom filter

Top Previous Next

Local custom filter can be used to filter data in TO3000, Version 9.0 tables by certain columns. Filters are most commonly used as search tools.

To create or configure local custom filter click Edit button and adjust filter conditions. Once the filter has been turned On, all rows in the table which do not match filter parameters will be hidden.

You can apply last used filter by clicking Recent button.

Filter settings can be saved for re-use in the future without the need to set up filter parameters again.

Creating a filter

1. Click Edit button in the Local Custom Filter area at the bottom of TO3000, Version 9.0 window.

2. Click on the <Click here to add condition> string or click Add button to add a new condition line. Each condition has the following elements:

•	Field (column) name. By default the name of the first column of this table in database is displayed. Click to select a different column.

Note: Custom fields are available in these lists as well.

•	Condition. It depends on the type of data which is stored in selected column. These may include: "contains" (for text columns like Name), "greater (or less) than" (for numeric columns like Total), "not empty" and other.

•	Condition value. This is the parameter being searched or filtered. Click the <?> string to set the parameter for the selected field.

Note: To filter by property which has two possible values: "Yes" or "No" please select "is equal to" "0" to display records which has "No" value of this property and select "is equal to" "1" to display records which has "Yes" value of this property.

3. Click OK to switch on the filter or click Save button on the right first to save this set of conditions (so that you will not need to recreate it next time you want to select the item basing on such conditions).