Advanced filters and Sorting : Search and sort panel (print topic)

 Search and sort Click to expand and to collapse the Search and sort panel. When the panel is closed, the Address Lookup and City, State boxes appear.

Expand the panel for more advanced searches. The expanded panel lets you control which properties to show and define how to sort them. It also lets you save your filter/sort definitions so you can reuse it later without rebuilding it.

Auto checkbox: Reflect changes made without clicking the Refresh button.

Refresh Apply the current filter/sort definition to the dataset and show the results.

Clear quick filter / sort Remove all filters and sorting criteria and show the results.

Filtering fields list checkbox: Show the checklist for selecting the fields to filter and sort with. Checked fields appear in the table to the right so you can edit the filter/sort instructions. In the picture, Price is checked and so to put it in the table. The + sign next to Price in the header means 'sort the results by price in ascending order'. The order of the columns doesn't affect filtering, but it does prioritize sorting. (Note: the Beds field is also checked, but it is too far down on the list to show in the graphic.)

Output fields list checkbox: Show the checklist controlling which fields will appear in the output. In the picture, Adjustment columns will not appear.

Load… Opens the File Open dialog so you can browse to select a previously saved filter/sort definition.

Save… Opens a Save As… dialog so you can save the current definition to a file so you can reuse it in the future.

Filter / Sort definition table:

Sort Double click the field name to toggle the sort criteria from none, to ascending (+), to descending (-). Drag cell with the field name left or right to change sorting priority. (left = first, right = last). In example, sort ascending by Price (in this example, Beds doesn’t have a sort preface character).

Filter Enter filter values in appropriate cells, blank cells will be ignored. Properties shown must match all criteria. In the example shown, only records showing 3, 3.0, or 3.00 bedrooms will appear.

• Min row: only return records with values equal to or greater than the value in this row.

• Max row: only return records with values equal to or less than the value in this row.

• Equals row: only return records with values equal to the value in this row.

• Contains row: only return records that contain the same series of characters in this row.