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.
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. |
|
If cell tooltip provides some important extended information, the cell is marked with a small blue triangle:
|
Table columns can be resized and reordered. To resize a column click on its margin and drag the mouse to left or right. To change column order, drag the column header and drop it in a new location.
Double-clicking the separator between headers of two columns will auto-fit the left-hand's column width (i.e, resize it to fit everything in it).
|
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. |
Data Table Editor may work in two modes:
| • | Normal mode |
| • | Read-only mode |
In the read-only mode editing is disabled.
There are also two data presentation modes:
| • | Multiple records mode |
| • | Single record mode |
In multiple records mode, the table header shows the description for every column, and every row represents one Data Table record:
Single record 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.
|
Add Row |
Insert 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. |
|
Remove Selected Rows |
Remove the currently selected row(s). This button is disabled or hidden if rows may not be removed. |
|
Move Row Up |
Move current row up. This button is not shown if rows may not be reordered. It changes actual data in the table (in contrast to the sorting operation, which merely changes how the data is shown.) |
|
Move Row Down |
Move currently row down. This button is not shown if rows may not be reordered. It changes actual data in the table (in contrast to the sorting operation, which merely changes how the data is shown.) |
|
Reset Changes |
Undo all changes that were made to the table. This button is enabled only after a change is made. |
|
Enable/Disable Horizontal Scrolling |
If horizontal scrolling is disabled, width of all columns is adjusted automatically to fit the width of Data Table Editor window. If scrolling is enabled, Data Table Editor has a horizontal scrollbar and width of all columns is adjusted to fit their contents. This option is disabled by default. |
|
Import Data Table |
Imports data from a file. |
|
Export Data Table |
Exports data to a file. |
|
Make Report |
Generate a report based on the table being edited or viewed. |
|
Help |
Open documentation article related to the data being edited/viewed. |
Some (or even all) toolbar buttons may be hidden or disabled if their respective operations are not available in the editor. A button is hidden if the operation is not applicable to the current table at all. If an operation is simply not available at the moment (e.g. the Remove Selected Rows is disabled when no rows are selected), its button is disabled.
Processing Data Bindings
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.