Question
Can we use a property of type date in RD filter.
Hi,
Can we use property of type date in RD filter to filter records based on date column in DB table or can it be filtered only on datetime columns ?
I have a Oracle table in which one of the column is of type date, in RD I am trying to filter the records based on date column using property of type date. I am receiving following error "** An error occured on executing the query for the report definition - Database column <unknown> in database pegadata, table <unknown> has an unknown type: JDBC Type: Date".
Please help
Thanks,
Dilip
Hi Dilip,
I believe Oracle date type maintains a time as well and not just date, hence you are getting the above mentioned error. And you should try mapping property type "Date" to the column type "VARCHAR (8)
Regards,
Basavaraj
We can use date type property in the filters. When we expose a property of Date type, the column created is of VarChar. Not sure if we can map oracle date column to date property.
Are you able to add that date property in list of columns to fetch in report definition and get the results?