dbo.QER_TDQERUniversalSubstitute
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_TDQERUniversalSubstitute2 ON QERUniversalSubstitute 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 pwo.UID_PersonWantsOrg AS uid23 FROM deleted d24 JOIN PWOHelperPWO h25 ON d.UID_PersonReceiver = h.UID_PersonHead26 JOIN PersonWantsOrg pwo27 ON h.UID_PersonWantsOrg = pwo.UID_PersonWantsOrg AND h.LevelNumber = pwo.DecisionLevel28 WHERE29 d.IsCurrentlyActive = 1 AND(d.UseForITShop = 1 OR d.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 d.UID_PersonReceiver AS uid43 FROM deleted d44 WHERE45 d.IsCurrentlyActive = 1 AND d.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 d.UID_PersonReceiver AS uid58 FROM deleted d59 WHERE60 d.IsCurrentlyActive = 1 AND d.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
1create trigger QER_TDQERUniversalSubstitute on QERUniversalSubstitute for delete not for Replication as begin declare @GenProcID varchar(38) 2= dbo.QBM_FGISessionContext('') BEGIN TRY if exists (select top 1 1 from deleted) goto start return start: declare @DBQueueElements_01 QBM_YDBQueueRaw 3insert into @DBQueueElements_01(object, subobject, genprocid) select x.uid, null, @GenProcID from( select pwo.UID_PersonWantsOrg as uid from deleted d4 join PWOHelperPWO h on d.UID_PersonReceiver = h.UID_PersonHead join PersonWantsOrg pwo on h.UID_PersonWantsOrg = pwo.UID_PersonWantsOrg and h.LevelNumber5 = pwo.DecisionLevel where d.IsCurrentlyActive = 1 and (d.UseForITShop = 1 or d.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 d.UID_PersonReceiver as uid from deleted d 8where d.IsCurrentlyActive = 1 and d.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 d.UID_PersonReceiver as uid10 from deleted d where d.IsCurrentlyActive = 1 and d.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