Collection Table¶

Overview¶

List of configuration files¶

Filename	Short description	Format	Link to documentation
dashboard.view#CollectionTable	Defines the CollectionTable widget global settings	json	Link

List of examples¶

Short description	Link to documentation
Display the elements of a collection	List and update a collection
Delete an element of a collection through a menu	Add a delete menu to a CollectionTable
Setup your configuration to gain access to collections rights	Setup your configuration to gain access to collections rights

Features¶

Collection table widgets allow showing collection elements with specified filters and view in the dashboard. It displays columns based on view.

There are two different aspects to a Collection table :

Listing of collections elements
Editing a collection element

Example of a basic Collection table widget:

Collection table¶

The following parameters can be used for the collection table:

Setting	Usage	Type	Default value
defaultSchema	The default schema to select	string
includeSchemas	Schema table toolbar filters	string[]
excludeSchemas	List of schemas to exclude from table toolbar filters	string[]
defaultFilter	The default filter to select	string
includeFilters	Collection table toolbar filters	string[]
excludeFilters	List of filters to exclude from collection table toolbar filters	string[]
defaultView	The default view to select	string
includeViews	Collection table toolbar views	string[]
excludeViews	List of views to exclude from collection table toolbar views
pageSize	Collection table page size (must be present in page sizes)	number	50
pageSizes	Collection table page sizes	number[]	[50,`100`,`200`]
resizeMode	Define column resize mode	‘nextColumn’ or ‘widget’	‘widget’
disableToolbarTableRefresh	Whether to allow user to manually refresh table or not	boolean	false
disableSchemaUpdate	Whether to allow user to update schema or not (will show/hide the combo box)	boolean	false
disableViewUpdate	Whether to allow user to update view or not (will show/hide the combo box)	boolean	false
disableFilterUpdate	Whether to allow user to update filter or not (will show/hide the combo box)	boolean	false
disableToolbar	Whether or not to show menu toolbar	boolean	false
disableToolbarMenu	Whether or not to show toolbar	boolean	false
disableSidePanel	Whether or not to show side panel option in toolbar	boolean	false
disableToolbarExport	Whether or not to show export option in toolbar	boolean	false
disableToolbarColumnShowHide	Whether or not to show column show/hide option in toolbar	boolean	false
disableToolbarFilterShowHide	Whether or not to show archive option in toolbar	boolean	false
disableToolbarSummaryShowHide	Whether or not to show summary show/hide option in toolbar	boolean	false
disableToolbarSearch	Whether or not to show search option in toolbar	boolean	false
disableToolbarColumnChooser	Whether or not to show column chooser in toolbar	boolean	false
disableToolbarClearFilter	Whether or not to show clear filter in toolbar	boolean	false

Example of collection table parameters:

{
"collectionTableWidgetSettings": {
    "defaultSchema": "root.chv.collections.cds",
    "defaultView": "1",
    "defaultFilter": "filters_en_cours",
    "pageSize": 50,
    "pageSizes": [
        50,
        100,
        200
    ],
    "resizeMode": "widget",
    "disableToolbarTableRefresh": false,
    "disableSchemaUpdate": false,
    "disableViewUpdate": false,
    "disableFilterUpdate": false,
    "disableToolbar": false,
    "disableToolbarMenu": false,
    "disableSidePanel": false,
    "disableToolbarExport": false,
    "disableToolbarColumnShowHide": false,
    "disableToolbarFilterShowHide": false,
    "disableToolbarSummaryShowHide": false,
    "disableToolbarSearch": false,
    "disableToolbarColumnChooser": false,
    "disableToolbarClearFilter": false
}

Table¶

The table view shares a lot of interactions with the AlarmTable widget.

Selection¶

Rows can be selected the following ways:

Click¶

On row click with a single click, toggles single row selection, resets previous selection.

Ctrl-click¶

On row click with a single click holding control key, toggles selected row, keeping other selection.

Shift-click¶

On row click with two clicks holding shift key, selects all rows between begging and end rows, keeping other selection.

Drag-and-drop¶

On row click holding and releasing, selects all rows between beginning and end rows.

Toolbar¶

As for the AlarmTable, a CollectionTable can display a toolbar containing different actions :

Switching views¶

At the left end of the toolbar, two icons allow you to switch between table and form views. Next to them, a button allows entering the form view to create a new element and the button next to it allows you to update.

When in update mode, the form depends on the selected elements. If you select multiple elements and go into update mode, you can navigate between each element and update each one of them. The update is only on the current shown element. You can’t update all the selected elements at once.

Refresh¶

You can force a table refresh by clicking the refresh icon.

Schemas, Filters and Views¶

You can change a collection based on the schema defined in your configuration. Only schemas with view(s) configured can be displayed in a collection table.

You can apply one of the filters defined in your schema. Theses filters can be filtered by using the includeFilters and excludeFilters properties. includeFilters specifies filters which should be offered for this widget and excludeFilters the ones which should not.

Note

If you set both, first all filters not present in the include list will be removed. Then, from that list, the filters presents in the exclude list are removed.

Following the same principles, you can filter the table with a view, from views defined in your schema. You have the possibility to filter views offered the same you can can filters.

Change table structure¶

Three options can change the structure of a table:

Show/hide column: displays the names of the columns at the top of the table, as well as an option to select/unselect all rows.
Show/hide filter: displays filters options for each column, depending on the value type.
Show/hide summary: displays a summary at the bottom of the table (ie: rows, count, sum of a column,…).

Clear filters¶

Remove all current filters and reset the default ones.

Search¶

You can search the table by searching for a text (column with text value) or for a tag.

Export¶

The export button can export multiples rows into an excel file. Either export every row or export only selected ones.

Show/Hide column¶

You can show or hide a particular column with the Show Column Chooser. These will also change depending on current view.

Form¶

The second aspect of a CollectionTable is the form. view, allowing to create/modify an element of the collection.

You can navigate between all the elements present in the table or the selected ones.

Create¶

You can enter create mode by using the button on the left of the toolbar. When entering create mode, you are locked into this specific element until you leave this mode. When you save your modifications, the element is created and you should see the list updated automatically (you might not see it depending on the filters you have).

Once the element is created, every modification will update it. To create another one, you need to leave create mode (use the same button or the close icon next to it) and get back into it.

Update¶

You can enter update mode by using the pencil icon next to the create button. When in update mode, you can navigate between every elements of a table (or the selected ones) and update them on the fly.

Historic¶

You can enter historic mode by using the timer icon next to the pencil button. When in history mode, a new selector appears at the right of the icon. This selector let you choose between the different versions of the current element. While in historic mode, you can’t edit the element.

Widget context¶

The widget context can be accessed from menus to fetch these different values from the table:

rows
- all: all rows (list)
- clicked: clicked row (object)
- selected: selected rows (list)
- column: column with name and title (object)
- value: value of the cell
columnFilter: current filters on the table (list)
columnOrder: list of all columns names in order
hiddenColumnNames: list of hidden columns
defaultFilter: current filter
defaultViewId: current view
language: currently used language