Třídová akce

Kód:

11

Tělo:

SELECT
  EM.{PersonFieldName} Person_ID,
  MAX(
   CASE
     WHEN (WR.DateOfEnd$DATE = 0) OR (WR.DateOfEnd$DATE IS NULL)
       THEN 9999999999
     ELSE
       WR.DateOfEnd$DATE
   END
  ) DateOfEnd,
  MAX(EM.ID) LatestID
FROM
  WORKINGRELATIONS WR
  JOIN EMPLOYEES EM ON EM.ID = WR.EMPLOYEE_ID
WHERE
  ((WR.DateOfEnd$DATE = 0) OR (WR.DateOfEnd$DATE IS NULL) OR (WR.DateOfEnd$DATE >= :DateFrom)) AND
  EM.{PersonFieldName} {Person_IDs}
GROUP BY
  EM.{PersonFieldName}

/* Vybere zamestnance, kteri maji pracovni pomer a nezadane datum ukonceni nebo >= DateFrom */
/* Na Hidden se nebere ohled */
/* Zamestnanci bez prac. pomeru se neberou v uvahu */

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