Třídová akce

Popis:

Dodá všechny aktivity za zadanou roli v časovém rozmezí od-do

Kód:

11

Tělo:

SELECT 
  a.ID,
  (b.Code || '-' || CAST(a.OrdNumber AS VARCHAR(10)) || '/' ||  c.Code) as DisplayName,
  a.SheduledStart$Date, a.SheduledEnd$Date,
  a.Subject, f.Name
FROM
  CRMActivities a
  LEFT JOIN CRMActivityQueues b ON b.ID=a.ActQueue_ID
  LEFT JOIN Periods c ON c.ID = a.Period_ID
  LEFT JOIN Firms f ON f.ID = a.Firm_ID
WHERE
  (a.SolverRole_ID = :Role_ID) and
  ((a.SheduledStart$Date >= :DateFrom) or  (a.SheduledEnd$Date >= :DateFrom)) and
  ((a.SheduledStart$Date <= :DateTo) or  (a.SheduledEnd$Date <= :DateFrom))      
  

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