We have a universe that should retrieve historical data. We created some Oracle functions to get the proper data out of the database. We use those functions in the definition of our objects and that works perfectly. Now, we have also used an Oracle function in a join, but we run into a challenge here.
The report user enters a historical date, for which the data needs to be retrieved. The join needs to get this date, that is the result of the user’s input. The join “looks” like this: Prices.PriceCCY = f_PriceCCY(Product.Country, Product.ProductID, ).
The join works if I use sysdate as , and it nicely returns the correct data. So, the set-up is proper, but now, I only need to get the user’s response in this join. How to achieve this?
In a message dated 00-03-09 15:38:27 EST, you write:
The report user enters a historical date, for which the data needs to be
retrieved. The join needs to get this date, that is the result of the user’s input. The join “looks” like this: Prices.PriceCCY = f_PriceCCY(Product.Country, Product.ProductID, ).
The join works if I use sysdate as , and it nicely returns the correct data. So, the set-up is proper, but now, I only need to get the user’s response in this join. How to achieve this?
If you look at the @Prompt() syntax, that should fit the bill. Replace with something like:
@Prompt(‘Enter Historical
Date:’,‘D’,)
That will prompt the user for a date value. The ‘D’ specifies a date value is to be input, so there will be some validation going on. In other words, if you specify ‘D’ for the type, then the user cannot type in ‘FRED’ or ‘WILMA’ since those are not valid dates.