dbo.QER_TUDialogGroup

1create   trigger QER_TUDialogGroup on DialogGroup  for Update not for Replication as begin  BEGIN TRY if exists (select top 1 1 from inserted) goto
2 start if exists (select top 1 1 from deleted) goto start return start: declare @GenProcID varchar(38) select @GenProcID = dbo.QBM_FGISessionContext(''
3) if update(IsRoleBasedOnly) begin  if exists (select top 1 1 from inserted i join BaseTree b on i.UID_DialogGroup = b.UID_DialogGroup where i.IsRoleBasedOnly
4 = 0 ) begin raiserror( '#LDS#Cannot change DialogGroup.IsRoleBasedOnly because it''s assigned to BaseTree.|', 18, 2) with nowait end         if exists
5 (select top 1 1 from deleted d join DialogGroup i on d.UID_DialogGroup = i.UID_DialogGroup where d.IsRoleBasedOnly = 1 and i.IsRoleBasedOnly = 0 ) begin
6 raiserror( '#LDS#Cannot change DialogGroup.IsRoleBasedOnly from true to false. Create a new group instead.|', 18, 2) with nowait end   declare @DBQueueElements_01
7 QBM_YDBQueueRaw insert into @DBQueueElements_01 (object, subobject, genprocid) select x.uid, null, @GenProcID from ( select distinct u.UID_DialogUser 
8as uid from deleted d join DialogGroup i on d.UID_DialogGroup = i.UID_DialogGroup join DialogUserInGroup uig on uig.UID_DialogGroup = i.UID_DialogGroup
9 join DialogUser u on uig.UID_DialogUser = u.UID_DialogUser where d.IsRoleBasedOnly = 0 and i.IsRoleBasedOnly = 1 and u.IsAdmin = 1 ) as x exec QBM_PDBQueueInsert_Bulk
10 'QBM-K-DialogUserInGroup', @DBQueueElements_01 end  END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1) WITH NOWAIT END CATCH 
11end 
12