eVBI

Tip: Jaspersoft Custom Domain Date filter does not work

Discussion created by eVBI on Mar 23, 2016
Latest reply on Apr 20, 2016 by eVBI

We had the following issue:

1. create a custom domain, using the datawarehouse

2. create an ad hoc view with an date (for example project start date)

3. Put a filter on this date and nothing happens when filtering :-(

 

Source of the issue, when creating the domain it will define the type of the fields in case of the date fields the type java.sql.Timestamp was determined while it should be java.util.Date.

 

Solution

1. go to your domain and export

2. open the schema.xml in a text editor and find  java.sql.Timestamp and replace all with  java.util.Date.

3. Upload the domain

 

Result problem solved.

 

kind regards,

 

Elwin

Outcomes