Back to OIM Explorer

dbo.QER_TDBaseTreeExcludesBaseTree

Database TriggerSQL_TRIGGERSandbox DB

Database Trigger on BaseTreeExcludesBasetree. Bulk DBQueue insert -> QER-K-DynamicGroupTest / QER_ZDynamicGroupTest at line 5; References QBM_PDBQueueInsert_Bulk; Trigger parent table: BaseTreeExcludesBasetree

Source: sandbox-db sys.sql_modules

Source size: 918 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-DynamicGroupTest / QER_ZDynamicGroupTest at line 5
  • References QBM_PDBQueueInsert_Bulk
  • Trigger parent table: BaseTreeExcludesBasetree

Typed Edges

  • queues DBQueue task QER_ZDynamicGroupTest at line 5 Bulk DBQueue insert -> QER-K-DynamicGroupTest / QER_ZDynamicGroupTest at line 5
  • trigger on table BaseTreeExcludesBasetree Trigger parent table: BaseTreeExcludesBasetree
  • references source dbo.QBM_FGISessionContext source text reference
  • references source dbo.QBM_PDBQueueInsert_Bulk source text reference
  • references source dbo.QBM_PSessionErrorAdd source text reference
  • references source dbo.QER_TDBaseTree source text reference

References

Referenced By

  • No direct source references extracted.

Complete Source

SQL47 lines
1CREATE trigger QER_TDBaseTreeExcludesBaseTree2  ON BaseTreeExcludesBaseTree FOR3DELETE NOT FOR Replication4AS5BEGIN6  DECLARE @GenProcID varchar(38) = dbo.QBM_FGISessionContext('')7  BEGIN TRY8    IF EXISTS(9      SELECT TOP 1 110      FROM deleted)11    GOTO start12    RETURN start:13    DECLARE @DBQueueElements_01 QBM_YDBQueueRaw14    INSERT INTO @DBQueueElements_01(object,15    subobject,16    genprocid)17    SELECT18      x.uid,19      NULL,20      @GenProcID21    FROM(22    SELECT g.UID_DynamicGroup AS uid23    FROM deleted d24    JOIN BaseTree b25      ON d.UID_Org = b.UID_Org26    JOIN DynamicGroup g27      ON b.XObjectKey = g.ObjectKeyBaseTree28    UNION29    SELECT g.UID_DynamicGroup AS uid30    FROM deleted d31    JOIN BaseTree b32      ON d.UID_OrgExcluded = b.UID_Org33    JOIN DynamicGroup g34      ON b.XObjectKey = g.ObjectKeyBaseTree) AS x35    EXEC QBM_PDBQueueInsert_Bulk 'QER-K-DynamicGroupTest',36      @DBQueueElements_0137  END TRY38  BEGIN CATCH39    EXEC QBM_PSessionErrorAdd DEFAULT40    RAISERROR('',41    18,42    1)43      WITH NOWAIT44  END CATCH45  ende:46  RETURN47END
Open raw exported source
SQL ยท Raw7 lines
1create   trigger QER_TDBaseTreeExcludesBaseTree on BaseTreeExcludesBaseTree  for delete not for Replication as begin declare @GenProcID varchar(382) = dbo.QBM_FGISessionContext('') BEGIN TRY if exists (select top 1 1 from deleted) goto start return start:  declare @DBQueueElements_01 QBM_YDBQueueRaw3 insert into @DBQueueElements_01 (object, subobject, genprocid) select x.uid, null, @GenProcID from ( select g.UID_DynamicGroup as uid from deleted d join4 BaseTree b on d.UID_Org = b.UID_Org join DynamicGroup g on b.XObjectKey = g.ObjectKeyBaseTree union select g.UID_DynamicGroup as uid from deleted d join5 BaseTree b on d.UID_OrgExcluded = b.UID_Org join DynamicGroup g on b.XObjectKey = g.ObjectKeyBaseTree ) as x exec QBM_PDBQueueInsert_Bulk 'QER-K-DynamicGroupTest'6, @DBQueueElements_01 END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1) WITH NOWAIT END CATCH ende: return end 7