User Views › Display Formats › Table View › Additional Table View Options

Additional Table View Options

In addition to the Table View menu and toolbar options you can also perform some quick appearance changes to the Table View as follows:

• Quick Find in Column
• Quick Sort on Columns
• Quick Color Code a Column
• Move the Freeze Column Line
• Return a Table View to Factory Settings

How to perform these changes is explained in the following procedures.

Note: The following options and more options for customizing a view are available in the View and Output Definition option. For more information, see the section View and Output Definition Dialog.

To Quick Find in Column

Instead of scrolling down to a row you can quickly find a particular item. To do this you can use the Find in Column option by following these steps:

1. Right-click the column heading which contains the item you want to find.

   The Column Options Menu is displayed as shown in the following sample:

   

2. Click the Find option in the Column Options Menu.

   The Find dialog is displayed.

3. In the Find What field, type in the item you want to find. You can type in part of the item, for example if you wanted to find ABC123 then you could type in ABC, ABC1, and so on.
4. Click Find Next.

   The Table View of the object is updated and the first item containing your find criteria is displayed. If the criterion is not found in the column then you will receive a message advising it is not found.

To Quick Sort on Columns

You can perform quick sorts in the Table View by clicking a column heading title cell and the table will sort by that column in descending order. Click the column heading title cell again and the table will sort by that column in ascending order.

You can also right-click a column heading and the Column Options Menu is displayed where you can select the Sort Ascending or Sort Descending options.

Note: After you have created a Table View column sort in this manner you may want to remove it; to remove a Table View column sort, click the Sort icon and use the Exclude a Field option or the Exclude all Fields option. For more information, see the section Defining a Sort.

To Quick Color Code a Column

You can highlight certain values in columns by color coding them when specific criteria is met. You have two options for color coding, you can use the Quick Color Code a Column option or you can use the View and Output Destination – Fields option (see the section View - Fields).

Example of how to use the Quick Color Code a Column option

The following is an example procedure of how to use the Quick Color Code a Column option on the Volumes column in the Storage Group Volumes object:

1. Right-click the column heading of the column you want to color code.

   The Column Options Menu is displayed.

2. Click the Column Color Coding option in the Column Options Menu.

   The Column Color Code dialog is displayed. The following is a sample of the Column Color Code dialog displayed for the Volumes column in the Storage Group Volumes object:

   

3. Click in the first empty Condition cell.

   A down arrow appears on the right side of the cell.

4. Click the down arrow on the right side of the cell.

   The Condition options are displayed as shown in the following sample:

   

5. Select the condition you want.

   The condition selected is displayed in the cell.

6. Click the Value cell of the same row you selected the condition. Type in the value that you want the condition applied to.

   The value is displayed in the cell.

7. Click the Color cell of the same row you selected the condition and typed in a value.

   The Color dialog is displayed.

8. In the Color dialog select the color you want to appear as the background for the items that meet your criteria and click OK.

   The Column Color Code dialog is displayed showing the condition, value and color you have specified.

   The following is an example of the Column Color Code dialog where the condition is ‘=’, the value is ‘ACFQA1‘ and the color is blue for the Volumes column in the Storage Group Volumes object:

   

9. Click OK.

   The Table View of the object is displayed with your color code settings.

10. (Optional) In the Table View menu select File and then click Save, to save your settings.

Observe the following:

• If you save the Table View with the column color code setting then every time you open the object the color codes are applied.
• To remove the column color coding; display the object, right click the column, select No Colors, and then click OK in the Column Color Code dialog.
• You can apply the color coding to the cells in the column selected or you can apply the color coding to the whole row by selecting the Apply to Row option.
• You can apply predefined color code values by selecting the Use predefined colors button ().
• You can save the column color codes you have created so that you can use them later by selecting the Store these colors as predefined button ().
• You can have multiple conditions, values, and colors to the same column. However, the GMI Windows Client checks the conditions sequentially until the first match occurs and it uses ANSII character sort order for the comparison (for example: 0-9, A-Z, and a-z). If one value meets two or more conditions then the first condition is applied.

  For example: if you color code two conditions in the dialog such that ‘= AAAA1 Blue’ is listed first, and then ‘> AAAA0 Red’ is listed second in the dialog then the GMI Windows Client will apply the ‘= AAAA1 Blue’ condition to all AAAA1 items, then it will apply the second condition, ‘> AAAA0 Red’, to any items that meets the second condition but where the first condition has not been applied. If the conditions are reversed in the dialog so that ‘> AAAA0 Red’ is first and ‘= AAAA1 Blue’ is listed second in the dialog, then the second condition, ‘=AAAA1 Blue’, would be ignored because items with values AAAA1 have already met the first condition and the red color coding is already applied to them.

• There are no "and" or "or" condition statements available for color coding multiple conditions, values, and colors to the same column. There are simply the 'less than', 'less than or equal to', 'equal to', 'greater than', 'greater than' or equal to', 'less than or greater than' and ‘Range’ (for numerical fields only) conditions available for comparison to the values you specify.

To Move the Freeze Column Line

Frozen columns are the left most columns that remain visible when the table is scrolled horizontally. The black vertical line separating columns is the Freeze Column Line, it divides the frozen columns from the scrollable area. For most objects, the Windows Client freezes the first left column. You may change the number of frozen columns by drag-and-dropping the Freeze Column Line to the right or to the left. Dragging the Freeze Column Line to the left, past the first column makes all the columns scrollable. The following illustration shows the factory default Freeze Column Line for the Storage Group Volumes object:

Example of how to include the Type and Volumes columns as Freeze Columns

Note: You can similarly include as many columns as you want as freeze columns in any Table View of an object.

1. Drag-and-drop the vertical line from between the SG Name and the Type columns, to the vertical line between the Volume and the CUA1 columns.

   Note: You must drag-and-drop the line from anywhere below the column heading portion of the line, that is, it will not work if you drag-and-drop the section of the line between the column headings.

   The Freeze Column Line is now displayed between the Volume and the CUA1 columns as shown in the following sample:

   

   When you now scroll to the right in the Storage Group Volumes object the SG Name, Type and Volume columns will always be displayed in the left columns of the view.

2. In the object view menu click File and then Save, to save your settings.

Observe the following:

• If you save your settings then every time you open the object the Freeze Columns line will be where you saved it. Alternatively you can just close the Table View without saving your Freeze Column Line change and the next time you open the Table View for the object the Freeze Column Line will be where it was with the factory setting.
• The horizontal scroll bar may disappear if you drag the Freeze Column Line to the far right past the table visible area. If that occurs then resize the object window to be wide enough to view both the frozen columns and columns in the scrollable area.