Back to OIM Explorer

dbo.QBM_TIDialogDashBoardDef

Database TriggerSQL_TRIGGERSandbox DB

Database Trigger on DialogDashBoardDef. Bulk DBQueue insert -> QBM-K-CommonDashboardDef / QBM_ZDashBoardDefine at line 12; Bulk DBQueue insert -> QBM-K-CommonPrepropDashboardDef / QBM_ZPrePropDashBoardDef at line 12; References QBM_PDBQueueInsert_Bulk; Trigger parent table: DialogDashBoardDef

Source: sandbox-db sys.sql_modules

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

Typed Edges

  • queues DBQueue task QBM_ZDashBoardDefine at line 12 Bulk DBQueue insert -> QBM-K-CommonDashboardDef / QBM_ZDashBoardDefine at line 12
  • queues DBQueue task QBM_ZPrePropDashBoardDef at line 12 Bulk DBQueue insert -> QBM-K-CommonPrepropDashboardDef / QBM_ZPrePropDashBoardDef at line 12
  • 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

SQL72 lines
1CREATE trigger QBM_TIDialogDashBoardDef2  ON DialogDashBoardDef FOR3INSERT 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    RETURN start:14    DECLARE @GenProcID varchar(38)15    SELECT @GenProcID = dbo.QBM_FGISessionContext('')16    INSERT INTO @ConditionsToCheck(ContentFull)17    SELECT i.PreProcessorCondition18    FROM inserted i19    EXEC QBM_PPrePropCheckSyntax @ConditionsToCheck20    INSERT INTO @SQLToCheck(Parameter1,21    ContentFull)22    SELECT23      c.XObjectKey,24      c.QueryDefinition10025    FROM inserted c26    WHERE27      c.QueryDefinition100 > ' '28    INSERT INTO @SQLToCheck(Parameter1,29    ContentFull)30    SELECT31      c.XObjectKey,32      c.QueryDefinition33    FROM inserted c34    WHERE35      c.QueryDefinition > ' '36    INSERT INTO @SQLToCheck(Parameter1,37    ContentFull)38    SELECT39      c.XObjectKey,40      'select top 1 1 as columnvalue from ' + 'DialogDashBoardContent' + ' 41		where (42		' + c.AccessWhereClause + '43		)'44    FROM inserted c45    WHERE46      c.AccessWhereClause > ' '47    EXEC QBM_PSQLCheckExecutable @SQLToCheck,48      @RaiseError = 149    DECLARE @DBQueueElements_01 QBM_YDBQueueRaw50    INSERT INTO @DBQueueElements_01(object,51    subobject,52    genprocid)53    SELECT54      x.uid,55      NULL,56      @GenProcID57    FROM(58    SELECT uid_DialogDashBoardDef AS uid59    FROM inserted) AS x60    EXEC QBM_PDBQueueInsert_Bulk 'QBM-K-CommonDashboardDef',61      @DBQueueElements_0162    EXEC QBM_PDBQueueInsert_Bulk 'QBM-K-CommonPrepropDashboardDef',63      @DBQueueElements_0164  END TRY65  BEGIN CATCH66    EXEC QBM_PSessionErrorAdd DEFAULT67    RAISERROR('',68    18,69    1)70      WITH NOWAIT71  END CATCH72END
Open raw exported source
SQL ยท Raw14 lines
1  create   trigger QBM_TIDialogDashBoardDef on DialogDashBoardDef  for Insert 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 return start: declare @GenProcID varchar(383) select @GenProcID = dbo.QBM_FGISessionContext('')  insert into @ConditionsToCheck (ContentFull) select i.PreProcessorCondition from inserted i exec QBM_PPrePropCheckSyntax4 @ConditionsToCheck   insert into @SQLToCheck(Parameter1, ContentFull) select c.XObjectKey, c.QueryDefinition100 from inserted c  where c.QueryDefinition1005 > ' '  insert into @SQLToCheck(Parameter1, ContentFull) select c.XObjectKey, c.QueryDefinition from inserted c  where c.QueryDefinition > ' '  insert 6into @SQLToCheck(Parameter1, ContentFull) select c.XObjectKey, 'select top 1 1 as columnvalue from ' + 'DialogDashBoardContent' + ' 7		where (8		' + 9c.AccessWhereClause + '10		)' from inserted c  where c.AccessWhereClause > ' ' exec QBM_PSQLCheckExecutable @SQLToCheck, @RaiseError = 1 declare @DBQueueElements_0111 QBM_YDBQueueRaw insert into @DBQueueElements_01 (object, subobject, genprocid) select x.uid, null, @GenProcID from ( select uid_DialogDashBoardDef as 12uid from inserted ) as x exec QBM_PDBQueueInsert_Bulk 'QBM-K-CommonDashboardDef', @DBQueueElements_01 exec QBM_PDBQueueInsert_Bulk 'QBM-K-CommonPrepropDashboardDef'13, @DBQueueElements_01 END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1) WITH NOWAIT END CATCH end 14