How to retrieve Date attributes on Domain Designer at Jaspersoft

Products

• SUPPORT AUTOMATION- SERVER
• CA Service Desk Manager - Unified Self Service
• CA Service Desk Manager
• CA Service Management - Asset Portfolio Management
• CA Service Management - Service Desk Manager

Issue/Introduction

How to retrieve Date attributes on Domain Designer at Jasperserver?

When trying to develop Jaspersoft reports, during the configuration of the Domain, it is possible you will not be able to retrieve any Date attributes, such as "open_date", "resolve_date", "close_date", "last_mod_dt", etc.... from any table.

Environment

CA Service Desk Manager 14.1 Cum 3 and later, 17.x
CA Business Intelligence JasperReports Server 6.2.0, 6.3.0

Resolution

Actually one can see dates in domains if you add the line highlighted in red below to the ...\jasperserver-pro\WEB-INF\applicationContext-semanticLayer.xml file.

<property name="codeToJdbcTypeMapping">
<map>
<!-- entry key="<code>" value="<field name>" -->
<!-- -101 is TIMESTAMP WITH TIME ZONE in Oracle, mapped to TIMESTAMP -->
<entry key="-101" value="TIMESTAMP"/>
<entry key="11" value="TIMESTAMP"/>

Recycle Jasper Report Server after making the modification and date attributes like open_date, etc... should now appear.
  

Additional Information

Notes:

Currently it is not possible to filter on dates. We are currently working with the vendor to see if date filtering is possible.
Such customization is not supported directly by CA. We are just providing an option here.
CA support does not support Domains created by customers.

How to retrieve Date attributes on Domain Designer Jasperserver?