Data Table Editor
Data Table Editor component is designed to view and edit tabular data (Data Tables). |
|
More information on what this component looks like and behaves may be found here.
This is what a Data Table Editor looks like:
Common Properties
Width, Height, Bindings, Enabled, Visible, Border
Custom Properties
Toolbar
Controls whether or not to show the toolbar of the Data Table Editor.
Property name: toolbar
Property type: Boolean
Allow Vertical Mode
If enabled, allows the editor to switch to vertical (single-record) mode if format of the table has both minimal and maximal record count set to one.
Property name: allowVerticalMode
Property type: Boolean
Enable Tooltips
Controls whether or not to show the tooltip of the Data Table Editor.
Property name: enableTooltips
Property type: Boolean
Enable Popup Menu
Controls whether or not to show the context menu of the Data Table Editor.
Property name: enablePopupMenu
Property type: Boolean
Show Metadata
Controls whether or not to show metadata of the Data Table Editor.
Property name: showMetadata
Property type: Boolean
Fixed Format
Defines whether the Data Table Editor should accept only tables of pre-defined format. If this option is enabled, it's possible to edit the Format property (see below) and, after defining table format, fill the table with pre-defined data by editing Data Table property (also described below).
 | At the moment when this flag is enabled, data in the Data Table property will be converted to match current value of Format. |
Property name: fixedFormat
Property type: Boolean
Format
Allows to specify a fixed format of table to be viewed/edited in the Data Table Editor. See description of format options and individual field options in Data Table format section.
| At the moment when the Format is changed, data in the Data Table property will be converted to match the new format. |
Property name: format
Property type: Data Table
Data Table
Default data table shown and edited by this component.
| When this option's value is changed to a new Data Table, the system will convert this table to match the Format property (this happens only if Fixed Format flag is set). |
Property name: dataTable
Property type: Data Table
Show Horizontal Gridlines
Enables horizontal grid lines.
Property name: showHorizontalGrid
Property type: Boolean
Show Vertical Gridlines
Enables vertical grid lines.
Property name: showVerticalGrid
Property type: Boolean
Table Header Properties
Sets visibility and line wrap of table header and it's foreground and background colours.
Property name: headerProperties
Property type: Data Table
Line Wrap
Sets line wrap of table cells.
Property name: lineWrap
Property type: Boolean
Show Record Numbers
Sets visibility of record counter column.
Property name: showRecordNumbers
Property type: Boolean
Selected Row Color
Sets custom color for selected rows.
Property name: selectedRowTable
Property type: Data Table
Added Record Processing Expression
An expression that it evaluated for processing every new table record. It is used during execution of Process Changes function. See documentation of Process Changes function for more information.
Property name: addedRecordProcessingExpression
Property type: String
Changed Record Processing Expression
An expression that it evaluated for processing every modified table record. It is used during execution of Process Changes function. See documentation of Process Changes function for more information.
Property name: changedRecordProcessingExpression
Property type: String
Removed Record Processing Expression
An expression that it evaluated for processing records that has been removed from the table. It is used during execution of Process Changes function. See documentation of Process Changes function for more information.
| Records processed by this expression are not visible in the table. They are stored in internal removed records list. |
Property name: removedRecordProcessingExpression
Property type: String
Common Events
Custom Functions
Process Changes
This function has no input parameters. It instructs the table editor to process its internal list of added, changed and removed records:
- For every added record (even if it was modified later on), Added Record Processing Expression is evaluated. If the expression returns anything except for
false, record's internal "new record" flag is cleared. The expression can, for example, call an Execute Query function of a server-side SQL database device account to INSERT new record into an arbitrary database. - For every changed record, Changed Record Processing Expression is evaluated. If the expression returns anything except for
false, record's internal "changed record" flag is cleared. The expression can, for example, execute an UPDATE query over an external database connected to Iotellect Server through an SQL database device driver. - For every removed record (except for records that were previously added in the Data Table Editor itself), Removed Record Processing Expression is evaluated. If the expression returns anything except for
false, record it deleted from internal removed records list. The expression can, for example, execute a DELETE query over an external database to delete a database record with a key taken from record data.
Added/Changed/Removed Record Processing Expression Resolution Environment: | |
Default context of the widget. | |
Added/changed/removed record that's being processed. The record is wrapped into a single-cell table. Note, that the default table it NOT the whole table stored in the Data Table Editor. | |
0 | |
Standard variables only. |
 | Related tutorial: |
Function name: processChanges
Custom Events
Row Selection
This event is fired when some table rows are selected or unselected.
Event name: rowSelection
Event fields:
Field | Name | Type | Description |
Is Adjusting | isAdjusting | Boolean | Returns whether or not this is one in a series of multiple events, where changes are still being made. |
First Row | firstRow | Integer | Index of the first row which selection may have changed. |
Last Row | lastRow | Integer | Index of the last row which selection may have changed. |
First Record | firstRecord | Integer | Index of the first Data Table record row which selection may have changed. May differ from the First Row due to table sorting, filtering, grouping, etc. |
Last Record | lastRecord | Integer | Index of the last Data Table record row which selection may have changed. May differ from the Last Row due to table sorting, filtering, grouping, etc. |
Selection | selection | Data Table | A list of currently selected rows, with two fields:
|
Reference Clicked
This event is fired when clicked a reference in the table.
Event name: referenceClicked
Event fields:
Field | Name | Type | Description |
Reference | reference | String | Returns executed reference. |
Field | field | String | Returns field name of cell where reference was placed. |
Record | record | Integer | Returns record number of cell with executed reference. |
Data | data | Data Table | Returns value of cell with launched reference. |
Was this page helpful?