dbo.QBM_PUserDetectByGroupList
SQL_STORED_PROCEDURE
Created 2025-06-27T17:57:28.520 · modified 2026-04-14T23:20:24.740 · source: live DB sys.objects/sys.sql_expression_dependencies.
Parameters
| Name | Type | Output |
|---|---|---|
@GroupGuidList | nvarchar | no |
@uid_DialogUser | varchar | yes |
@UID_QBMProduct | varchar | no |
Referenced objects
| Schema | Object | Column/minor | Class |
|---|---|---|---|
| dialogGroupCollection | OBJECT_OR_COLUMN | ||
| DialogGroupInProductLimited | OBJECT_OR_COLUMN | ||
| DialogTable | OBJECT_OR_COLUMN | ||
| dialoguser | OBJECT_OR_COLUMN | ||
| dialoguseringroup | OBJECT_OR_COLUMN | ||
| QBM_PSessionContextSet | OBJECT_OR_COLUMN | ||
| QBM_PSessionErrorAdd | OBJECT_OR_COLUMN | ||
| QBM_YSingleGUID | TYPE | ||
| dbo | QBM_FCVElementToObjectKey1 | OBJECT_OR_COLUMN | |
| dbo | QBM_FCVElementToObjectKey2 | OBJECT_OR_COLUMN | |
| dbo | QBM_FCVGuidToTransfer | OBJECT_OR_COLUMN | |
| dbo | QBM_FGIModuleExists | OBJECT_OR_COLUMN | |
| dbo | QBM_FGISessionContext | OBJECT_OR_COLUMN | |
| dbo | QBM_FGISessionErrorRethrow | OBJECT_OR_COLUMN |
Source-derived context
Generated from exported SQL module definitions plus read-only sandbox sys.objects/sys.parameters/sys.sql_expression_dependencies metadata. This is factual source evidence, not a semantic guess.
provenance: SQL definition export provenance: sandbox DB metadata modified: 2026-04-14T23:20:24.740
uses session context values has TRY/CATCH error handling
Summary: calls QBM_PSessionContextSet, QBM_PSessionErrorAdd; writes INSERT into, INSERT dialoguser, INSERT dialoguseringroup, UPDATE dialoguser; reads/joins DialogGroup, QBM_FCVStringToList, DialogGroupInProductLimited, dialogGroupCollection, dialoguseringroup…; uses session context XUser, GenProcID
Declared parameters
| Parameter | Type | Direction |
|---|---|---|
@GroupGuidList | nvarchar | input |
@uid_DialogUser | varchar(38) | OUTPUT |
@UID_QBMProduct | varchar(38) | input |
DML targets
INSERT into INSERT dialoguser INSERT dialoguseringroup UPDATE dialoguserCalled routines
Read/join references
SQL dependency metadata
- dialogGroupCollection
- DialogGroupInProductLimited
- DialogTable
- dialoguser
- dialoguseringroup
- QBM_PSessionContextSet
- QBM_PSessionErrorAdd
- QBM_YSingleGUID
- dbo.QBM_FCVElementToObjectKey1
- dbo.QBM_FCVElementToObjectKey2
- dbo.QBM_FCVGuidToTransfer
- dbo.QBM_FGIModuleExists
- dbo.QBM_FGISessionContext
- dbo.QBM_FGISessionErrorRethrow
Config/session
Config: None extracted.
Session: XUser GenProcID
DBQueue/tasks
None extracted.Temp tables / referenced variables
Temp: #LDS #No
Variables: @GroupGuidList @uid_DialogUser @UID_QBMProduct @GenProcID @XUser @XDate @cmd @DebugSwitch @groups @anzahlGruppen @GenProcID_R @XUser_R @QBM_BaseRight @Groups @AnzahlGruppen @UID_DialogUser @Xdate @Rethrow