Třídová akce

Kód:

6

Tělo:

Select
  (DQ.Code || '-' || CAST(A.OrdNumber AS VARCHAR(10)) || '/' ||  P.Code) as DisplayName,
  CT.Name as Description,
  A.DocDate$Date as Date$Date,
  a.ID as ID,
  '0000000000' as FirmID
from CRMCampaignes A
  left join DocQueues DQ on (A.DocQueue_ID = DQ.ID)
  left join Periods P on (A.Period_ID = P.ID)
  left join CRMCampaignTypes CT on (A.CampaignType_ID = CT.ID)
  where (A.BusTransaction_ID = :ID) and
  (a.DocDate$DATE >= :DateFrom) and (a.DocDate$DATE < :DateTo + 1) and
  (Select count(CCA.ID) from CRMCampaignAudiences CCA where CCA.Parent_ID = A.ID) = 0
union all
Select
  (DQ.Code || '-' || CAST(A.OrdNumber AS VARCHAR(10)) || '/' ||  P.Code) as DisplayName,
  CT.Name as Description,
  A.DocDate$Date as Date$Date,
  a.ID as ID,
  CCA.FirmID as FirmID
from CRMCampaignes A
  left join DocQueues DQ on (A.DocQueue_ID = DQ.ID)
  left join Periods P on (A.Period_ID = P.ID)
  left join CRMCampaignTypes CT on (A.CampaignType_ID = CT.ID)
  join (Select CA.Parent_ID as ID, CA.Firm_ID as FirmID from CRMCampaignAudiences CA where not CA.Firm_ID is null group by CA.Parent_ID, CA.Firm_ID) CCA on (A.ID = CCA.ID)
  where (A.BusTransaction_ID = :ID) and
  (a.DocDate$DATE >= :DateFrom) and (a.DocDate$DATE < :DateTo + 1) and
  (Select count(CCA.ID) from CRMCampaignAudiences CCA where CCA.Parent_ID = A.ID)<> 0

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