Table Of Contents

Using Cisco ANA Manage Tables

Working with Cisco ANA Manage Tables

Finding Text in a Table

Filtering Information

Defining a Filter

Clearing a Filter

Setting Selection Filters

Applying a Set Selection Filter

Clearing a Previous Filter Selection

Clearing All Previous Filter Selections

Sorting a Table

Exporting the Table to a File

Using Cisco ANA Manage Tables

---

This chapter describes how to perform the following general Cisco ANA Manage functions when working with tables:

•Working with Cisco ANA Manage Tables

•Finding Text in a Table

•Filtering Information

•Sorting a Table

•Exporting the Table to a File

All of these functions are performed using the Cisco ANA Manage table toolbar.

Working with Cisco ANA Manage Tables

Various tables are used throughout the application to display different types of information. Cisco ANA Manage enables you to perform the following functions using the toolbar displayed above the workspace table:

•Find text in a table.

•Define a filter in a table.

•Clear a defined filter from a table.

•Choose lines and set a selection filter in a table.

•Undo the previous selection filter in a table.

•Undo all selection filters.

•Sort the table according to a column.

•Export table information.

•Finding specific information in Cisco ANA Manage tables.

You can also find specific Cisco ANA Manage information, such as Cisco ANA units, or AVM or VNE details, by using the Find feature and entering criteria into the Find dialog box. For more information, see Finding an AVM or VNE, page 6-7.

For more information about the table toolbar, see Table Toolbar, page 2-7.

Finding Text in a Table

Cisco ANA Manage enables you to search for information in the workspace by entering search criteria, such as a partial username.

---

Note The table toolbar is a generic component of Cisco ANA applications.

---

To find text in a table:

---

Step 1 In the table toolbar, enter the search criteria in the Find field.

Step 2 Press Enter. The row matching the search criteria is highlighted in the table.

---

Tip Press F3 to continue searching the table.

---

---

Filtering Information

Cisco ANA Manage enables you to define a filter for the data displayed in the workspace according to a selected column. For example, in the Users branch, information can be filtered according to username.

Defining a Filter

To define a filter:

---

Step 1 In the table toolbar, click Filter. The Filter dialog box is displayed.

Step 2 Enter the information required to define a filter:

Field	Description
Field	In the drop-down list, choose the attribute that you want to search on. The drop-down list contains all columns displayed in the current table.
Operator	In the drop-down list, choose the criteria to apply to the attribute: •Contains •Equal to •Greater than •Less than
Not	Check this check box to filter the negative value in the Operator field. For example, if you chose Contains in the Operator field and check the Not check box, the filter operator is the equivalent of "does not contain."
Search for	Enter the string to be matched.

Step 3 Click OK. The information is displayed in the workspace using the defined filter.

---

Note The Filter button toggles to indicate that a filter has been applied.

---

---

Clearing a Filter

The filter can be cleared to display all data in the table again:

---

Step 1 In the toolbar, click Filter. The Filter dialog box is displayed.

Step 2 Click Clear. The workspace displays the data.

---

Note The Clear filter option clears ALL filter settings. See Setting Selection Filters.

---

---

Setting Selection Filters

You can choose a line or specific set of lines, and display them in the table (all lines not selected are hidden). You can make continuous multiple line selections, setting the table content after each selection by using Set Selection Filter.

You can undo the last line selections (one step back), one at a time, by using Previous Selection Filter, or undo (rewind) all multiple line selections, by using the Rewind All menu option.

This filtering mechanism enables you sort though several hundred lines and pinpoint the appropriate lines that contain the required information. For example, you could filter and display seven lines in a 129-line database segment table.

Applying a Set Selection Filter

To select multiple lines and apply the set selection filter:

---

Step 1 Select the lines in a Cisco ANA Manage table. The Set Selection Filter button is activated.

Step 2 Click Set Selection Filter. Only the selected lines remain in the table.

---

Clearing a Previous Filter Selection

To undo the previous filter selection:

---

Step 1 Select one or more lines and filter them by using the appropriate table toolbar buttons.

Step 2 To undo the last filtering selection, click Previous Selection Filter. The table refreshes with all lines that appeared before your last filter selection.

---

Clearing All Previous Filter Selections

To undo all previously selected filter options:

---

Step 1 Select, filter, and sort lines as required in a table by using the appropriate table toolbar buttons, such as Previous Selection Filter.

Step 2 Click Previous Selection. The Rewind All menu option is displayed.

Step 3 Click Rewind All. All lines in the table are displayed.

---

Tip To clear all manually selected and defined filter options, click Clear in the Filter dialog box. See Filtering Information.

---

---

Sorting a Table

Tables in Cisco ANA Manage can be sorted by defining specific criteria on a one-time-only basis or continuously.

To sort a table:

---

Step 1 In the toolbar, click Sort. The Sort dialog box is displayed (Figure 4-1).

Figure 4-1 Sort Dialog Box

Step 2 Enter the sort criteria:

Field	Description
Sort By	1. In the drop-down list, choose the column you want to sort by. 2. Choose the sort order, either ascending or descending.
Then By	1. In the drop-down lists, choose the next and then last column you want to sort by. 2. Choose the sort order for your choices, either ascending or descending.
Sort Operation	Choose whether the information is to be sorted once or repeatedly: •Once Only—Sorts the information displayed in the table according to the specified criteria once only. When this option is selected, a triangle is displayed in the table heading for the selected column. •Continuously/Repeatedly—Sorts the information displayed in the table according to the specified criteria continuously. When this option is selected, the icon is displayed next to the selected column heading.

Step 3 Click OK. The table information is sorted according to the filter defined.

---

Exporting the Table to a File

Cisco ANA Manage enables you to export all currently displayed data from the workspace to a comma-separated values (CSV) file. The selected rows are exported; when nothing is selected, the entire table is exported. The data can then be imported and viewed at a later time.

---

Note This tool occurs with the same functionality throughout the application.

---

To export the table to a file:

---

Step 1 In the table toolbar, click Export to CSV. The Export Table To File dialog box is displayed.

Step 2 Browse to the directory where you want to save the table.

Step 3 In the File name field, enter a name for the table.

Step 4 Click Save. The selection is saved in the specified directory.

---