Back to OIM Explorer

dbo.QER_TDDynamicGroup

Database TriggerSQL_TRIGGERSandbox DB

Database Trigger on DynamicGroup. Bulk DBQueue insert -> QER-K-DynamicGroupMakeProc / QER_ZDynamicGroupMakeProc at line 9; Single DBQueue insert -> QER-K-DynamicGroupMakeTrigger / QER_ZDynamicGroupMakeTrigger at line 9; References QBM_PDBQueueInsert_Single; References QBM_PDBQueueInsert_Bulk

Source: sandbox-db sys.sql_modules

Source size: 1.545 characters

Interpretation

  • Database trigger. Treat parent table and enqueue/object-layer calls as the main relation points.
  • DBQueue relation detected. Follow the task procedure and referenced-by list for async processing.

Relations

  • Bulk DBQueue insert -> QER-K-DynamicGroupMakeProc / QER_ZDynamicGroupMakeProc at line 9
  • Single DBQueue insert -> QER-K-DynamicGroupMakeTrigger / QER_ZDynamicGroupMakeTrigger at line 9
  • References QBM_PDBQueueInsert_Single
  • References QBM_PDBQueueInsert_Bulk
  • Trigger parent table: DynamicGroup

Typed Edges

  • queues DBQueue task QER_ZDynamicGroupMakeProc at line 9 Bulk DBQueue insert -> QER-K-DynamicGroupMakeProc / QER_ZDynamicGroupMakeProc at line 9
  • queues DBQueue task QER_ZDynamicGroupMakeTrigger at line 9 Single DBQueue insert -> QER-K-DynamicGroupMakeTrigger / QER_ZDynamicGroupMakeTrigger at line 9
  • trigger on table DynamicGroup Trigger parent table: DynamicGroup
  • references source dbo.QBM_FCVBinaryToString source text reference
  • references source dbo.QBM_FCVObjectkeyToElement source text reference
  • references source dbo.QBM_FGIBitPatternXOrigin source text reference
  • references source dbo.QBM_FGISessionContext source text reference
  • references source dbo.QBM_PDBQueueInsert_Bulk source text reference
  • references source dbo.QBM_PDBQueueInsert_Single source text reference
  • references source dbo.QBM_PExecuteSQLMulti source text reference
  • references source dbo.QBM_PSessionErrorAdd source text reference

References

Referenced By

Complete Source

SQL67 lines
1CREATE trigger QER_TDDynamicGroup2  ON DynamicGroup FOR3DELETE NOT FOR Replication4AS5BEGIN6  DECLARE @StringPatternDynamic varchar(16) = dbo.QBM_FCVBinaryToString(CONVERT(varbinary, dbo.QBM_FGIBitPatternXOrigin('|Dynamic|',7  0)),8  0)9  DECLARE @StringPatternDynamicInv varchar(16) = dbo.QBM_FCVBinaryToString(CONVERT(varbinary, dbo.QBM_FGIBitPatternXOrigin('|Dynamic|',10  1)),11  0)12  DECLARE @ElementBuffer QBM_YCursorBuffer13  BEGIN TRY14    IF EXISTS(15      SELECT TOP 1 116      FROM deleted)17    GOTO start18    RETURN start:19    DECLARE @GenProcID varchar(38)20    SELECT @GenProcID = dbo.QBM_FGISessionContext('')21    INSERT INTO @ElementBuffer(ContentFull)22    SELECT23      CONCAT('update ',24    CASE d.UID_DialogTableObjectClass25      WHEN 'QER-T-Hardware' THEN26    'HardwareInBaseTree'27      WHEN 'QER-T-WorkDesk' THEN28    'WorkDeskInBaseTree'29      WHEN 'QER-T-Person' THEN30    'PersonInBaseTree'31    ELSE ''32    END,33    ' set XOrigin = XOrigin & ',34    @StringPatternDynamicInv,35    ' where uid_org = ''',36    rtrim(dbo.QBM_FCVObjectkeyToElement('Columnvalue1', d.ObjectKeyBaseTree)),37    ''' ')38    FROM deleted d39    EXEC QBM_PExecuteSQLMulti @ElementBuffer40    DECLARE @DBQueueElements_01 QBM_YDBQueueRaw41    INSERT INTO @DBQueueElements_01(object,42    subobject,43    genprocid)44    SELECT45      x.uid,46      NULL,47      @GenProcID48    FROM(49    SELECT UID_DynamicGroup AS uid50    FROM deleted) AS x51    EXEC QBM_PDBQueueInsert_Bulk 'QER-K-DynamicGroupMakeProc',52      @DBQueueElements_0153    EXEC QBM_PDBQueueInsert_Single 'QER-K-DynamicGroupMakeTrigger',54    '',55    '',56      @GenProcID57  END TRY58  BEGIN CATCH59    EXEC QBM_PSessionErrorAdd DEFAULT60    RAISERROR('',61    18,62    1)63      WITH NOWAIT64  END CATCH65  ende:66  RETURN67END
Open raw exported source
SQL ยท Raw11 lines
1create   trigger QER_TDDynamicGroup on DynamicGroup  for Delete not for Replication as begin  declare @StringPatternDynamic varchar(16) = dbo.QBM_FCVBinaryToString2( CONVERT(varbinary, dbo.QBM_FGIBitPatternXOrigin('|Dynamic|',0)), 0) declare @StringPatternDynamicInv varchar(16) = dbo.QBM_FCVBinaryToString( CONVERT3(varbinary, dbo.QBM_FGIBitPatternXOrigin('|Dynamic|',1)), 0) declare @ElementBuffer QBM_YCursorBuffer BEGIN TRY if exists (select top 1 1 from deleted)4 goto start return start: declare @GenProcID varchar(38) select @GenProcID = dbo.QBM_FGISessionContext('')  insert into @ElementBuffer(ContentFull) select5 concat( 'update ' , case d.UID_DialogTableObjectClass when 'QER-T-Hardware' then 'HardwareInBaseTree' when 'QER-T-WorkDesk' then 'WorkDeskInBaseTree' 6when 'QER-T-Person' then 'PersonInBaseTree' else '' end , ' set XOrigin = XOrigin & ' , @StringPatternDynamicInv , ' where uid_org = ''' , rtrim(dbo.QBM_FCVObjectkeyToElement7('Columnvalue1', d.ObjectKeyBaseTree)) , ''' ' ) from deleted d exec QBM_PExecuteSQLMulti @ElementBuffer  declare @DBQueueElements_01 QBM_YDBQueueRaw insert8 into @DBQueueElements_01 (object, subobject, genprocid) select x.uid, null, @GenProcID from ( select UID_DynamicGroup as uid from deleted ) as x exec 9QBM_PDBQueueInsert_Bulk 'QER-K-DynamicGroupMakeProc', @DBQueueElements_01   exec QBM_PDBQueueInsert_Single 'QER-K-DynamicGroupMakeTrigger', '', '', @GenProcID10 END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1) WITH NOWAIT END CATCH ende: return end 11