Query Entity is throwing error while fetching data

nirupamaanuragt 4 months ago

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

Top Replies

venkat Avuluri 4 months ago +1
Certified Senior Developer

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
David Jimenez Calleja 4 months ago in reply to venkat Avuluri +1
Certified Lead Developer

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)

0 David Jimenez Calleja
Certified Lead Developer
3 months ago in reply to nirupamaanuragt

Can you check if you can see more info about the error in log files?

Have you tried executing the query directly in database?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel