Hi,
I have created a view to display it in read only grid.
There is huge amount of data that needs to be retrieved and displayed.
But when am writing simple query to fetch data am getting error:
a!queryEntity( entity: cons!AB_DE_V_DD, query: a!query(
pagingInfo: if( rule!APN_isEmpty( ri!pagingInfo ), a!pagingInfo( startIndex: 1, batchSize: 50 ), ri!pagingInfo ) ) )
Error: Expression evaluation error at function a!queryEntity: An error occurred while retrieving the data.
Can someone help to sort this issue.
Note: When am using filter to retrieve data, am not getting any error
Discussion posts and replies are publicly visible
Check whether any of the dateTime values in the DB are coming back as "0000-00-00 00:00:00" or similar to this. I've seen tthis happen before and it breaks the Appian query. On the other hand, NULL values in the dateTime column should work fine from within Appian. This is my best guess without being provided more detail as to what error you're getting or what the appian logs say.