dbo.QER_TIQERUniversalSubstitute
Database TriggerSQL_TRIGGERSandbox DB
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-ShoppingRackPWOHelperPWO / QER_ZITShopHelperFill at line 6
- Bulk DBQueue insert -> QER-K-HelperHeadOrg / QER_ZHelperHeadOrg at line 6
- Bulk DBQueue insert -> QER-K-HelperHeadPerson / QER_ZHelperHeadPerson at line 6
- Bulk DBQueue insert -> QER-K-HelperHeadOrg / QER_ZHelperHeadOrg at line 8
- Bulk DBQueue insert -> QER-K-HelperHeadPerson / QER_ZHelperHeadPerson at line 8
- Bulk DBQueue insert -> QER-K-HelperHeadPerson / QER_ZHelperHeadPerson at line 10
- References QBM_PDBQueueInsert_Bulk
- Trigger parent table: QERUniversalSubstitute
Typed Edges
- queues DBQueue task QER_ZITShopHelperFill at line 6 Bulk DBQueue insert -> QER-K-ShoppingRackPWOHelperPWO / QER_ZITShopHelperFill at line 6
- queues DBQueue task QER_ZHelperHeadOrg at line 6 Bulk DBQueue insert -> QER-K-HelperHeadOrg / QER_ZHelperHeadOrg at line 6
- queues DBQueue task QER_ZHelperHeadPerson at line 6 Bulk DBQueue insert -> QER-K-HelperHeadPerson / QER_ZHelperHeadPerson at line 6
- queues DBQueue task QER_ZHelperHeadOrg at line 8 Bulk DBQueue insert -> QER-K-HelperHeadOrg / QER_ZHelperHeadOrg at line 8
- queues DBQueue task QER_ZHelperHeadPerson at line 8 Bulk DBQueue insert -> QER-K-HelperHeadPerson / QER_ZHelperHeadPerson at line 8
- queues DBQueue task QER_ZHelperHeadPerson at line 10 Bulk DBQueue insert -> QER-K-HelperHeadPerson / QER_ZHelperHeadPerson at line 10
- trigger on table QERUniversalSubstitute Trigger parent table: QERUniversalSubstitute
- 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
Referenced By
- No direct source references extracted.
Complete Source
1CREATE trigger QER_TIQERUniversalSubstitute2 ON QERUniversalSubstitute FOR3INSERT NOT FOR Replication4AS5BEGIN6 DECLARE @GenProcID varchar(38) = dbo.QBM_FGISessionContext('')7 BEGIN TRY8 IF EXISTS(9 SELECT TOP 1 110 FROM inserted)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 pwo.UID_PersonWantsOrg AS uid23 FROM inserted i24 JOIN PWOHelperPWO h25 ON i.UID_PersonSender = h.UID_PersonHead26 JOIN PersonWantsOrg pwo27 ON h.UID_PersonWantsOrg = pwo.UID_PersonWantsOrg AND h.LevelNumber = pwo.DecisionLevel28 WHERE29 i.IsCurrentlyActive = 1 AND(i.UseForITShop = 1 OR i.UseForITShopCompliance = 1) AND pwo.OrderState IN('OrderProduct',30 'OrderProlongate', 'OrderUnsubscribe')) AS x31 EXEC QBM_PDBQueueInsert_Bulk 'QER-K-ShoppingRackPWOHelperPWO',32 @DBQueueElements_0133 DECLARE @DBQueueElements_02 QBM_YDBQueueRaw34 INSERT INTO @DBQueueElements_02(object,35 subobject,36 genprocid)37 SELECT38 x.uid,39 NULL,40 @GenProcID41 FROM(42 SELECT i.UID_PersonReceiver AS uid43 FROM inserted i44 WHERE45 i.IsCurrentlyActive = 1 AND i.UseForHeadOrg = 1) AS x46 EXEC QBM_PDBQueueInsert_Bulk 'QER-K-HelperHeadOrg',47 @DBQueueElements_0248 DECLARE @DBQueueElements_03 QBM_YDBQueueRaw49 INSERT INTO @DBQueueElements_03(object,50 subobject,51 genprocid)52 SELECT53 x.uid,54 NULL,55 @GenProcID56 FROM(57 SELECT i.UID_PersonReceiver AS uid58 FROM inserted i59 WHERE60 i.IsCurrentlyActive = 1 AND i.UseForHeadPerson = 1) AS x61 EXEC QBM_PDBQueueInsert_Bulk 'QER-K-HelperHeadPerson',62 @DBQueueElements_0363 END TRY64 BEGIN CATCH65 EXEC QBM_PSessionErrorAdd DEFAULT66 RAISERROR('',67 18,68 1)69 WITH NOWAIT70 END CATCH71 ende:72 RETURN73ENDOpen raw exported source
1 create trigger QER_TIQERUniversalSubstitute on QERUniversalSubstitute for Insert not for Replication as begin declare @GenProcID varchar(382) = dbo.QBM_FGISessionContext('') BEGIN TRY if exists (select top 1 1 from inserted) goto start return start: declare @DBQueueElements_01 QBM_YDBQueueRaw3 insert into @DBQueueElements_01(object, subobject, genprocid) select x.uid, null, @GenProcID from( select pwo.UID_PersonWantsOrg as uid from inserted4 i join PWOHelperPWO h on i.UID_PersonSender = h.UID_PersonHead join PersonWantsOrg pwo on h.UID_PersonWantsOrg = pwo.UID_PersonWantsOrg and h.LevelNumber5 = pwo.DecisionLevel where i.IsCurrentlyActive = 1 and (i.UseForITShop = 1 or i.UseForITShopCompliance = 1) and pwo.OrderState in ('OrderProduct', 'OrderProlongate'6, 'OrderUnsubscribe') ) as x exec QBM_PDBQueueInsert_Bulk 'QER-K-ShoppingRackPWOHelperPWO', @DBQueueElements_01 declare @DBQueueElements_02 QBM_YDBQueueRaw7 insert into @DBQueueElements_02(object, subobject, genprocid) select x.uid, null, @GenProcID from( select i.UID_PersonReceiver as uid from inserted i8 where i.IsCurrentlyActive = 1 and i.UseForHeadOrg = 1 ) as x exec QBM_PDBQueueInsert_Bulk 'QER-K-HelperHeadOrg', @DBQueueElements_02 declare @DBQueueElements_039 QBM_YDBQueueRaw insert into @DBQueueElements_03(object, subobject, genprocid) select x.uid, null, @GenProcID from( select i.UID_PersonReceiver as uid10 from inserted i where i.IsCurrentlyActive = 1 and i.UseForHeadPerson = 1 ) as x exec QBM_PDBQueueInsert_Bulk 'QER-K-HelperHeadPerson', @DBQueueElements_0311 END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1) WITH NOWAIT END CATCH ende: return end 12