Třídová akce

Kód:

2

Tělo:

SELECT
  A.{PersonFieldName} Person_ID,
  CASE
    WHEN (A.ValidTo$DATE = 0) OR (A.ValidTo$DATE IS NULL)  THEN 9999999999
    WHEN (A.ValidTo$DATE <> 0) AND (A.ValidTo$DATE IS NOT NULL) THEN A.ValidTo$DATE
   END LatestDate,
  A.ID LatestID
FROM
  Contracts A
WHERE
  A.{PersonFieldName} {Person_IDs} AND
  ((A.ValidTo$DATE >= :DateFrom) OR (A.ValidTo$DATE = 0)) AND
  A.DocQueue_ID {DocQueue_IDs} AND
  A.AutoDataProcessingPermit = 'A' 

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