| Database Table DatadictionaryCustomQuery |
[This is preliminary documentation and is subject to change.]
The DatadictionaryTableCustomQuery table holds data about relationships between custom queries and tables in dynamic forms in TOPICA
Each row represent a custom query in dynamic form
FieldsField name | Type | Note | Description |
|---|---|---|---|
TableName | varchar(50) | Primary key, foreign key to DatadictionaryTable | Name of the table holding data for the dynamic form. |
SequenceNumber | int | Primary key | |
QueryType | varchar(50) | ||
QueryCaption | varchar(255) | ||
Computation | varchar(max) | ||
Query | varchar(max) |