Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Question

 Dilip Kumar Narayanappa (DilipKumarN2929)
Infosys
Dilip Kumar Narayanappa
Infosys
IN
DilipKumarN2929 Member since 2016 6 posts
Infosys
Posted: Apr 10, 2018
Last activity: Apr 10, 2018
Posted: 10 Apr 2018 1:30 EDT
Last activity: 10 Apr 2018 6:06 EDT
Closed

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

To see attachments, please log in.
Reporting

Posted: 6 years ago
Posted: 10 Apr 2018 4:47 EDT
Anil Vanaparthi (vanaa)
PEGA
Senior Manager, Services Engineering, Case Management
Pegasystems Inc.
IN

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?

To see attachments, please log in.
Posted: 6 years ago
Posted: 10 Apr 2018 6:06 EDT
Basavaraj Kadakol (BASAVARAJ)
PEGA
Senior Manager of Technical Support Engineering
Pegasystems Inc.
AU

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

To see attachments, please log in.

We'd prefer it if you saw us at our best.

Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice