aws jasper server 6.1 Date filters not working

I have an adhoc view with date filter in jasper 6.0. I imported that to another instance of jasper 6.1 and the date filter stopped affecting the adhoc view.

Looking at the adhoc cache, 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.

My database is Oracle and I checked the semantics file in 6.1, mapping of date is correctly set to 

What could be the problem?

mc.bechara's picture
Joined: Jul 7 2014 - 4:39am
Last seen: 8 years 2 weeks ago

0 Answers:

No answers yet