Třídová akce

Kód:

4

Tělo:

select 
  ID 
from 
  CRMCampaignBlackList 
where
  (Person_ID = :Person) and
  (Firm_ID is null) and 
  (
    (Lower(EmailAddress) = Lower(:Email)) or
    (EmailAddress = ' ') 
  ) and
  (Hidden = 'N') and
  ((:EMailChannel = 'X') or (:EMailChannel <> 'X' and EMail = :EMailChannel)) and
  ((:PostChannel = 'X') or (:PostChannel <> 'X' and Post = :PostChannel)) and
  ((:PersonalChannel = 'X') or (:PersonalChannel <> 'X' and Personal = :PersonalChannel)) and
  ((:PhoneChannel = 'X') or (:PhoneChannel <> 'X' and Phone = :PhoneChannel))

Generated by ABRA Software a.s. 27.10.2021 16:34:54