CST_QueryDependency (ver6.2.2)
Each record in this table represents a condition to be evaluated over certain dependencies in order to determine whether the query should be performed or whether it should be skipped. The dependencies can be either user-entered parameters or results of previous query steps. If at least one dependency has not been met (failed), then the query is skipped. If all dependencies are met, then the query proceeds as expected.
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) | Name of a user-entered parameter or result from a previous query step to be compared against a value in order to determine whether the condition has been met. |
QueryID | 6.2.2 | Number(19,0) | The internal number for the associated CST_Query record. |
SortIndex | 6.2.2 | Number(6,0) | Indexing field used by Hibernate. |
SortOrder | 6.2.2 | Number(6,0) | Indicates the order by which results are arranged. |
Value | 6.2.2 | Varchar2(200) | The value to compare the parameter against. |
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. |