5.3. Customize view of the entity instance table

To customize view of the table with instances of an entity you need to have READ permissions for the folder with that metadata. For more information see 13. Permissions.

This page describes how a user can customize an entity instance table and make it more easy to read. Any user, who has permissions for reading, will be able to customize the view of the table: change set of viewed attributes, change the order of attributes, filter instances and reset the default settings.

Change attributes view

  1. Press the "Change view" control.
    CP_CustomizeViewOfEntityInstanceTable
  2. A list of accessible attributes shows up. The list contains all attributes of entities, uploaded in the current project. The attributes of current view are ticked.
    CP_CustomizeViewOfEntityInstanceTable
  3. Choose desired attributes by ticking.
    Note: The last tick will be disabled, so you can't clear all checkboxes.
  4. To change the order, click a control in front of the desired attribute and pulling it up or down.
  5. The changes are applied instantly. The table view has only selected attributes.
    Note: This customization saved only for logged in user.
  6. To leave the form a user shall click outside the form.

For example, attributes were customized as shown:
CP_CustomizeViewOfEntityInstanceTable
And the table automatically changed its view to:
CP_CustomizeViewOfEntityInstanceTable

Note: you are able to restore the initial order of columns. To do that, click the Reset Columns control in the Change view panel.

Filter instances

Date filter

User can restrict shown metadata instances by filtering them according to their created date. For that:

  1. Click the filter icon next to the "Created Date" column header
  2. The date filter panel will appear:
    CP_CustomizeViewOfEntityInstanceTable
  3. Specify dates "From" and "To", e.g.:
    CP_CustomizeViewOfEntityInstanceTable
  4. Click the Apply button to confirm:
    CP_CustomizeViewOfEntityInstanceTable
  5. Filter will be applied and in the table, only instances with the "Created Date" according to a specified date range will be shown
  6. To reset applied date filter, specified for the "Created date" column, click the filter icon next to the column header and click the Reset button:
    CP_CustomizeViewOfEntityInstanceTable

Note: if only "From" date was specified - filter will be applied for all instances with the "Created Date" from specified date till today.
Note: if only "To" date was specified - filter will be applied for all instances with the "Created Date" till specified date.

Column filter

Also user can filter instances of an entity in a table by their attribute values.
To filter a table by any column value(s):

  1. Click the filter icon next to the column header (for the column "Created Date", see the section above)
  2. The column filter panel will appear:
    CP_CustomizeViewOfEntityInstanceTable
  3. Specify filter text and press Enter key, e.g.:
    CP_CustomizeViewOfEntityInstanceTable
  4. You can specify another one or several filters in way as described at step 3, e.g.:
    CP_CustomizeViewOfEntityInstanceTable
    Several filters will combine with logical OR operation.
    If you want to cancel the certain specified filter - click the cross-button next to filter text - CP_CustomizeViewOfEntityInstanceTable.
  5. After all desired filters are specified, click the Apply button.
  6. Filters will be applied and in the table, only instances matching the specified filters will be shown.
  7. To reset applied filters, specified for the column, click the filter icon next to the column header and click the Reset button:
    CP_CustomizeViewOfEntityInstanceTable

Common notes for both filter types:

  • user can apply filters for any count of columns
  • when any filter is set for the column, the filter icon next to the column header is being highlighted in blue, e.g.:
    CP_CustomizeViewOfEntityInstanceTable
  • to reset all filters, click the Clear filters button above the metadata table - CP_CustomizeViewOfEntityInstanceTable

Metadata table sorting

To sort instances of an entity in a table, click a header of the desired column, e.g.:
CP_CustomizeViewOfEntityInstanceTable
This action will sort a list in a descending order by this column (see the corresponding icon near the column header).

Next click by the same header will sort a list in an ascending order:
CP_CustomizeViewOfEntityInstanceTable

Next click by the same header will reset sorting by this column.

To sort instances of an entity in a table by several columns:

  1. Sort a list by the column you wish to sort in the first order (as described above).
  2. Click a header you wish to sort in the second order, e.g.:
    CP_CustomizeViewOfEntityInstanceTable
    Near each header of the sorted columns, there will be a mark with the sorting order.
  3. You may sort a list in such way by any count of columns.
  4. You may customize sorting for any column independently to others - by additional clicks on its header.