Třídová akce

Kód:

3

Tělo:

SELECT 
  S.ID, 
  S.ScheduledDateTime$DATE, 
  S.RepetitionPeriodKind,
  (S.Code || ' ' || S.Name) AS DISPLAYNAME,
  'A',
  S.IsActive,
  S.IsActiveForTestConnection
FROM 
  AutoServerScheduler S
  LEFT JOIN AutoServerQueue Q ON S.ID = Q.SchedulerItem_ID 
WHERE 
  -- Takove, ktere maji naplanovany cas pri startu automat.serveru
  (S.RepetitionPeriodKind = 6) AND
  -- A takove, ktere automatiacni server jeste nezpracovava
  (Q.SchedulerItem_ID IS NULL) AND
  -- A takove pro aktualni hnizdo
  (S.Site = :SITE)
ORDER BY 
  S.ScheduledDateTime$DATE, S.ID

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