The TIS Table is usually written by the TIS Board - Generate editable data table 4.0 operator in some data node.
This TIS Table is then read and the data provided to the TIS Board by the TIS Board - Read editable data table 5.0 operator. This operator must be in the last operation of a data node that is connected to TIS Board
The Editable Grid Portlet retrieves the data via this data node. It edits the TIS Table directly.
Conflicts can occur when the table is edited by both, a TIS Board - Generate editable data table 4.0 operation and by the Editable Grid. This can happen, when the node containing the operation is set to automatic recalculation. Then changes in an ancestor the node trigger the operation to overwrite data entered by the Editable Grid Portlet.
Also, the operation can be triggered by an event from TIS Board, e.g., in order to create a new TIS Table with some user's name on Logon.
The following can be done to avoid such conflicts.
- Set parameter "Create only new table" in TIS Board - Generate editable data table 4.0 operator to true. Then the operation will never overwrite if there already exists a table.
- Set the data node's recalculation modality to "Manual": Changes from the Editable Grid Portlet can only be overwritten manually.
- Set the data node's recalculation modality to "Fixed" No changes can be made from either TIS Editor or the Editable Grid (changes in the Grid will be lost).
|Create a Portlet, choose the TIS Editor project, the data node containing the TIS Board - Read editable data table 5.0 operation, and portlet Editable Grid.|
|Edit the Settings (see below and Conditional Formatting for Grids)|
|Switch to View Mode and use the Grid, see Editing data in an Editable Grid|
|The Controller Portlet allows to manage the update and retrieval of data from an editable grid.|
General Portlet properties see List of Portlet Properties.
Editable Grid properties
|Retain column titles||bool|
|Retain column formats|
|Banded rows||Alternating show rows with background color white and grey for better readability.|
|Show row numbers||Show additional column with row numbers.|
|Show default values|
|Disable column selection|
|Enable add rows||Allow adding rows. The add icon is shown in the tool bar.|
|Enable delete rows||Allow deleting rows. The delete icon is shown in the tool bar.|
|Send data only when saving|
Toggle automatic sending of the data is automatically to the database only at clicking the save button.
|Activate selection mode|
|Activate overwrite mode|
|Only copy/paste visible columns|
The text entered as column description appears as tool tip on the column headers.
Wrap lines at the column's width. If disabled, then long lines show ellipsis (...) at the end in order to fit the column's width.
Newline control characters in the input string
A Combo Box allows to input predefined values.
|Dynamic list||TIS Board - Selection list for editable data table provides data for selection.|
This is the functionality if two columns with true/false values exclude each other (e.g. male/female)
Automatically or manually Save
Users can choose if data is automatically sent to the database or if it is sent only at clicking the save button.
Default values can be defined for new rows in the Portlet Designer.
|User definied function for default values|
Add following function to TISBoardSettings.js, which replaces the 01.01.9000 to the today's date and 02.01.9000 to the tomorrow's date.
Please note that the portlet name (in the following example "a00 Default Values") has to be specified. This may be a regular expression as well.
Content that will be pasted via copy/paste will be checked if there is a static combo in one of the columns.
Editable Grid does not work
|Cannot edit Editable Grid||Portlet designer is open and portlet is not saved||Save the portlet|
|User rights are not properly set in TIS Board||Obtain the necessary rights|