Working with data grids

Many pages in the EDA GUI display lists of featuring rows and columns of data. The options described here for managing such data grids are common to most data grids in the EDA GUI.

Note: Many lists include special options uniquely available for lists of particular data. Those options are described in the topics pertaining to those lists.
Figure 1. A sample data grid with controls
Table 1. Data grid controls
# Name Function
1 Row selectors Use these to select one or more individual rows.
2 Multiple row selector Use this to toggle between selecting all rows, and un-selecting all rows.
3 Selection filter Select a value to filter the list based on matching values in that column.
4 Text string filter Enter an alphanumeric string to filter the list based on matching values in that column.
5

Logical filter

(with filter menu icon)

 Create a logical expression, which can include multiple criteria and a choice between AND and OR requirements, to filter the list based on matching values in that column.
6 Standard table actions Select from a set of actions common to all tables.
7 Table settings and actions button Click to open the menu of standard table actions.
8 Table row actions button Click to select from a set of actions specific to the data in that row.
9 Row and selection counter Indicates the total number of rows, and the number of rows that are currently selected.
10 Filter counter Indicates how many filters have been applied to result in the currently displayed data set.

Nested columns

Columns may be collected into groups; in this case, individual columns are nested within a higher-level column for that group. For example, several columns pertaining to resource metadata are nested within a Metadata column.

Figure 2. Nested columns for metadata

Managing displayed columns

For any table, you can select which columns are displayed and which are hidden from view.

In the list of standard table actions, click Manage columns... to open a Manage Columns dialog. This dialog lists all available columns; those checked are included in the data grid, and those unchecked are excluded. By default, some possible columns may already be excluded from view.

Select or un-select the available columns and click Apply to close the dialog and update the data grid display based on your selections.

To rearrange the position of a column, click the column header and drag it to its new position.

To restore the default configuration for the data grid, click the Table settings & actions icon and select Reset Column Layout from the action list.

If the set of columns exceeds what can be shown at one time in the display area, the EDA UI adds a scroll bar to the bottom of the data grid. Scrolling horizontally moves all columns to the left or right as you would expect.

For most data grids, the Name and Namespace columns are pinned to the left by default. When scrolling horizontally, these columns remain visible at the left edge of the display.

Dynamic display for namespace column

Many data grids include a column for Namespace, which identifies the particular namespace associated with each row.

However, if you have selected a single namespace in the Namespace selector on the top bar, then the Namespace column is automatically hidden on the data grid. Because all namespace values would match the selected namespace, displaying the column is not useful.

Pinning columns

You can pin one or more columns to the left or right side of a data grid. Pinned columns continue to display even as the rest of the data grid scrolls to the left or right.

The set of pinned columns are bounded by a vertical gray line on their right edge.

In most data grids, the Name column is pinned by default. However, the default pinned columns can vary by page.

To pin additional columns, click any column header and drag it into the pinned area. To un-pin a column, click the column header and drag it out of the pinned area.

Sorting

For any table, you can sort the row order based on the values in any column by clicking on the title for that column. EDA displays a sorting icon next to the column title to indicate that sorting is active.

Clicking on the title again toggles between ascending and descending order.

To sort by multiple columns, shift-click a series of column titles. Doing so has the following effects:
  • adds each successive column to the sort order
  • displays the sorting icon next to each column title
  • displays a number next to each column title to indicate its rank in the overall sorting order

To clear all sorting from the data grid, click the Table settings & actions icon and select Clear sorting from the action list.

Filtering

You can filter the displayed data to include only those with specific values in one or more columns:

  • For columns that display text, you can type any alphanumeric string in the field at the top of the column. The list is filtered only to show rows with the selected value in that column.
  • For columns that display only a predetermined set of values, you can use a drop-down list to select a value. The list is filtered only to show rows with the selected value in that column.
  • For columns that display numbers, you can click the Filter icon to build a logical filter. The filter menu allows you to choose an operator and a value, and then add additional operator/value combinations to create a complete logical expression. The list is filtered only to show rows with the selected value in that column.

To clear all filtering from the data grid, click the Table settings & actions icon and select Clear filters from the action list.

Multi-row actions

Some tables support actions that can be simultaneously applied to all selected rows. When available, these actions are displayed under a sub menu of the Table settings and actions menu.

Figure 3. Multi-row actions for nodes list

Special actions

Some tables support special actions appropriate to the particular data displayed in the list. When available, these actions are displayed under a sub menu of the Table settings and actions menu.

Figure 4. Special actions for the alarms list

Bulk edits

To aid on those occasions where you need to make the same change to multiple items, some data grids include a Bulk Edit option.

Figure 5. Actions for the nodes list
The Bulk Edit option allows you to:
  1. Select a set of objects in a list.
  2. Configure a set of properties they all share in common to be removed, added, or replaced.
  3. Apply those same changes to all of the selected objects (immediately as a commit, or later as part of a transaction).

After you select all of the objects that are the subject of your change (using the check box at the left of each row), selecting the Bulk Edit option opens the Bulk Edit page.

The Bulk Edit page indicates the number of objects selected, and lists all of the editable properties those objects share. For each property, a check box allows you to select it for modification.

After an item has been selected for editing, a drop-down control allows you to choose the type of change to make, and a field displays the specific changes you have indicated for that property.

Figure 6. The bulk edits page
Table 2. Elements of the Bulk Edit page
Item Description
1 The page name and an indication of the number of selected objects that are subject to these bulk changes after they are committed.
2 A list of modifiable properties for the selected objects.
3 In this case the Labels field is selected for modification. Because the field has been selected for modification, the actions drop-down list is displayed. Available options are specific to the Labels field.
4 After configuring the set of changes for all parameters, choose from among the standard Commit options for this bulk edit:
  • Commit to immediately apply the changes on this Bulk Edit page.
  • Add to Transaction to store these changes to be processed later as part of a transaction (which can include other accumulated commits to be applied as part of the same operation).

The actions available for a specific parameter as part of a bulk edit depend on the type of data being modified.

Bulk edits for single-value fields

Single-value fields are those that contain integers, strings, or enums (single selections from a drop-down list).

  • Add: the new value supplied as part of the edit is written to the selected field.
  • Remove: any current values in the selected field are deleted.
  • Note: If a field is required, the Remove option is not available.
Figure 7. Bulk edit options for an optional text field

Bulk edits for maps

Maps type fields are collections of key-value pairs. Supported bulk edit options can be based on the key, or on the field as a whole.
  • Replace all overwrites the current set of objects with the values supplied as part of the edit.
  • Remove all removes all objects in the array. This is only available for optional arrays.
  • Add by key appends new values supplied as part of the edit to the current set. If a key used in the new values matches that of an existing key-value pair, the existing value is overwritten with the new value.

Bulk edits for labels

Labels are a special case of maps with support for "Remove by key" in addition to the other map actions.

  • Replace all overwrites the current set of objects with the values supplied as part of the edit.
  • Remove all removes all objects in the array. This is only available for optional arrays.
  • Add by key appends new values supplied as part of the edit to the current set. If a key used in the new values matches that of an existing key-value pair, the existing value is overwritten with the new value.
  • Remove by key removes objects from the current set that match the specified key.
Figure 8. Bulk edit options for a label field