Třídová akce

Kód:

13

Tělo:

select COALESCE(F.Firm_ID, F.ID) Firm_ID, 
     A.NextContact$DATE LatestDate, 
     A.ID LatestID 
 FROM CRMActivities A
 JOIN Firms F ON F.ID = A.Firm_ID
 WHERE
   A.{FirmFieldName} {Firm_IDs} AND
  A.NextContact$DATE >= :DateFrom AND
  A.NextContact$DATE > 0 AND
  A.Status < 2 AND
  A.ActQueue_ID {ActQueue_IDs}

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