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

Summary

Creates a TIS Table with HTML or text representation of the input data.This operator allows to store metadata of operations in a TIS table. Data can be collected after each operation in a data node. This way, information on timing and duration of an operation can be obtained and used to investigate update processes.

Table ranges


Definition which columns should be in the report.

Settings


Select the folder and the TIS Table were the report data should be stored.
Very often there is a "first" node in the chain to be analyzed. By selecting this option, one has a clean report and avoids the need for manual clean up.
Heading, Chapter and Description are fields where you may add text that is the used in a larger report (similar to a book). Leave it empty for short reports.
Order number has two usages:

  1. If you use the operator several times in one node, the time stamp may be identical. By using 1,2,3… as order number it is easy to sort your report rows.
  2. You may give numbers that allow to reference specific records in a report later to be built with Stimulsoft.

 


Output formats:

Characters per column: limits the number of characters for better display.

Select rows: shows only a sample of the defined rows Filter: filter what should be display (see also Filter on columns 1.1)
Note:

  1. The first row is denoted by the number 0.
  2. If you combine Filter and Select rows, the latter must refer to the number of data rows figuring Filter values. E.g., if you filter on all rows with ID = 3 and the first row in the total data table figuring ID = 3 has the rownumber 64, then you must enter in Select rows: 63 to show the data.

    If you want to have also information on the value of specific parameters, list them here. E.g., you will see the name and value in the table.
    Disable allows you to switch on and off reporting with a parameter.

Next Steps

The data can be processed in Stimulsoft reports (see Stimulsoft (Portlet) and Designing a Stimulsoft Report) or as Simple Grids in the TIS Board.

Example: ...

Situation

...

Settings...
Result

...

Project-File...

Want to learn more?

 Settings

Creates a TIS table with HTML or text representation of the input data.

Columns of input table


ParameterValueOpt.DescriptionExample
Which columns are to be output?

System.Int32

opt.Report columns-

Parameter


ParameterValueOpt.DescriptionExample
Delete existing report data first

System.Boolean

-Deletes existing data before the data defined here is written-
Select folder

System.String

-Name of the folder-
or enter folder

System.String

opt.Name of the folder, parameter possible. E.g.: Folder1\#XI.TISPar('Par1')#\Folder3-
Create folder if it does not exist

System.Boolean

-A new folder or the entire path will be created if it does not already exist-
Table

System.String

-Name of the table which will be saved to.-
Header

System.String

opt.Header of report.-
Chapter

System.String

opt.Chapter text, is output in the report.-
Description

System.String

opt.Description text that is output in the report.-
Ordinal number

System.Double

opt.The ordinal number is intended to support sorting of individual components in the final report.-
[TIS]Parameter

System.String

opt.[TIS]Parameter that are to be output (several parameters separated by commas). Example: #XI.TISPar('Par1')#,#XI.TISPar('Par2')#-
Disable output

System.Boolean

opt.If selected, the data output of the operator in the table is deactivated.-
Overwrite older entries from the same node

System.Boolean

opt.Collecting Report overwrites older entries from the same node-
Processing report data for table report

System.Boolean

opt.Processing report data for table report-
Output format

System.String

  • HTML output as table rows
  • Text output with filler blanks to standardize the column width
  • Text output with fixed number of characters per column
  • Text output with separator #
  • Text output with tabulator separator
-Selection of report format (HTML or text).-
Characters per column

System.Int32

opt.Number of characters per column if output format is 'fixed number of characters'-
Row selection

System.String

opt.

Enter the requested row numbers.

5-10...Select row 5 to 10.
B1-B10...Select last 10 rows.
10-B1...Select all as of row 10.
-
Filter

System.String

opt.Filter condition, syntax analogous to operation 'Filter on columns'-

 Examples

Example 1: ...

...

Calculation methodSettingsResult
... 

 

 Troubleshooting
ProblemFrequent CauseSolutions
... 

...

Related topics

  • ...

1 Comment

  1. New Parameter for writing msec-column into TIS table.

    FLEX-69 - Getting issue details... STATUS