dbo.POL_TUATTPersonInBaseTree

1create   trigger POL_TUATTPersonInBaseTree on PersonInBaseTree  for Update not for Replication as begin   declare @XUser nvarchar(64) = object_name
2(@@procid) declare @Xdate datetime = getutcdate() BEGIN TRY if exists (select top 1 1 from deleted) goto start if exists (select top 1 1 from inserted)
3 goto start return start: declare @GenProcID varchar(38) select @GenProcID = dbo.QBM_FGISessionContext('') if update(XOrigin) begin if exists (select top
4 1 1 from deleted d join PersonInBaseTree pio on d.XObjectKey = pio.XObjectKey join BaseTree b on pio.UID_Org = b.UID_Org and b.UID_OrgRoot = 'QER-V-AERole'
5 where d.XOrigin > 0 and pio.XOrigin = 0 ) begin declare @DBQueueElements_01 QBM_YDBQueueRaw insert into @DBQueueElements_01 (object, subobject, genprocid
6) select x.uid, null, @GenProcID from (  select ac.UID_attestationcase as uid from deleted d join PersonInBaseTree pio on d.XObjectKey = pio.XObjectKey
7 join QERPolicy qp on d.UID_Org = qp.UID_AERoleAttestator join attestationcase ac on ac.ObjectkeyBase = qp.XObjectKey join AttestationHelper ah on ac.uid_attestationCase
8 = ah.uid_attestationcase and ah.UID_PWODecisionRule in ('POL-PWODecisionRule-AY') where d.XOrigin > 0 and pio.XOrigin = 0 union  select ac.UID_attestationcase
9 as uid from deleted d join PersonInBaseTree pio on d.XObjectKey = pio.XObjectKey join QERPolicy qp on d.UID_Org = qp.UID_AERoleAttestator join QERPolicyHasObject
10 pho on qp.UID_QERPolicy = pho.UID_QERPolicy join attestationcase ac on ac.ObjectkeyBase = pho.XObjectKey join AttestationHelper ah on ac.uid_attestationCase
11 = ah.uid_attestationcase and ah.UID_PWODecisionRule in ('POL-PWODecisionRule-AY') where d.XOrigin > 0 and pio.XOrigin = 0 ) as x exec QBM_PDBQueueInsert_Bulk
12 'ATT-K-AttestationHelper', @DBQueueElements_01 end end END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1) WITH NOWAIT END CATCH
13 ende: return end 
14