Hi All,
in my application I have a report as chart, which shows the fx development for 3 currencies.
For the data band I use the following native SQl query:
SELECT
GOVEIT_EXCHANGE_RATE.VALID_FROM AS fxdate,
GOVEIT_CURRENCY.CODE AS base,
GOVEIT_EXCHANGE_RATE.RATE AS “rateEUR”,
GOVEIT_EXCHANGE_RATE1.RATE * GOVEIT_EXCHANGE_RATE.RATE AS “rateUSD”,
GOVEIT_EXCHANGE_RATE2.RATE * GOVEIT_EXCHANGE_RATE1.RATE * GOVEIT_EXCHANGE_RATE.RATE AS “rateGBP”
FROM
GOVEIT_EXCHANGE_RATE INNER JOIN
GOVEIT_CURRENCY ON GOVEIT_EXCHANGE_RATE.SOURCE_ID = GOVEIT_CURRENCY.ID INNER JOIN
GOVEIT_EXCHANGE_RATE_TYPE ON GOVEIT_EXCHANGE_RATE.EXCHANGE_RATE_TYPE_ID = GOVEIT_EXCHANGE_RATE_TYPE.ID INNER JOIN
GOVEIT_EXCHANGE_RATE GOVEIT_EXCHANGE_RATE1 ON GOVEIT_EXCHANGE_RATE1.EXCHANGE_RATE_TYPE_ID =
GOVEIT_EXCHANGE_RATE_TYPE.ID
AND GOVEIT_EXCHANGE_RATE1.SOURCE_ID = GOVEIT_EXCHANGE_RATE.DESTINATION_ID INNER JOIN
GOVEIT_CURRENCY GOVEIT_CURRENCY2 ON GOVEIT_EXCHANGE_RATE.DESTINATION_ID = GOVEIT_CURRENCY2.ID INNER JOIN
GOVEIT_CURRENCY GOVEIT_CURRENCY1 ON GOVEIT_EXCHANGE_RATE1.DESTINATION_ID = GOVEIT_CURRENCY1.ID INNER JOIN
GOVEIT_EXCHANGE_RATE GOVEIT_EXCHANGE_RATE2 ON GOVEIT_EXCHANGE_RATE2.EXCHANGE_RATE_TYPE_ID =
GOVEIT_EXCHANGE_RATE_TYPE.ID
AND GOVEIT_EXCHANGE_RATE2.SOURCE_ID = GOVEIT_EXCHANGE_RATE1.DESTINATION_ID INNER JOIN
GOVEIT_CURRENCY GOVEIT_CURRENCY3 ON GOVEIT_EXCHANGE_RATE2.DESTINATION_ID = GOVEIT_CURRENCY3.ID
WHERE
GOVEIT_EXCHANGE_RATE1.VALID_FROM = GOVEIT_EXCHANGE_RATE.VALID_FROM AND
GOVEIT_EXCHANGE_RATE.DELETED_BY IS Null AND
GOVEIT_CURRENCY.DELETED_BY IS NULL AND
GOVEIT_EXCHANGE_RATE_TYPE.NAME = ‘Actual’ AND
GOVEIT_EXCHANGE_RATE_TYPE.DELETED_BY IS NULL AND
GOVEIT_CURRENCY1.DELETED_BY IS NULL AND
GOVEIT_EXCHANGE_RATE1.DELETED_BY IS NULL AND
GOVEIT_CURRENCY1.CODE = ‘USD’ AND
GOVEIT_CURRENCY2.DELETED_BY IS NULL AND
GOVEIT_CURRENCY2.CODE = ‘EUR’ And
goveit_currency.code = ‘CHF’ AND
GOVEIT_EXCHANGE_RATE2.DELETED_BY IS NULL AND
GOVEIT_EXCHANGE_RATE2.VALID_FROM = GOVEIT_EXCHANGE_RATE.VALID_FROM AND
GOVEIT_CURRENCY3.CODE = ‘GBP’ AND
GOVEIT_CURRENCY3.DELETED_BY IS NULL AND
GOVEIT_EXCHANGE_RATE.TENANT_ID = ‘ibm’
ORDER BY
fxdate
When I go to the SQL console and run the query, I get the result rows as expected.
Since update 7.2.2 I suddenly don’t get data in the chart …
I attached the respective report here.FX development CHF-EUR-USD-GBP (broken).zip (7.1 KB)
Does anyone have an idea what could be the root cause?