Back to OIM Explorer

dbo.QBM_TUDialogDashBoardDef

Database TriggerSQL_TRIGGERSandbox DB

Database Trigger on DialogDashBoardDef. Bulk DBQueue insert -> QBM-K-CommonPrepropDashboardDef / QBM_ZPrePropDashBoardDef at line 14; Bulk DBQueue insert -> QBM-K-CommonDashboardDef / QBM_ZDashBoardDefine at line 14; Bulk DBQueue insert -> QBM-K-CommonDashboardDef / QBM_ZDashBoardDefine at line 14; Bulk DBQueue insert -> QBM-K-CommonDashboardDef / QBM_ZDashBoardDefine at line 17

Source: sandbox-db sys.sql_modules

Source size: 2.797 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 -> QBM-K-CommonPrepropDashboardDef / QBM_ZPrePropDashBoardDef at line 14
  • Bulk DBQueue insert -> QBM-K-CommonDashboardDef / QBM_ZDashBoardDefine at line 14
  • Bulk DBQueue insert -> QBM-K-CommonDashboardDef / QBM_ZDashBoardDefine at line 14
  • Bulk DBQueue insert -> QBM-K-CommonDashboardDef / QBM_ZDashBoardDefine at line 17
  • Bulk DBQueue insert -> QBM-K-CommonDashboardDef / QBM_ZDashBoardDefine at line 17
  • Bulk DBQueue insert -> QBM-K-CommonDashboardDef / QBM_ZDashBoardDefine at line 20
  • References QBM_PDBQueueInsert_Bulk
  • Trigger parent table: DialogDashBoardDef

Typed Edges

  • queues DBQueue task QBM_ZPrePropDashBoardDef at line 14 Bulk DBQueue insert -> QBM-K-CommonPrepropDashboardDef / QBM_ZPrePropDashBoardDef at line 14
  • queues DBQueue task QBM_ZDashBoardDefine at line 14 Bulk DBQueue insert -> QBM-K-CommonDashboardDef / QBM_ZDashBoardDefine at line 14
  • queues DBQueue task QBM_ZDashBoardDefine at line 17 Bulk DBQueue insert -> QBM-K-CommonDashboardDef / QBM_ZDashBoardDefine at line 17
  • queues DBQueue task QBM_ZDashBoardDefine at line 20 Bulk DBQueue insert -> QBM-K-CommonDashboardDef / QBM_ZDashBoardDefine at line 20
  • trigger on table DialogDashBoardDef Trigger parent table: DialogDashBoardDef
  • references source dbo.QBM_FGISessionContext source text reference
  • references source dbo.QBM_PDBQueueInsert_Bulk source text reference
  • references source dbo.QBM_PPrePropCheckSyntax source text reference
  • references source dbo.QBM_PSessionErrorAdd source text reference
  • references source dbo.QBM_PSQLCheckExecutable source text reference

References

Referenced By

  • No direct source references extracted.

Complete Source

SQL132 lines
1CREATE trigger QBM_TUDialogDashBoardDef2  ON DialogDashBoardDef FOR3UPDATE NOT FOR Replication4AS5BEGIN6  DECLARE @SQLToCheck QBM_YParameterList7  DECLARE @ConditionsToCheck QBM_YParameterList8  BEGIN TRY9    IF EXISTS(10      SELECT TOP 1 111      FROM inserted)12    GOTO start13    IF EXISTS(14      SELECT TOP 1 115      FROM deleted)16    GOTO start17    RETURN start:18    DECLARE @GenProcID varchar(38)19    SELECT @GenProcID = dbo.QBM_FGISessionContext('')20    IF21    UPDATE(QueryDefinition100) OR22    UPDATE(QueryDefinition) OR23    UPDATE(AccessWhereClause)24    BEGIN25      INSERT INTO @SQLToCheck(Parameter1,26      ContentFull)27      SELECT28        c.XObjectKey,29        c.QueryDefinition10030      FROM inserted c31      WHERE32        c.QueryDefinition100 > ' '33      INSERT INTO @SQLToCheck(Parameter1,34      ContentFull)35      SELECT36        c.XObjectKey,37        c.QueryDefinition38      FROM inserted c39      WHERE40        c.QueryDefinition > ' '41      INSERT INTO @SQLToCheck(Parameter1,42      ContentFull)43      SELECT44        c.XObjectKey,45        'select top 1 1 as columnvalue from ' + 'DialogDashBoardContent' + '46		 where (47		 ' + c.AccessWhereClause + '48		 )'49      FROM inserted c50      WHERE51        c.AccessWhereClause > ' '52      EXEC QBM_PSQLCheckExecutable @SQLToCheck,53        @RaiseError = 154    END55    IF56    UPDATE(PreprocessorCondition)57    BEGIN58      INSERT INTO @ConditionsToCheck(ContentFull)59      SELECT i.PreProcessorCondition60      FROM inserted i61      EXEC QBM_PPrePropCheckSyntax @ConditionsToCheck62      DECLARE @DBQueueElements_01 QBM_YDBQueueRaw63      INSERT INTO @DBQueueElements_01(object,64      subobject,65      genprocid)66      SELECT67        x.uid,68        NULL,69        @GenProcID70      FROM(71      SELECT t.uid_DialogDashBoardDef AS uid72      FROM deleted d73      JOIN DialogDashBoardDef t74        ON d.uid_DialogDashBoardDef = t.UID_DialogDashBoardDef75      WHERE76        isnull(d.PreprocessorCondition, N '') <> isnull(t.PreprocessorCondition, N '')) AS x77      EXEC QBM_PDBQueueInsert_Bulk 'QBM-K-CommonPrepropDashboardDef',78        @DBQueueElements_0179    END80    IF81    UPDATE(IsDeactivatedByPreprocessor)82    BEGIN83      DECLARE @DBQueueElements_02 QBM_YDBQueueRaw84      INSERT INTO @DBQueueElements_02(object,85      subobject,86      genprocid)87      SELECT88        x.uid,89        NULL,90        @GenProcID91      FROM(92      SELECT t.uid_DialogDashBoardDef AS uid93      FROM deleted d94      JOIN DialogDashBoardDef t95        ON d.uid_DialogDashBoardDef = t.UID_DialogDashBoardDef96      WHERE97        isnull(d.IsDeactivatedByPreprocessor, 0) <> isnull(t.IsDeactivatedByPreprocessor, 0)) AS x98      EXEC QBM_PDBQueueInsert_Bulk 'QBM-K-CommonDashboardDef',99        @DBQueueElements_02100    END101    IF102    UPDATE(QueryDefinition) OR103    UPDATE(QueryDefinition100) OR104    UPDATE(isInactive) OR105    UPDATE(isManual)106    BEGIN107      DECLARE @DBQueueElements_03 QBM_YDBQueueRaw108      INSERT INTO @DBQueueElements_03(object,109      subobject,110      genprocid)111      SELECT112        x.uid,113        NULL,114        @GenProcID115      FROM(116      SELECT uid_DialogDashBoardDef AS UID117      FROM inserted118      UNION119      SELECT uid_DialogDashBoardDef AS UID120      FROM deleted) AS x121      EXEC QBM_PDBQueueInsert_Bulk 'QBM-K-CommonDashboardDef',122        @DBQueueElements_03123    END124  END TRY125  BEGIN CATCH126    EXEC QBM_PSessionErrorAdd DEFAULT127    RAISERROR('',128    18,129    1)130      WITH NOWAIT131  END CATCH132END
Open raw exported source
SQL ยท Raw22 lines
1 create   trigger QBM_TUDialogDashBoardDef on DialogDashBoardDef  for Update not for Replication as begin  declare @SQLToCheck QBM_YParameterList2 declare @ConditionsToCheck QBM_YParameterList BEGIN TRY if exists (select top 1 1 from inserted) goto start if exists (select top 1 1 from deleted) goto3 start return start: declare @GenProcID varchar(38) select @GenProcID = dbo.QBM_FGISessionContext('')  if update(QueryDefinition100) or update(QueryDefinition4) or update(AccessWhereClause) begin insert into @SQLToCheck(Parameter1, ContentFull) select c.XObjectKey, c.QueryDefinition100 from inserted c  where 5c.QueryDefinition100 > ' '  insert into @SQLToCheck(Parameter1, ContentFull) select c.XObjectKey, c.QueryDefinition from inserted c  where c.QueryDefinition6 > ' '  insert into @SQLToCheck(Parameter1, ContentFull) select c.XObjectKey, 'select top 1 1 as columnvalue from ' + 'DialogDashBoardContent' + '7		 where (8		 '9 + c.AccessWhereClause + '10		 )' from inserted c  where c.AccessWhereClause > ' ' exec QBM_PSQLCheckExecutable @SQLToCheck, @RaiseError = 1 end if update11(PreprocessorCondition) begin  insert into @ConditionsToCheck (ContentFull) select i.PreProcessorCondition from inserted i exec QBM_PPrePropCheckSyntax12 @ConditionsToCheck  declare @DBQueueElements_01 QBM_YDBQueueRaw insert into @DBQueueElements_01 (object, subobject, genprocid) select x.uid, null, @GenProcID13 from ( select t.uid_DialogDashBoardDef as uid from deleted d join DialogDashBoardDef t on d.uid_DialogDashBoardDef = t.UID_DialogDashBoardDef where isnull14(d.PreprocessorCondition, N'') <> isnull(t.PreprocessorCondition, N'') ) as x exec QBM_PDBQueueInsert_Bulk 'QBM-K-CommonPrepropDashboardDef', @DBQueueElements_0115 end if update(IsDeactivatedByPreprocessor) begin declare @DBQueueElements_02 QBM_YDBQueueRaw insert into @DBQueueElements_02 (object, subobject, genprocid16) select x.uid, null, @GenProcID from ( select t.uid_DialogDashBoardDef as uid from deleted d join DialogDashBoardDef t on d.uid_DialogDashBoardDef = t.UID_DialogDashBoardDef17 where isnull(d.IsDeactivatedByPreprocessor, 0) <> isnull(t.IsDeactivatedByPreprocessor, 0) ) as x exec QBM_PDBQueueInsert_Bulk 'QBM-K-CommonDashboardDef'18, @DBQueueElements_02 end if update(QueryDefinition) or update(QueryDefinition100) or update(isInactive) or update(isManual) begin declare @DBQueueElements_0319 QBM_YDBQueueRaw insert into @DBQueueElements_03 (object, subobject, genprocid) select x.uid, null, @GenProcID from (select uid_DialogDashBoardDef as UID20 from inserted union select uid_DialogDashBoardDef as UID from deleted ) as x exec QBM_PDBQueueInsert_Bulk 'QBM-K-CommonDashboardDef', @DBQueueElements_0321 end END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1) WITH NOWAIT END CATCH end 22