Report JIVE column filters are not filtering correctly for decimal values

Issue:

In a report, we are trying to use the column filter on a table column field to filter on values matching the condition but it does not return the expected rows. 

For example:

In the report there is a table with a field containing value 1.629214.

We set the JIVE  'Column filters' on this column to the following:

Condition: "Show only rows where" Equals 1.629214 

Result: There are no rows returned

We noticed that when we select the 'Column filters' again, the actual value was automatically truncated to 1.629 instead of keeping the entered value of 1.629214.

How do we resolve this so that we get the results returned for the exact filter value entered ?

Solution:

There is a configurable pattern in:

<jasperserver-webapp>/WEB-INF/bundles/jasperreports_messages[_lang[_country]].properties

under the key:

net.sf.jasperreports.components.number.pattern

that defaults to:

###,###.###

This can be adjusted to contain more digits after the decimal place :

###,###.######

The pattern is used to adjust both numbers on server and the ones coming from the UI when comparing them for filtering purposes.

ref: 01844211