Filter and sort administration tables

All tables within the Administration pages include the option to sort, filter, reorder, and manage the columns shown. This enables you to find and show what you need when managing administrative settings.

Sort a column alphanumerically

1. Hover your pointer over the column heading that contains the values for which you want to sort the table.

   An arrow () is shown.

2. Click the arrow to sort the table by the values in the chosen column alphanumerically in ascending order.

   The arrow becomes darker () and remains visible to indicate the sort order of the column.

3. Click the arrow again to sort the table in descending order.

   The arrow points down (). Again, it remains visible to indicate the sort order of the column.

   Alternatively, you may click the column action menu ( ) and select Sort by ASC or Sort by DESC.

Tip: To return to the default sorting, click the column action menu ( ) and select Unsort.

Filter a column

Filter a column to show only the data that you want.

1. Click any column action menu ( ) and select Filter.

   The filter dialog opens.

   

2. From the Columns drop-down list, select the column you want to filter.

3. From the Operator drop-down list, select the operator with which to filter. The available options depend on the contents of the column.

   • When the contents of the column are a fixed set of values to choose from:
     
     
   • When the contents of the columns are numbers:
     
     
   • When the values are text fields entered by a user:
     
     
   • When it’s a date:
     
     

4. Once you have selected the operator, enter your filtering criteria in the Value field. Depending on the contents of the column, the Value field might be a drop-down list, a calendar date picker, or a free text field.

You may add additional lines to the filtering criteria to filter a column with more than one operator and value, or across more than one column.

1. Click + ADD FILTER.
2. Select the Boolean operator that determines how this new filter line relates to the first line. Choose from And or Or.
3. From the Columns drop-down list, select the column you want to filter.
4. From the Operator drop-down list, select the operator with which to filter. The available options depend on the contents of the column.
5. In the Values field, enter the desired value.

Repeat the above steps to add another line.

Search within a table

At the top each table is a search field to enable you to find what you're looking for without the need for column filters. The text inside the search field indicates which columns it searches through. Begin typing to see rows that match the search terms dynamically shown.

Reorder and pin columns

You may reorder the columns in a table. To do this:

1. Click a column heading that you want to move.

2. Drag it left or right.

   Other columns move to show where the selected column may be placed.

3. Release the mouse button when the column is in your desired location.

You may also quickly move a column to the very left or right of the table.

1. Click the column action menu ( ) and select Pin to left or Pin to right.

Show, hide, and manage columns

You may hide a column from view.

1. Click the column action menu ( ) and select Hide column.

You may also manage which columns are shown or hidden in one place.

1. Click any column action menu ( ) and select Manage columns.
2. Toggle each column on or off to show or hide columns respectively.