Objektová akce

Kód:

10

Tělo:

select CE.*, CUE.SupressExpression, CUE.UserExpression, CUE.UserCondition, CUE.UserCheckExpression, CUE.UserExplanation
from CalcExpressions CE
left join CalcUserExpressions CUE on CUE.Parent_ID = CE.id 
where 
  (CE.parent_id = :OBJID) and
  CE.ValidFrom$DATE in
    (select max(CE1.ValidFrom$DATE)
     from
       CalcExpressions CE1
     where
       CE1.FieldCode = CE.FieldCode and 
       CE1.Parent_ID = :OBJID and
       CE1.ValidFrom$DATE <= :UpToDate
    )
    

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