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


This operator fetches the content of a TIS table into the data nodes.

Getting Started

This operator allows reading a TIS table from user defined folders or with user defined table names.
The definition of the folder and the table name are defined via a parameter and eventually with in the TIS Board.

Define a parameter for your folder and/or your table name.

Go to General Parameter for Operations and create parameters with Data Type "Text". Define a value for each parameter.

Read TIS table 3.0

The input Manual_TT#XI.TISPar('Read Folder')# reads the TIS Table from a subfolder of the folder "Manual_TT" with the name which was defined in the parameters.
The table name can also be a simple name or a parameter definition – like in the example: #XI.TISPar('Read Table')#

Read TIS Table 5

You may add parameters like this:

[c3] >= #XI.TISPar('Lesen Datum Von')#
and [c3] < #XI.TISPar('Lesen Datum Bis')#

and add things like (at the end)

and ([c0] like '% | STD_ANZ_ABG' or [c0] like '% | STD_ANZ'

or use textual replacement like:

and (#XI.TISParSQL('Reparieren')#)


Like importing data from SQL you can choose which data should be read from the TIS table:
Select: Choose only the columns you need with the respective column number C0, C1 … or by column names.
Where: Define which data in a column should be imported only. Define for each necessary column an ID number starting with 0. Then define in the field "Parameter for Where" the values for each ID. Order by: The sorting of imported data can be user defined. For that the column numbers can be typed into the field "Order by". If more than one column is applied, use comma as separator. By standard data is sorted ascending. If your data should be sorted descending, type "desc" after der column number.

Avoiding empty Tables

As of version 5.8 empty tables can be avoided by selecting the option. In case an empty table would be returned a defined warning appears instead of the table.

Using 'Where'

Using where directly for strings: 

Numbers can be entered directly.

{0} are used to refer to the number of a parameters in this part:  

In order to refer Parameters in a WHERE clause you need to create entry here. Use the syntax #XI.TISPar('par')#. In the WHERE clause use the Id in curly brackets, such as {0}. Columns must be referred by their index, such as c0, c1. Note that columns must be in squared brackets, e.g. [c0] = {0}.

Using Parameters for 'Where'

As of version 5.8 parameters can be used to define the 'where' in Read TIS Tables.

(warning) Note that at least one parameter must be definied in the "Parameter for Where" setting in TIS version before 6.0.

(warning) Starting from Operator Version 8 "Select", "Where" and "Order By" are controllable by a parameter, see also Use Parameters in Operations.
This filters all data with the value of the parameter in column c1.


As of Version 5.10 a selection can be made DISTINCT


Start from Version 5.16 a timeout for the query execution can be specified. Default is 30 sec. 0 deactivates the timeout.

Result type

Following options are available

  • Table content: returns the content of the specified TIS table
  • Information about table structure: returns the meta information of the specified TIS table, having a row for each column.

Want to learn more?

This operator fetches the content of a TIS table into the data nodes.




opt.Select a TIS table-
or: table (incl. path) manually


opt.Parameter possible. E.g.: Folder1\#XI.TISPar('Par1')#-
Result type


  • Table content
  • Information about table structure
-Which results must the query deliver? Table content or information about table structure-
Max. rows


opt.How many lines must the result deliver as a maximum (0 = all)?-


opt.Corresponds to the Select section of a SQL query.-


opt.Corresponds to the where section of a SQL query. Columns are named according to the pattern C0, C1, ...Cn. They will be assigned the parameters {0}, {1}, ...{n}.-
Order By


opt.Corresponds to the Order By section of a SQL query. Delimited by comma or semicolon.-
Generate blank row if nothing has been found


opt.Should a blank line be created if the result is blank? Zero is entered in the numerical columns or the data columns; the text located in parameter "Content text fields in case of blank line" is displayed in the text columns.-
Text fields content for blank line


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



ProblemFrequent CauseSolutions

Error: Cannot read TIS Table

Path is incorrect

Check Table path (e.g., has PATH Parameter been changed)

Error: Cannot read TIS Table

Operation settings "Order by" are wrong (e.g., it looks for 2 columns but your TIS Table has only 1)

Check settings and number of columns in your TIS Table, and adapt settings if necessary

Related topics