Třídová akce

Kód:
14
Tělo:
select A.{PersonFieldName} Person_ID, 
    A.NextContact$DATE LatestDate, 
    A.ID LatestID 
 FROM CRMActivities A
   WHERE
     A.{PersonFieldName} {Person_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