Hi All,
We are facing one issue while fetching data having few filters. For e.g., the filters like to_date, fund etc are working fine but the moment we select from Date, it throws error. And surprisingly when I am selecting from_date after selecting any other filter, it is working fine.
Discussion posts and replies are publicly visible
That was casting error. Have you checked datatype of BalanceData column in your CDT. Validate whether your value data type and Column datatype are same or not
Checked this. BalanceData datetype is consistent across CDT & Database. And surprisingly the Balance date is mapped to both From Date & to Date. And is giving error only when From date is selected.
And when are selected from date and another field?
And when other fields are selected, From date selection is fine.
Can you check if you can see more info about the error in log files?
Have you tried executing the query directly in database?