Clarity PPM

Expand all | Collapse all

Tip: Jaspersoft Custom Domain Date filter does not work

  • 1.  Tip: Jaspersoft Custom Domain Date filter does not work

    Posted 03-23-2016 06:48 AM

    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



  • 2.  Re: Tip: Jaspersoft Custom Domain Date filter does not work

    Posted 03-23-2016 12:38 PM

    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



  • 3.  Re: Tip: Jaspersoft Custom Domain Date filter does not work

    Posted 04-04-2016 02:56 AM

    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.



  • 4.  Re: Tip: Jaspersoft Custom Domain Date filter does not work

    Posted 04-04-2016 04:01 AM

    Thank you, Elwin

     

    Regards

    NJ



  • 5.  Re: Tip: Jaspersoft Custom Domain Date filter does not work

    Posted 04-04-2016 03:52 AM

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

     

    Regards,

    Dipanjan



  • 6.  Re: Tip: Jaspersoft Custom Domain Date filter does not work

    Posted 04-13-2016 06:26 AM

    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



  • 7.  Re: Tip: Jaspersoft Custom Domain Date filter does not work

    Posted 04-20-2016 01:41 AM

    Thanks Georg,

     

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

     

    grtz,

     

    Elwin