Summary
TIS Board operator for the Editable Grid Portlet and the Editable EJS Chart Portlet. Delivers data from a TIS Table to the portlet.
Data can be filtered, e.g. @UserName@ == #XI.TISPar('UserNameTIS')#
Configuration
Settings
System.String System.String System.Int32 Filter expression that defines disjoint sets of the specified TIS table. Only AND-conjunction and EQUALS or ISNULL operations. TIS Parameters may be used with E.g. @UserName@ == #XI.TISPar('UserNameTIS')# System.String System.Boolean System.Boolean System.String System.Boolean System.StringName Value Opt. Description Example Select TIS table - Name of the data table that is being read - or record table opt. - - @TABLEVERSION opt. - - Filter expression System.String opt. #XI.TISPar('...')# syntax. Columns may be referred by index, such as @A@, or by caption, such as @User@.Order By columns opt. Columns to be used to sort the result - Display row number/ID opt. Add a column with a row id to the output. Needed if used for a Editable EJS Chart Portlet. - Apply changes of data model - Portlets adopt changes of data model (e.g. changed column name or column type) - settings - - - Blank row if result is empty opt. Must a blank line be created if filtering does not find anything? Zero will be entered in the numerical columns or the data columns, the text located in the parameter "Content text fields in case of blank line" will be displayed in the text columns. - Text fields content for blank row opt. If the filter operator creates a blank line, then this text will be displayed in all text columns. - Table updates affect other project clones too System.Boolean opt. Table updates affect other project clones too
Want to learn more?
Reads the content of an editable data table.
Examples
Example: Read editable data table
| Situation | A TIS Table has been created as editable data table (see TIS Board - Generate editable data table 4.0) and is to be displayed in TIS Board. |
|---|---|
| Settings | Create an empty node, add the operator TIS Board - Read editable data table 7.0 and enter the previously generated TIS Table using the brows menu or enter it manually.
If you want to connect to an Editable EJS Chart Portlet, you have to check "Display row number". After pressing "Save operation" you will see the table that you selected in you data node.
Now we need to open the "TIS Board". This can be done by clicking on the "TIS Board" checkbox.
Now a blue plus sign should pop up.  Please click on the plus sign to create a new portlet. After connecting to the "TIS Board" please select you project then your data source then the presentation method you need. I would recommend "Editable Grid" but it depends on the table. Now click on apply.
|
| Result |  |
| Project-File | - |
Troubleshooting
Nothing known up to now.