Progressive column filtering

You can configure the SQLDataGrid to support progressive column filtering. Type the first letters of your search, and the matching values appear in the grid.

To configure and use progressive filtering

1. Switch your SQLDataGrid window to WindowMaker mode.

2. Double-click the graphic and select the custom property ColumnFiltering.

3. Set the ColumnFiltering default value to True.

   

4. Select OK and run the InTouch application.

5. To return a dataset, select Retrieve. In this example, the dataset contains a table view of customer names and addresses.

   

6. Move your cursor over the field below the LastName column heading. A list arrow appears.

7. You can filter the values by any of the following actions:

   • Select the list arrow and type the first letter of the value If you type additional letters, your sort is more precise.

     

   • Select the list arrow and select an item from the list.

     

   • If you select the (Custom) item from the list, you can further refine your search in the Custom dialog box. This example shows a search for two different area codes.

     S

8. To perform a different search, clear your search criteria by selecting the cancel icon at the left of the filtering row.