Sorting, Filtering, and Configuring Tables

In Studio, Curator, and Admin, you can sort and filter table data. You can also configure column order and which columns are included in the table.

Select More (three vertical dots) to open the column sort, filter, and configuration optionsSelect More (three vertical dots) to open the column sort, filter, and configuration options

Select More (three vertical dots) to open the column sort, filter, and configuration options

Configuring Column Order

You can:

  • Reorder columns using drag and drop.
  • Pin a column to the left or right side of the table.

To pin a column:

  1. Move your cursor over the column and select MoreMoreMore.
  2. Select Pin to left or Pin to right.

Showing and Hiding Columns

To hide a column:

  1. Move your cursor over the column and select MoreMoreMore.
  2. Select Hide column.

To show or hide multiple columns:

  1. Move your cursor over any column and select MoreMoreMore.
  2. Select Show columns.
  3. From the Show columns dialog, toggle column display on or off. You can also select to show or hide all columns.

Filtering Table Data

You can filter by values in one or more table columns, using AND/OR logic.

To filter table data:

  1. Move your cursor over the column and select MoreMoreMore.
  2. Select Filter.
    The Filter dialog opens, with the column pre-selected from the Columns dropdown.
  3. Select the operator from the Operator dropdown.
    • For text fields, operators are contains and equals.
    • For numeric fields, operators are =, !=, >, >=, <, and \<=\.
  4. Enter the value by which to filter in the Value field. Filter values are case-insensitive.
    The table is filtered in real-time as you enter the value.
  5. Add additional filters by selecting Add Filter and select either And or Or. Select the column and operator, and enter the value by which to filter.
  6. Remove a filter by selecting the closeclose next to the filter.
Table data is filtered to entities in which the "Company Name" field contains "a & l" OR the "Alternative Names" field contains "a&l".  Filtering is case-insensitive.Table data is filtered to entities in which the "Company Name" field contains "a & l" OR the "Alternative Names" field contains "a&l".  Filtering is case-insensitive.

Table data is filtered to entities in which the "Company Name" field contains "a & l" OR the "Alternative Names" field contains "a&l". Filtering is case-insensitive.

Sorting Table Data

You can sort a table by values in a column.

To sort table data by a column:

Move your cursor over the column and select MoreMoreMore. Select one of the following sort options:

  • Sort by ASC to sort the column in ascending order.
  • Sort by DESC to sort the column in descending order.
  • Unsort to remove sorting by this column.

Tip: To quickly sort a column in ascending or descending order, move your cursor over the column and select the arrow. The upward arrow arrow upwardarrow upward sorts in ascending order; the downward arrow arrow downwardarrow downward sorts in descending order.