Sorting a table in Views

You can filter and classify the data displayed in tables in the Views with the help of various data filters and controls. These controls enable you to customize the output and display of information.

On some pages, you can show or hide columns in the tables, and also sort the columns based on the available sorting options. 

Sorting options in tables

You can sort columns in tables alphabetically, or by size. You can also use the available filter options to sort columns.

Refer to the following image to see the the different sorting options available for tables:

1- Sorting options for sorting the column by size, or alphabetically, in case of columns that show values in text format.

For columns that show values in text format, you can sort alphabetically from A to Z or Z to A.

2 - List that displays predefined conditions that you can select from. The conditions differ, depending on whether the column value is in text or numerical format.

For the selected condition, type a corresponding value in the Value box.

3 - Short column description

To sort columns in tables

In this example, the Capacity tab in the vSphere Infrastructure view displays a table which is not sorted.

To sort it by the CPU utilization size:

1. Click the CPU Util [% ] column name.

2. In the pop-up menu, click the option by which you want to sort the column.
   

3. The column updates with the selected sorting option. The column also displays an arrowhead icon, denoting that the column is sorted.
   

To show/hide columns in a table

1. Click the action menu next to the table title, and click Show/Hide columns.
   
   
2. In the Show/Hide Columns window, select the check box corresponding to the name of the columns that you want to display. 
   

3. Click Save.
   
   

   Notes

   • The sorting preferences are user-specific.
   • Sorting preferences are stored when you log out and log in again.