Setting Page Columns Display

Your system includes predefined columns for each Assets table, as well as the Adapter Connections and Adapter Fetch History pages. You can change those default displays and customize which columns appear on each page in which order. When you export tables to CSV files, the column order in the exported file matches the table display order.

Each Assets page maintains its own column configuration, displaying only columns relevant to that specific asset type.

You can save columns in sets of Views that you can load as required. See Saved Views for more information.

EditTbleMenu2.png

Setting Page Columns Display

📘

Note

Applies to Assets tables, Adapter Connections page and Adapters Fetch History page.

You can set the columns displayed on the page, change their order, or pin specific columns so that they are not scrolled.

To change the displayed columns:

  1. Click Edit Table, then select Edit Columns from the dropdown menu.
EditColumnsNEw2.png
  1. In the Available Columns pane, select an adapter from the dropdown menu to view its available columns. (This step applies to Assets pages only.) AdapterDropdown

  2. To add columns to the page, select the required columns in the Available Columns list and then click Add. Columns available depend on the adapter you select. Note that Custom Data is also an option in the adapter list.

📘

Note

It is not recommended to add more than 50 columns to a table, as this may affect optimal table behavior.

  1. To remove columns from the page, select the required columns in the Displayed Columns list and click Remove.
  2. To change the order in which the columns appear, move them up or down in the Displayed Columns pane.
  3. To cancel any changes that you made to the column display and return to the default view, click Reset.
  4. Click Save when you finish your configuration. To save a view as your default view, see Saved Views.

To return to your default column view and clear all filters, click Reset above the search bar.

📘

Note

On Assets pages, you can save queries with the columns in the Displayed Columns pane even when no query expression has been defined. Then, you can load these saved queries and use them as a template for building new saved queries that include the predefined columns and column filters.

Changing the Order Columns are Displayed

You can change the order of columns in tables in the system directly from the table. Drag and drop columns on the table to arrange them in the order you want. Use Edit Columns to save your changes.

Pinning the Columns Displayed

Pin columns so you can scroll horizontally while the pinned columns are always visible. A pinned column has a black pin icon in its header; an unpinned column has a white pin icon. By default, on Assets pages, the Adapter Connections column is always displayed (pinned) when you scroll horizontally.

To pin columns from an Assets/Adapter Connections/Fetch History page, hover over a column heading and click on the pin icon.

All the columns up to and including the selected column are pinned (black pin icon). In the following example, we pinned all columns up to Host Name - see the difference between the pinned headers (circled in red) and the unpinned headers (circled in green):

You can also pin the column display using the Edit Columns dialog. Any pinned columns are displayed at the top of the Displayed Columns pane, in a shaded area.

  1. Click Edit Table, then select Edit Columns from the dropdown menu.

  2. Drag the field you want to set to pin near to the top of the Displayed Column pane.

  3. Hover over the column name to see the pin icon next to it.

  4. Click the icon to set the column name to be pinned. This column and all columns above it are then pinned.

  5. Click Apply.

On Assets pages, the system informs you if you choose too many columns to properly display the Assets table, the system informs. In that case, either change your screen resolution or select fewer columns.

ColumnsEditLock2

To unpin a column, drag the column header out of the pinned (shaded) area, or click the pin icon again to unpin this column and all columns below it.



Did this page help you?