Search, filter, and group items in a table

You can search tables for items that contain a specified search term, hide items that don't match filter criteria, and group together items that have the same value for a specified property.

To search, filter, or group the items in a table:

  1. Right-click a column header in the table.
  2. Select a tool from the menu. The following tools are available:
    • Find Panel. You can search all text data columns for text that you enter. Matches of your search terms are highlighted in the table.
    • Auto Filter Row. You can build a filter from values that you enter, or select from a list. You can use a different value for each column. See Use the auto filter row.
    • Filter Editor. You can build a new advanced filter, or edit a filter that you created with the auto filter row. See Create an advanced filter.
    • Group By This Column. Groups items by the values in the column that you right-clicked on. For example, you can group students by department.

    Note: Some columns contain data that is of a type that these features cannot use. For example, the Suitabilities column in a table of locations.

  3. Optional: Save the filter setup. You can load it when you next undertake a similar task.

Scientia Ref: 4232. For Enterprise Timetabler 3.15.1. Copyright © Scientia Ltd. 2019