Objektová akce

Kód:

4

Tělo:

SELECT A.ValidFrom$DATE,A.System,A.StringFieldValue,
  (select 
    MinStringFieldValue
  from 
    WageConstantIntervals  
  where 
    (Parent_ID = A.Parent_ID) and
    ValidFrom$DATE in 
    (
      select  max(ValidFrom$DATE) from WageConstantIntervals  
      where 
        (Parent_ID = A.Parent_ID) and
        (ValidFrom$DATE <= A.ValidFrom$DATE)
    ))  as MinStringFieldValue,
  (select 
    MaxStringFieldValue
  from 
    WageConstantIntervals  
  where 
    (Parent_ID = A.Parent_ID) and
    ValidFrom$DATE in 
    (
      select  max(ValidFrom$DATE) from WageConstantIntervals  
      where 
        (Parent_ID = A.Parent_ID) and
        (ValidFrom$DATE <= A.ValidFrom$DATE)
    ))  as MaxStringFieldValue,    
  WC.EditMethod,WC.Enumeration
  FROM
    WageConstantValues A,
    WageConstants WC
  WHERE A.Parent_ID =:OBJID and
    A.Parent_ID = WC.ID and    
    A.System in
    (
      select max(System)
      from WageConstantValues
        where 
          (Parent_ID = A.Parent_ID) and
          (ValidFrom$DATE = A.ValidFrom$DATE)
    ) /* Pokud jsou k danému datu dvě hodnoty, bere se uživatelská hodnota */    

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