dbo.DialogReportQuery
Report queries
TableType TUsage CONFIGURATIONRows 640SizeMB 1.336
Table relation graph
Loading table relation graph…
Columns
| Name | Type | Nullable | OIM caption/commentary | Flags |
|---|---|---|---|---|
UID_DialogReportQuery | varchar(38) | no | Report query | PKUID |
UID_DialogReport | varchar(38) | no | Report | FKUID |
QueryName | nvarchar(510) | yes | Name | |
QueryDefinition | nvarchar(-1) | yes | Query | |
Description | nvarchar(510) | yes | Description | |
XDateInserted | datetime(8) | yes | Created on | |
XDateUpdated | datetime(8) | yes | Modified on | |
XUserInserted | nvarchar(128) | yes | Created by | |
XUserUpdated | nvarchar(128) | yes | Modified by | |
XTouched | nchar(2) | yes | Processing status | |
SortOrder | int(4) | yes | Sort order | |
ViewName | nvarchar(128) | yes | View name | |
ViewWhereClause | nvarchar(-1) | yes | Condition | |
ViewOrderClause | nvarchar(510) | yes | Order by | |
ObjectColumns | nvarchar(-1) | yes | Columns | |
ObjectWhereClause | nvarchar(-1) | yes | Condition | |
ObjectOrderClause | nvarchar(510) | yes | Order by | |
XObjectKey | varchar(138) | no | Object key | |
HListBackTo | nvarchar(64) | yes | Min. date or range | |
HListResolveFKs | bit(1) | yes | Resolve foreign key | |
HObjObjectKey | nvarchar(528) | yes | Object key | |
HObjBackTo | nvarchar(64) | yes | Min. date or range | |
HObjResolveFKs | bit(1) | yes | Resolve foreign key | |
ObjectResolveFKs | bit(1) | yes | Resolve foreign key | |
HAssignBackTo | nvarchar(64) | yes | Min. date or range | |
HAssignCriteriaColumn | nvarchar(64) | yes | Criteria column | |
HAssignCriteriaValue | nvarchar(512) | yes | Criteria value | |
HAssignDeactivationFlagColumn | nvarchar(64) | yes | Disabling columns | |
UID_DialogReportQueryParent | varchar(38) | yes | Parent query | FKUID |
HAssignObjectColumns | nvarchar(-1) | yes | Additional object columns | |
QueryData | nvarchar(-1) | yes | Configuration data | |
UID_DialogReportQueryModule | varchar(38) | yes | Query module | FKUID |
UID_DialogTableObject | varchar(38) | yes | Table | FKUID |
UID_DialogTableHList | varchar(38) | yes | Table | FKUID |
UID_DialogTableHAssign | varchar(38) | yes | Table | FKUID |
XMarkedForDeletion | int(4) | yes | Marked for deletion | bitmask |
MaxRowCount | int(4) | yes | Max. rows | |
HObjColumns | nvarchar(-1) | yes | Columns | |
HListColumns | nvarchar(-1) | yes | Columns | |
HAssignFKColumn | nvarchar(64) | yes | Foreign key to query | |
HAssignType | int(4) | yes | Assignment direction | limited |
Relations
| FK | From | To |
|---|---|---|
| QBM_RFRL196 | DialogReportQuery.UID_DialogReport | DialogReport.UID_DialogReport |
| QBM_RFRL310 | DialogReportQuery.UID_DialogReportQueryModule | DialogReportQueryModule.UID_DialogReportQueryModule |
Triggers
GEN_T137E7861F2A6A332B27AE5C9B SQL_TRIGGER
GEN_T2232A653BC4772F3DB52A2400 SQL_TRIGGER
GEN_T33D08998A45A27B9DF3750DAA SQL_TRIGGER
GEN_T5342C9CA629A078CB96F9CBE8 SQL_TRIGGER
Referenced by / reverse relations
Generated from live DB metadata, FK rows, and exported SQL dependency/source extraction. This is factual linkage evidence, not inferred behavior.
| Referencing object | Relation | Evidence |
|---|---|---|
| dbo.GEN_T137E7861F2A6A332B27AE5C9B | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T1595E400F0EF58FA78BBB507F | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T2232A653BC4772F3DB52A2400 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T22E3A49AD6FB23D89269E99A0 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T33D08998A45A27B9DF3750DAA | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T5342C9CA629A078CB96F9CBE8 | SQL expression dependency | OBJECT_OR_COLUMN |
| DialogReport | referenced by foreign key from table | QBM_RFRL196: DialogReportQuery.UID_DialogReport -> DialogReport.UID_DialogReport |
| DialogReportQueryModule | referenced by foreign key from table | QBM_RFRL310: DialogReportQuery.UID_DialogReportQueryModule -> DialogReportQueryModule.UID_DialogReportQueryModule |