How to retrieve Date attributes on Domain Designer at Jaspersoft

Document ID : KB000092625
Last Modified Date : 17/08/2018
Show Technical Document Details
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.
CA Service Desk Manager 14.1 Cum 3 and later, 17.x
CA Business Intelligence JasperReports Server 6.2.0, 6.3.0
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">
<!-- 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:

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?