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
Can you check if you can see more info about the error in log files?
Have you tried executing the query directly in database?
You can try below alternate option.
1. Are you executing query entity on each filter?
2. If Yes, instead of executing on each filter, have a button like "Search" and execute query entity on click of Search
And when other fields are selected, From date selection is fine.
We have verified the data and the values stored are consistent.
Not yet. Wondering why timeout should happen on only one field when the to date is also mapped to the same column at the backend.
hi nirupamaanuragt that could be time out also, or there is a possibility if wrong data is stored in columns
Typically such an error message indicates a timeout. Did you check the tomcat stdout log file?
And when are selected from date and another field?
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.
But if it is a conversion error, it should fail when using the date filter with another one... and in that case it is working fine (unless in that case the query returns an empty result set)