CST_QueryResultTable (ver6.2.2)
Each record in this table represents a query level result table that is generated as part of a report request. Previously, there was only one (report level) result table generated per process instance (and also only one per sub-process instance that is merged to the parent process). This feature now allows more than one result table to be generated per process instance.
Column Name | Initial Version | Data Type | Description |
---|---|---|---|
ID | 6.2.2 | Number(19,0) | Sequential number generated by the application, uniqueness in the table is guaranteed by Primary Key Unique Index. Required. |
ParamName | 6.2.2 | Varchar2(50) | The parameter name to which the generated result table name will be bound such that it is available to IBATIS SQL queries. |
QueryID | 6.2.2 | Number(19,0) | The internal number for the associated CST_Query record. |
ResultTableNamePattern | 6.2.2 | Varchar2(50) | The table-naming pattern for the generated query-level result table. |
SortIndex | 6.2.2 | Number(6,0) | Indexing field used by Hibernate. |
SortOrder | 6.2.2 | Number(6,0) | Indicates the sorting order for the render expressions. |
WhenCreated | 6.2.2 | Timestamp(6) | Date and time the record was created. Defaults to system date. |
WhenModified | 6.2.2 | Timestamp(6) | Date and time the record was modified. Defaults to system date. |
WhoCreated | 6.2.2 | Varchar2(100) | The user login that created the record. Defaults to database user. |
WhoModified | 6.2.2 | Varchar2(100) | The user login that modified the record. Defaults to database user. |