Objektová akce

Kód:

11

Tělo:

select CF.*, CUF.SupressExpression, CUF.UserCondition, CUF.UserCorrection
from CalcFields CF 
left join CalcUserFields CUF on CUF.Parent_ID = CF.id
where 
  (CF.CalcChart_ID = :OBJID) and
  CF.ValidFrom$DATE in
    (select max(CF1.ValidFrom$DATE)
     from
       CalcFields CF1
     where
       CF1.CalcFieldCode = CF.CalcFieldCode and 
       CF1.FieldCode = CF.FieldCode and   
       CF1.CalcChart_ID = :OBJID and
       CF1.ValidFrom$DATE <= :UpToDate
    )

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