Data Table

The Data Table Editor (DTE) is a component used to edit or view a single Data Table. It is used:

• By the Properties Editor to edit context variables

• By the Event Log to view Data Tables associated with events

• By the Edit Data UI Procedure to edit function input parameters and view its output, etc.

• And in many other system facilities.

Most elements of the Data Table Editor, such as column headers and data cells, usually have tooltips which pop up when the mouse hovers over the element.

The tooltip for the column header contains the field type and help string specified in the table's format, if any.

The tooltip for a cell contains a string representation of the cell's value, and the type of field used for this cell. For example, it may be useful:

• If a cell's value too long to fit into the cell itself,

• If the cell editor has selection values and you want to see the value itself, not its description from the drop-down box.

Data Table Editor takes the Date Pattern, Time Pattern, and Time Zone settings from the
User Account Properties and uses them to render timestamps.

The editor always shows Date and Date/Time fields in the active user’s time zone.
If the user has not set a time zone: in Web UI, the editor uses the time zone of Iotellect Server.

Tooltips may show raw timestamp values without applying time zone conversion.
This is expected and does not affect how values appear in table cells.

There are two types of data sources the Data Table Editor can use:

The default and most commonly used option, which displays a single Data Table. No scrolling is available in this mode. Filtering and sorting are only applied to records in the table being viewed/edited.

In this mode table being edited represents a part of a longer list of objects (such as class instances) that's available on Iotellect Server side.

If object list is used as a source, scrolling and refresh buttons are available in the toolbar. If filtering or sorting rules are applied, the server-side objects are filtered/sorted instead of records in the currently visible table.

Data Table editor may work in various modes described in this section.

There are two editing modes available:

• Normal mode. This mode allows cell values to be modified, and rows to be added, deleted, reordered, selected, and deselected.

• Read-only mode. Editing data is not allowed in this mode.

There are also two data presentation modes:

• Multiple Records mode. In this mode, the table header shows the description for every column, and every row represents one Data Table record.

• Single Record mode (also called Vertical mode). This mode is used by the DTE when the table being edited contains just one record, and no extra records may be added. This mode features a two-column layout: the left column shows field names, and the right one contains values.

The Data Table Editor toolbar provides access to the operations that may be performed with the data table.

	Show/Hide Advanced Properties	This toggle button is used to show and hide fields or columns that are marked as advanced.
	Add Row	Inserts a new row before the currently selected one. If no row is selected, a new row is added to the end of table. This button is disabled or hidden if rows may not be added to the table. If the component works in Server-side object list mode, this button inserts a new object into the server-side list rather than directly adding a record to the visible table. Another Data Table Editor is shown first to allow filling fields of the new object to be created. The new object will become visible only if it matches current filtering rules and fits current page. In most cases clicking on Refresh button will be required to see the new object
	Remove Selected Rows	Removes the currently selected row or rows. This button is slightly greyed if no rows are selected, and hidden if row deletion is not permitted. If the component works in Server-side object list mode, this button deletes object(s) from the server-side list in addition to removing corresponding records from the visible table.
	Next	Available when the number of rows exceeds the limit to display per page. Displays the next page of rows.
	Previous	Available when the number of rows exceeds the limit to display per page. Scrolls to the previous page.
	Move Row	The position of individual rows can be changed through a drag-and-drop action by clicking and holding the Move Row icon. The icon is not shown if rows cannot be reordered. Reordering rows in this way changes the actual data in the table, in contrast to sorting operations, which merely change how the data is displayed to the user.
	Reset Changes	Undoes all changes that were made to the table. This button is enabled only after a change is made in tables with the Read Only property disabled. This operation is not available on Class Data Tables.
	Create Relations	Available on Class Data Tables in Class Instance Dashboards which display class instances with at least one Many to Many relation. Opens a window which allows the creation of Many to Many relations.
	Import Data Table	Imports data from a file.
	Export Data Table	Exports data to a file.
	Help	Opens documentation article related to the data being edited/viewed.
	Horizontal Fit	Defines how table columns should be fitted horizontally in the available space.
see Value Quality icons	Value Quality	The indicator is displayed when the edited data table has quality metadata available. The actual icon depends on the current quality state. For details, see Properties Editor (Value Quality).
see Value Age icons	Value Age	The indicator is displayed when the edited data table has timestamp metadata available. The actual icon depends on the current age state. For details, see Properties Editor (Value Age).

The Data Table Editor handles bindings contained in the format definition of the Data Table being edited. When the editor loads, it reads the list of bindings for the table and processes them in the background. Bindings are evaluated and used to change cells in the table being edited. Binding expressions used by Data Table Editor may contain relative links to the cells of the table being edited, along with links to data from various contexts. To find out how to create these links, learn more about data bindings here.

[ ? ]

Common Variables: Name, Visible, Breakpoint Data, Column Span, Row Span, Content Overflow, Container Style, Custom Classes, Component Content Style, Preloader, Events, Bindings.

Data Table component serves as a foundation for some other components.

Variables (properties) shared with inherited components are described in Shared Properties section.

The data table to be displayed in the component.

Record Format:

Format of this variable is dynamic.

Properties to allow data from the Data Table property to be displayed as nested rows similar to the Custom Tree component. To correctly display nested data, the table data must contain a Record ID Column with a unique ID for each record and a Parent Record ID Column indicating the Record ID of a record’s parent record. Top level records have NULL specified in their Parent Record ID Column.

Record Format:

Allows nested records to be automatically expanded to the indicated depth. Setting Record Expansion Depth to 1 will automatically open all child nodes of the top-level records, setting it to 2 will open all of the children’s child nodes, and so on.

Record Format:

Controls which nested rows within the Data Table Editor are initially expanded upon rendering. This property accepts a list of IDs corresponding to the records (rows) you want to be displayed in an expanded state by default. Rows not included in this list will be initially collapsed, requiring action from a binding or user interaction to reveal their nested content.

Record Format:

Defines columns that must contain unique values within the same nesting level. If moving a record creates a duplicate value in any of these columns at the destination level, the move is cancelled and a warning is displayed.

Record Format:

Applied when Nested Records Settings are configured to display nested row data. The indicated image replaces the default Opened Switcher Image.

Record Format:

Applied when Nested Records Settings are configured to display nested row data. The indicated image replaces the default Closed Switcher Image.

Record Format:

[ ? ]

Functions shared with inherited components are described in Shared Functions section.

[ ? ]

Data Table component serves as a foundation for some other components.

Events shared with inherited components are described in Shared Events section.

Was this page helpful?

Tell us more

Send

Thank you!