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
You need to examine the Appian logs to find out the exact root cause of the error. Look in the current stdOut log. Given that you've already said the dataset is huge it may be volume-related, but check the logs to be sure, there are other reasons why this error occurs.
I am building a dashboard for which I have around 8 date and time field, Some time am able to retrieve complete data without any error but sometime it throws an error. In date and time field some dates have NULL value. Can you suggest some solution.
Mike SchmittCan you suggest what exact change i need to do in DB so that i don't face any issue while retrieving data
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.