Page tree
Skip to end of metadata
Go to start of metadata

Summary

Reads the content of an editable data table. A Friend operator for the Editable Grid Portlet and the Editable EJS Chart Portlet.

Example

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 5.0 and enter the previously generated TIS Table.

If you want to connect to an Editable EJS Chart Portlet, you have to check "Display row ID".


Check the checkbox for TIS Board connection of a data node.

Result

In the next step, create an Editable Grid Portlet or an Editable EJS Chart Portlet referencing this data node.

Project-File...

Want to learn more?

 Settings

Reads the content of an editable data table.

Parameter

ParameterValueOpt.DescriptionExample
Select TIS table

System.String

-Name of the data table that is being read-
or record table

System.String

opt.--
@TABLEVERSION

System.Int32

opt.--
FilterSystem.Stringopt.

Filter expression that defines disjoint sets of the specified TIS table. Only AND-conjunction and EQUALS or ISNULL operations. Parameters may be used with #XI.TISPar('...')# syntax. Columns may be referred by index, such as @A@, or by caption, such as @User@.


Order By

System.String

opt.Columns to be used to sort the result-
Display row ID

System.Boolean

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

System.Boolean

-Portlets adopt changes of data model (e.g. changed column name or column type)-
@SETTINGS

System.String

---
Generate blank row if nothing has been found

System.Boolean

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 line

System.String

opt.If the filter operator creates a blank line, then this text will be displayed in all text columns.-



 Troubleshooting
ProblemFrequent CauseSolutions
...

...

Related topics