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 uses Date Pattern, Time Pattern and Timezone settings specified in User Account Properties to properly convert and render different timestamps.

All date/time values are shown in active user's timezone. If the timezone is not specified in user settings, the timezone of the Iotellect Server will be used.

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.

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, Breakpoints, 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.

[ ? ]

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!