See the procedures on this page for modeling tabular view columns.

Prerequisites

Ensure the following steps are done:

  1. The view is defined by the needed tabular view definition.
  2. The view has an expose relationship. 
  3. (Optional) The view has filters.

Proceed to model table columns.

Adding table columns

For more information, see the Column kinds table on the (2026x Refresh1) Tabular view columns page.

Adding table columns by feature

Adding table columns by feature via the Configure Table Columns dialog

Generally, only inherited columns or those that redefine inherited ones are available for selection in the Configure Table Columns dialog.

To add table columns by feature via the Configure Table Columns dialog

  1. In a tabular view's toolbar, click the Columns button, and in its dropdown menu, click Configure Table Columns. The Configure Table Columns dialog opens.
  2. In the Configure Table Columns dialog, in the Column Name column, under the Element node, locate the column you want to add to the table, then select its check box in the Added To Model column.
  3. Click OK.
    The column is added to the model and displayed in the diagrammatic representation of the tabular view.

Adding table columns by expression

Adding table columns by expression via the Configure Table Columns dialog

To add table columns by expression via the Configure Table Columns dialog

  1. In a tabular view's toolbar, click the Columns button, and in its dropdown menu, click Configure Table Columns. The Configure Table Columns dialog opens.
  2. In the Configure Table Columns dialog, click the Add Custom Column button. A new custom column is added under the Custom Columns node.
  3. (Optional) You can also do the following:
    1. Click the column title to rename it.
    2. Click the Delete button in the Added To Model column to delete the column from the model.
    3. Click the button in the Expression column to open the Column Expression dialog and view the expression specified for the column.
  4. Click OK. 
    A template is created in the model for custom column creation. You can specify the expression for the template via the Textual Editor.
    Custom column template

    view unnamed1 : DS_Views::CoreViews::ColumnByExpressionView :> column {
       render rendering : DS_Views::CoreViews::StringCellRendering :>> DS_Views::CoreViews::asTableCell {
          calc :>> getValue { in rowElement; }
       }
    }

Modifying table columns

Hiding table columns

Hiding table columns via the column headers in tabular views

To hide table columns via the column headers in tabular views

  • Right-click the header of the column you want to hide from a tabular view, and in the shortcut menu, click Hide Column.
    The table column is hidden.

Hiding/displaying table columns via the Columns button in tabular views

To hide/display table columns via the Columns button in tabular views

  1. In the tabular view's toolbar, click the Columns button.
  2. In the dropdown menu, click the column you want to hide from or display in the table.
    The displayed columns are highlighted in the dropdown menu. 

Deleting table columns

Deleting table columns via the column headers in tabular views

The Delete Column command is not available for inherited columns or for columns that redefine inherited ones.

To delete table columns via the column headers in tabular views

  • Right-click the header of the column you want to delete from a tabular view, and in the shortcut menu, click Delete Column.
    The column is deleted from the model.

Deleting table columns via the Configure Table Columns dialog

The Delete button is not available for inherited columns or for columns that redefine inherited ones.

To delete table columns via the Configure Table Columns dialog

  1. In a tabular view's toolbar, click the Columns button, and in its dropdown menu, click Configure Table Columns. The Configure Table Columns dialog opens.
  2. In the Configure Table Columns dialog, under the Column Name node, locate the column you want to delete from the table, then click the Delete button in the Added To Model column.
  3. Click OK.
    The column is deleted from the model.

Sorting table rows

Sorting table rows via column headers in tabular views 

If the column header displays a notification after attempting to sort tabular rows via column headers, see the explanation and resolution in the Tabular view loading warning box in the Filtering tabular view column cells subsection.

To sort table rows via column headers in tabular views

  • In the tabular view, click the header of the column according to which you want to sort table rows. The Sorting icon is displayed in the header, indicating the current sorting direction. Click the column header to change the sorting direction:

    • indicates that cells in the column are sorted in ascending order. This is the default mode.

    • indicates that cells in the column are sorted in descending order.

      To sort according to multiple columns, hold Shift when clicking the column header.

Pinning table columns

Pinning table columns via column headers in tabular views 

To pin table columns via column headers in tabular views 

  1. In the tabular view, right-click the header of the column you want to pin.
  2. In the dropdown menu, click Pin Column, and in its submenu, click one of the following:
    1. Pin to the Left
    2. Pin to the Right
    3. No Pin

Modifying table column width

Modifying table column width via column headers in tabular views 

To modify table column width via column headers in tabular views 

  1. In the tabular view, do one of the following:
    1. In the table header, drag the vertical grid lines separating the columns and adjust the width as needed.
    2. Right-click the header of a column and in the shortcut menu, click one of the following:
      1. Size Column to Fit to resize the column width, adjusting it to its content.
      2. Size All Columns to Fit to resize the width of all columns, adjusting them to their content.

Filtering tabular view column cells

Tabular view loading

Tabular views load only the content that is immediately visible; additional rows and cell data are loaded as you scroll. If you filter or sort partially loaded column cells, a notification icon  appears in the column header.

To resolve this, do one of the following:

  • Right-click the column header and in the shortcut menu, click the Load All Cells command.
  • Scroll through the entire table to load all content.

Once the cells are fully loaded, retry to filter or sort.

Filtering does not persist and resets automatically once you reopen the tabular view.

Filtering tabular view column cells

To filter tabular view column cells

  1. In the tabular view, right-click the header of the column whose cells you want to filter and click Filter Column in the shortcut menu.
  2. Do one of the following:
    1. Expand the Filter by Values section. Do one of the following:
      1. In the Values column, select the check boxes for the values you want to display in the column.
      2. Type the value name in the input field to narrow the search, select the Apply filter on refined values check box, and select the check boxes for the values you want to display in the column.
    2. Expand the Filter by Conditions section.
      1. Select the condition from the dropdown menu and type the value you are looking for in the input field. 
  3. Click OK.
  4. (Optional) To reset the filter, right-click the column header with the applied filter. In the shortcut menu, do one of the following:
    1. Click Reset Column Filter.
    2. Click Filter Column, then Reset. Click OK.