About the List View Window

The List View window displays a list of database records in the open database. It might show a complete list of all database records, or, if you use the Find feature, it might show only those records that are found (the “found set”). The List View and Detail View windows appear whenever you open a database.

To view the List View window
Do one of the following:
  • Choose Window > List View (or press Command-1).

  • Drag the Detail View window to a different screen position.

  • Click the List View window to bring it to the front.

Figure. List View window.

The Show All and Find buttons allow you quickly either to show all of the records in the open database (click Show All) or to show a specific set of records by using the Find dialog (click Find). See Finding and Opening Database Records for information about using the Find button.

The pop-up menu at the top-left corner of the window lets you choose the display mode, determining the type of information that appears. See Settings in the List View Window for details about the different display modes and how to use the columns to select records to work with.

By default, the columns in the List View window are sorted by the Slate value, in ascending order. You can sort the data based on any displayed column by clicking the column’s name. The name changes color to indicate it is controlling the sort, and an arrow appears to show the sort direction. An arrow pointing up indicates an ascending sort order, and an arrow pointing down indicates a descending order. Click the column’s name to change the sort direction.

Sorting the columns can make it easy to locate records with missing items. For example, clicking the Cam Roll column name groups together all records without an entry in that field and places them at the top or bottom of the list, depending on the arrow’s direction.

You can also locate a record using a specific key number or timecode number by sorting the columns. For example, clicking the Keycode column name puts the records in order based on their key numbers. You can then scroll through the list and locate a record using a specific film frame.