Getting error while creating filters on a field in Jasperserver v5

Jaspersoft Community 'Read-Only' as of July 8, 2022

Transition to New TIBCO Community Just Weeks Away

You can still search, review wiki content, and review discussions in read-only mode. Please email with questions or issues requiring TIBCO review or response.

After dropping respective fields in ad hoc view, I tried creating filters over them but getting error (see attachment). How to get around with this?


error : Cannot evaluate the following expression: betweenDates(report_1.start_date, d'2010-12-06', d'2013-02-28')

gnyanendra's picture
Joined: Dec 3 2010 - 12:25am
Last seen: 8 years 3 months ago

1 Answer:

Can you explain more what type of filter it is. I think the domain you are using has a problem with the date range.

kpant's picture
Joined: Sep 18 2009 - 7:23am
Last seen: 4 years 1 week ago

I had named the domain as 1_domain and later changed it to domain_1 which worked!
I checked with the date results, there were no out of format entries of non-existing dates.

gnyanendra - 9 years 1 month ago