Třídová akce

Kód:

1

Tělo:

select MR.ID, MR.SecurityUser_ID, MR.EmailAddress, MR.EmailAccount_ID, MR.KeepMessage from
MsgRedirections MR
join Seldat SLD on SLD.Obj_ID = MR.SecurityUser_ID and SLD.Sel_ID = :Sel_ID
join SecurityUsers SU on SU.id = MR.SecurityUser_ID and SU.Locked = 'N'
where (ValidFromDate$DATE = 0 or ValidFromDate$DATE <= :Now)
and (ValidToDate$DATE = 0 or :Now < ValidToDate$DATE + 1)

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