Read TIS table 5.0

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.

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

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')#

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.

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 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}.

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

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

 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.

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.