The Data Filter dialog enables you to set filter rules to define which data is loaded and displayed in the Table Data Editor. Each time you use this dialog, the data is reloaded into the editor based on the rules you specify. To access the Data Filter dialog, click the Filter icon in the Table Data Editor toolbar.
The dialog consists of two tabs described below.
The Filter tab lists all columns in the table and enables you to set filter rules for each column. It is comprised of the following elements:
- List of Columns in Table
- The Filter list displays all table columns. Select filter options in Select By to view in the Table Data Editor only data in which you are interested.
- Data Type of Column
- The Types list shows the column data type.
- Selection of Filter Rule
- In Select By, create a filter rule to apply to the column. Use the list to select a filter operator and enter a value. For example, you could specify a rule that filters column data for only values greater than 1000. Filter operators are based on column data type.
- Filter Rules by Column
- The Data Filter dialog provides the ability to define specific filter rules for each column in the selected table. Use this area to define, review, and refine your Table Data Editor view for specific tables. The default is None.
- Clear All Button
- Click Clear All to reset filter rules for all columns to None.
- List of All Columns in Table
- A list of all table columns displays in the Table Columns selection box. You can order the list in either ascending or descending order by table name.
- Ordered List of Columns for Sort
- Move columns from Table Columns to Sort Columns to specify the column sort order. Use Up and Down to change column order.
- Choice Buttons: Order Table Column List
- Choose how you want the column list ordered:
- Ascending - Orders the Table Columns list from the smallest or lowest to the largest or higher value. For example, A to Z or 1 to 100. This is the default.
- Descending - Orders the Table Columns list from the largest or higher value to the smallest or lowest value. For example, Z to A or 100 to 1.
- Action Buttons: Order Columns for Sorting
- Move columns up or down in the list. The sort operation uses the column order to determine sorting rules. The primary sort is based on the first column in the list.