dbo.DialogParameter
Parameters
TableType TUsage CONFIGURATIONRows 245SizeMB 0.288
Table relation graph
Loading table relation graph…
Columns
| Name | Type | Nullable | OIM caption/commentary | Flags |
|---|---|---|---|---|
UID_DialogParameter | varchar(38) | no | Parameter | PKUID |
UID_DialogColumnQuery | varchar(38) | yes | Table column (query) | FKUID |
UID_DialogParameterSet | varchar(38) | no | Parameter set | FKUID |
ParameterName | nvarchar(510) | no | Parameter name | |
ParameterType | nvarchar(64) | yes | Parameter type | limited |
DisplayName | nvarchar(512) | yes | Display name | |
ParameterValue | nvarchar(-1) | yes | Parameter value | |
DefaultValue | nvarchar(-1) | yes | Default value | |
ExampleValue | nvarchar(-1) | yes | Sample value | |
DataType | int(4) | yes | Data type | limited |
IsMandatory | int(4) | yes | Mandatory parameter | limited |
IsVisibleForChildren | int(4) | yes | Show in parameter subsets | limited |
IsOverridable | int(4) | yes | Can be overwritten | limited |
DataSourceType | varchar(16) | yes | Data source | limited |
LimitedValues | nvarchar(-1) | yes | List of permitted values | |
QueryWhereClause | nvarchar(-1) | yes | Condition (query) | |
SortOrder | nvarchar(32) | yes | Sort order | |
ValidationScript | nvarchar(-1) | yes | Validation script | |
UID_DialogColumnCalculate | varchar(38) | yes | Table column (calc.) | FKUID |
ValueScript | nvarchar(-1) | yes | Valuation script | |
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 | |
XObjectKey | varchar(138) | no | Object key | |
IsEmptyValueOverrides | bit(1) | yes | Empty value overrides | |
IsMultiValue | int(4) | yes | Multivalue | limited |
IsMultiLine | int(4) | yes | Multiline | limited |
CalculateWhereClause | nvarchar(-1) | yes | Condition (calc.) | |
IsRange | int(4) | yes | Range | limited |
UsePredefinedRange | int(4) | yes | Predefined range | limited |
DisplayForParameterValue | nvarchar(2048) | yes | Display value for parameter value | |
XMarkedForDeletion | int(4) | yes | Marked for deletion | bitmask |
Description | nvarchar(2048) | yes | Description | |
DataDisplayPattern | nvarchar(1024) | yes | Display template | |
DateTimeDetail | int(4) | yes | Date add-on | limited |
OnPropertyChangedScript | nvarchar(-1) | yes | Data dependencies script | |
QueryDisplayType | int(4) | yes | Type of display | limited |
Relations
| FK | From | To |
|---|---|---|
| QBM_RFRL313 | DialogParameter.UID_DialogParameterSet | DialogParameterSet.UID_DialogParameterSet |
Triggers
ATT_TUDialogParameter SQL_TRIGGER
GEN_T17303E5B3C99B5F92BFE66D79 SQL_TRIGGER
GEN_T24CEDE786C28F814B06F8750E SQL_TRIGGER
GEN_T3117EC8FB893CF28D2ADFC650 SQL_TRIGGER
GEN_T5939833470165F9F6A56909DB SQL_TRIGGER
QBM_TDAssembly_DialogParameter SQL_TRIGGER
QBM_TIAssembly_DialogParameter SQL_TRIGGER
QBM_TIDialogParameter SQL_TRIGGER
QBM_TUAssembly_DialogParameter SQL_TRIGGER
QBM_TUDialogParameter 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_FT4C7BC4445A0341819B629866 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FTF3A3F8BCA98F86D47979C4BF | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_PRulerDetect_OX | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_PRulerDetect_PX | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_FT0F901AD6507907BB01E4A981 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T30FD7D35FC495D5D5685F4017 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.GEN_T5939833470165F9F6A56909DB | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QBM_TUAssembly_DialogParameter | SQL expression dependency | OBJECT_OR_COLUMN |
| DialogParameterSet | referenced by foreign key from table | QBM_RFRL313: DialogParameter.UID_DialogParameterSet -> DialogParameterSet.UID_DialogParameterSet |
| dbo.QER_PRulerDetect_OX | source text reference | has TRY/CATCH error handling |
| dbo.QER_PRulerDetect_PX | source text reference | has TRY/CATCH error handling |
| dbo.QBM_TUAssembly_DialogParameter | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| cs-att-compositionapi-server-plugin-att-compositionapi-attestation-claimdeviceownershipapi.cs | decompiled C# reference | classes ClaimDeviceOwnershipApi; methods MoveNext, SetStateMachine, Build, CreateAsync; references AttestationPolicy, DialogColumn, DialogParameter, DialogParameterSet, Hardware, Person; markers reads entity values, writes entity values, references DB/Dialog objects |
| cs-att-customizer-att-customizer-attestationpolicy.cs | decompiled C# reference | classes AttestationPolicy, ReportEngine, _003C_003Ec__DisplayClass11_0, _003C_003Ec__DisplayClass18_0; methods _003CCreateAttestation_003Eb__0, _003CPrepareAttestations_003Eb__0, _003CCompleteCasesUnderConstruction_003Eb__0, _003CCompleteCasesUnderConstruction_003Eb__2, _003C_GetGrantedCases_003Eb__0, _003C_CreateAttestations_003Eb__0; references AttestationCase, AttestationHelper, AttestationObject, AttestationObjectHasPWODM, AttestationPolicy, AttestationPolicyGroup; markers reads entity values, writes entity values, references DB/Dialog objects, Job/process related markers |
| cs-common-customizer-vi-common-customizer-dialogrichmail.cs | decompiled C# reference | classes DialogRichMail, _003C_003Ec__DisplayClass1_0; methods MoveNext, SetStateMachine, _003C_CopyAsync_003Eb__1, _CopyAsync; references DialogParameter, DialogParameterSet, DialogRichMail, DialogRichMailBody, DialogRichMailImage; markers reads entity values, saves entities, references DB/Dialog objects |
| cs-qbm-forms-vi-common-forms-frmdialogrichmailstammdaten.cs | decompiled C# reference | classes FrmDialogRichMailStammdaten; methods OnInit, OnDispose, OnDesignChanged, InitializeComponent, OnFormLoad, OnFormSizeChanged; references DialogCountry, DialogCountryHasCulture, DialogParameter, DialogParameterSet, DialogReport, DialogRichMail; markers reads entity values, references DB/Dialog objects |
| cs-qer-customizer-qer-customizer-person.cs | decompiled C# reference | classes Person, MP, _003C_003Ec__DisplayClass11_0, _003C_003Ec__DisplayClass11_1; methods _003C_LoadShoppingCartPattern_003Eb__0, _003C_LoadShoppingCartPattern_003Eb__1, _003C_LoadShoppingCartPattern_003Eb__3, _003C_LoadShoppingCartPattern_003Eb__2, _003C_UpdateShoppingCartPattern_003Eb__0, _003C_UpdateShoppingCartPattern_003Eb__1; references AccProduct, AERole, Delegation, DialogColumn, DialogGroup, DialogParameter; markers reads entity values, writes entity values, saves entities, references DB/Dialog objects, IT Shop related markers, Job/process related markers |
| cs-qer-customizer-qer-customizer-personwantsorg.cs | decompiled C# reference | classes PersonWantsOrg, MP, WellKnownDecisionRules, DecisionHistoryArgs; methods MoveNext, SetStateMachine, _003C_GetUIDPwoState_003Eb__0, _003CInitializeMNRelationKeys_003Eb__0, _003CBaseTreeAssign_003Eb__0, Abort; references AccProduct, BasetreeAssign, BaseTreeHasObject, ComplianceRule, Delegation, Department; markers reads entity values, writes entity values, references DB/Dialog objects, IT Shop related markers, Job/process related markers |
| cs-rps-customizer-rps-customizer-rpsreport.cs | decompiled C# reference | classes RPSReport; methods MoveNext, SetStateMachine, _CreateParameterSet, OnSavedAsync; references DialogParameter, DialogParameterSet, DialogReport, RPSReport; markers reads entity values, references DB/Dialog objects |
| cs-rps-customizer-rps-customizer-rpssubscription.cs | decompiled C# reference | classes RPSSubscription; methods MoveNext, SetStateMachine, _CreateParameterSet; references DialogParameter, DialogParameterSet, RPSReport, RPSSubscription; markers reads entity values, references DB/Dialog objects |
| cs-rps-forms-rps-forms-formrpsreportmasterdata.cs | decompiled C# reference | classes FormRPSReportMasterData; methods OnInit, OnDesignChanged, InitializeComponent, OnFormLoad, OnFormSizeChanged, Task_Preview; references AccProduct, DialogParameter, DialogParameterSet, DialogReport, Person, RPSReport; markers reads entity values, writes entity values, references DB/Dialog objects, IT Shop related markers |
| cs-tsb-compositionapi-tsb-compositionapi-attestation-claimownerattestation.cs | decompiled C# reference | classes ClaimOwnerAttestation; methods MoveNext, SetStateMachine, CreateAsync; references AttestationPolicy, DialogColumn, DialogParameter, DialogParameterSet, Person; markers reads entity values, writes entity values, references DB/Dialog objects |