Třídová akce

Kód:

3

Tělo:

select
  (b.Code || '-' || CAST(a.OrdNumber AS VARCHAR(10)) || '/' ||  c.Code) as DisplayName,
  a.Subject as Description,
  a.RealEnd$Date as Date$Date,
  a.ID as ID,
  a.Firm_ID as FirmID
from CRMActivities a
JOIN CRMActivityQueues b ON b.ID=a.ActQueue_ID
JOIN Periods c ON c.ID = a.Period_ID
where 
  (
    (a.Firm_ID IN (SELECT ID FROM Firms WHERE ID=:ID or Firm_ID=:ID))
    or
    (a.ID in (Select Parent_ID from CRMActivityContacts where Firm_ID=:ID))
  )
  and (((a.SheduledStart$DATE >= :DateFrom) and (a.SheduledEnd$DATE < :DateTo)) or
   ((a.RealStart$DATE >= :DateFrom) and (a.RealEnd$DATE < (:DateTo + 1))))

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