Currency Conversion

def qapi = api.queryApi()

def t1 = qapi.tables().productExtensionRows("Costs")
def t2 = qapi.tables().companyParameterRows("Currencies")
def today = new Date()
def currency = "USD"

return qapi.source(t1, [t1.sku(), t1.Cost, t1.Currency])
        .leftOuterJoin(t2,
        { cols -> [t2.ExchangeRate, cols.Cost.multiply(t2.ExchangeRate).as("CostUSD")] },
        { cols -> qapi.exprs().and(t2.CcyFrom.equal(cols.Currency),
        t2.CcyTo.equal(currency),
        t2.CcyValidFrom.lessOrEqual(today),
        t2.CcyValidTo.greaterOrEqual(today),) })
        .take(10)
        .stream { it.collect { it } }