persistent class %BI.CurrencyRate
extends %Persistent
property CurrRate
as %String(TRUNCATE=1);
property EffectDate
as %String(TRUNCATE=1);
property FromCurr
as %String(TRUNCATE=1);
property ToCurr
as %String(TRUNCATE=1);
query All()
SQL Query
:
SELECT %ID,CurrRate,EffectDate,FromCurr,ToCurr FROM CurrencyRate
ORDER BY EffectDate DESC
index (currIndex on FromCurr,ToCurr,EffectDate) [IdKey,Unique];