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 17.x
CA Business Intelligence JasperReports Server 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.
<!-- 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.
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?