Problem with parameters of TIMESTAMP type in Information Objects.

I have a problem and it looks like a bug in iServer Express.
Here is a short description of configuration that is quite simple:
1) At first, I create Map object by entering the native query string:
select inv.invoice_id, inv.tin, inv.invoice_amount from INVOICE inv where inv.invoice_date >= ?
"?" sign generates the creation of unnamed parameter param_1 in the map that I rename to "Invoice date" and select TIMESTAMP type.
2) Then I create Information Object based on this Map object.
Then I drag the source parameter to its Parameter column so that parameter from Inf.object is connected to Map object.
3) I go to Iportal and run the Information Object and see pop-up with required my parameter to be entered with build-in calendar.
When I select any date in the format dd.MM.yyyy H:mm:ss since I am asked for it by message "* Please enter date values like: dd.MM.yyyy H:mm:ss"
I get a message:
Value [ 13.05.2010 0:00:00 ] is invalid for parameter [ "Invoice date" ].

So the problem is that since I can't enter the value for parameter I can't use the Information Object.
P.S. I don't experience similar problems if the type for parameter is for example Varchar.

Find more posts tagged with

Comments

Chezy

Ivan,
What version of iServer Express you are trying with? From Information Console, you are choosing the option 'Create Query' and enter the value in 'Filters' tab, right?

Chezy

IvanB

<blockquote class='ipsBlockquote' data-author="Chezy">Ivan, 
What version of iServer Express you are trying with? From Information Console, you are choosing the option 'Create Query' and enter the value in 'Filters' tab, right? 
 
Chezy</blockquote>
 
Hi Chezy, 
 
Thanks for reply. I am using iServer Express 10. 1) and 2) points I do in Actuate BIRT Report Designer. 3) I do from <a class='bbc_url' href='http://localhost:8900/iportal'>http://localhost:8900/iportal</a>. I am not using Filters in this examples. Please see screenshots.

IvanB

Here is the configurations of map object and information object:

Chezy

Ok, Thanks. In the latest A11 version I don't see the issue. We will investigate in version 10 and let you know.

Chezy