I have an adhoc view with field myDate, when I add it to the filters and say myDate is After DAY-30 or any other time value, nothing is affected.
There results don't get refreshed with this filter. However same report used to work with jaspersoft 6.0
Why isn't it working in version 6.1?
I just tested this with the supermart domain that comes with the samples and is working. I just selected the Supermart Domain, the Expenses Group and filtered by expense date (YEAR-3 or MONTH-40 since the dates of that dataset are for 2012 and 2013) and choose "is after" for the filter action.
One important thing to note is that you need to press the APPLY button at the bottom of the filter panel so the filter get applied.
Was the domain imported form 6.0? What database are you using?
of course I clicked Apply and nothing happened.
The domain was imported from v.6.0
and I have this in the log:
@marianol I found out that in v.6.0 my query in jasper used to be and ("PO_DATE" > TIMESTAMP '2015-08-12 00:00:00')
while in v.6.1 it's and ("PO_DATE" > '2015-08-12 00:00:00') that's why the error.
But how to fix it? knowing that mapping of semantics is correct.
Here is a workaround I received from Support.
There is a workaround and to make this change, edit WEB-INF/applicationContext-semanticLayer.xml and look for the property "excludeFunctionTemplates" in the bean "defaultSQLGenerator". Comment out the two <value> elements as shown: <bean class="com.jaspersoft.commons.semantic.dsimpl.SQLGenerator" id="defaultSQLGenerator" scope="prototype"> <property name="excludeFunctionTemplates"> <list> <!-- <value>Integer</value> --> <!-- <value>Timestamp</value> --> </list> </property> <property name="functionTemplates"><map></map></property></bean></value>
But if i comment those 2 I'm getting the following error: java.lang.RuntimeException: groovy evaluation failed on string args.value and expression Integer(2015)
and if I comment only the timestamp I get the following error: java.lang.RuntimeException: error getting schema