Objektová akce

Kód:

5

Tělo:

select 
  MTR.Redirected, MTR.Deleted, MTR.HaveRead, MTR.ReadAtDate$DATE, SU.ShortName as User1, SU.Name as User2  
from 
  MsgToRead MTR 
  join SecurityUsers SU on SU.ID = MTR.TargetUser_ID 
where MTR.MsgSent_ID = :OBJID

union all

select
  'N', 'N', 'N', 0, EA.AccountName as User1, cast(MR.Email as varchar(200)) as User2  
from MsgRecipients MR
join EmailAccounts EA on EA.ID = MR.EmailAccount_ID
where MR.Parent_ID = :OBJID
and MR.RecipientType = 4

Generated by ABRA Software a.s. 27.10.2021 16:35:16