Tip: Jaspersoft Custom Domain Date filter does not work

[Legacy User]

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

[System]

Thanks for sharing this tip with the community Elwin!

Elwin van BOMMEL wrote:

 

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

[Legacy User]

Want to add an additional note:

This is a workaround, when changing the domain you have to reapply this. Still looking for a more solid solution.

[navzjoshi00]

Thank you, Elwin

 

Regards

NJ

[raydi02]

Thanks a lot Elwin for the workaround, we were also facing the same issue, this work around helped. Cheers!

 

Regards,

Dipanjan

[Georg Schmid]

Thanks Elwin!

IN the OOTB-domains, this is solved by adding calculated fields of type java.util.Date for the date attributes and using them in the sets, e.g. for SCHEDULE_START:

<field fieldDBName="inv_calc_schedule_start" dataSetExpression="DWH_INV_INVESTMENT.SCHEDULE_START" type="java.util.Date" id="DWH_INV_INVESTMENT.inv_calc_schedule_start"/>

 

Regards,

Georg

[Legacy User]

Thanks Georg,

 

This is a more solid workaround, and came just in time before I promoted the domain to production.

 

grtz,

 

Elwin