dbo.QER_TDDynamicGroup

1create   trigger QER_TDDynamicGroup on DynamicGroup  for Delete not for Replication as begin  declare @StringPatternDynamic varchar(16) = dbo.QBM_FCVBinaryToString
2( CONVERT(varbinary, dbo.QBM_FGIBitPatternXOrigin('|Dynamic|',0)), 0) declare @StringPatternDynamicInv varchar(16) = dbo.QBM_FCVBinaryToString( CONVERT
3(varbinary, dbo.QBM_FGIBitPatternXOrigin('|Dynamic|',1)), 0) declare @ElementBuffer QBM_YCursorBuffer BEGIN TRY if exists (select top 1 1 from deleted)
4 goto start return start: declare @GenProcID varchar(38) select @GenProcID = dbo.QBM_FGISessionContext('')  insert into @ElementBuffer(ContentFull) select
5 concat( 'update ' , case d.UID_DialogTableObjectClass when 'QER-T-Hardware' then 'HardwareInBaseTree' when 'QER-T-WorkDesk' then 'WorkDeskInBaseTree' 
6when 'QER-T-Person' then 'PersonInBaseTree' else '' end , ' set XOrigin = XOrigin & ' , @StringPatternDynamicInv , ' where uid_org = ''' , rtrim(dbo.QBM_FCVObjectkeyToElement
7('Columnvalue1', d.ObjectKeyBaseTree)) , ''' ' ) from deleted d exec QBM_PExecuteSQLMulti @ElementBuffer  declare @DBQueueElements_01 QBM_YDBQueueRaw insert
8 into @DBQueueElements_01 (object, subobject, genprocid) select x.uid, null, @GenProcID from ( select UID_DynamicGroup as uid from deleted ) as x exec 
9QBM_PDBQueueInsert_Bulk 'QER-K-DynamicGroupMakeProc', @DBQueueElements_01   exec QBM_PDBQueueInsert_Single 'QER-K-DynamicGroupMakeTrigger', '', '', @GenProcID
10 END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1) WITH NOWAIT END CATCH ende: return end 
11