Hi All,
I am trying to retrieve data from DB by using query entity. I am able to fetch 10,000 records beyond that I am getting "a!queryEntity: An error occurred while retrieving the data".
I have more than 18000 records in my table which I need to display in a paging grid with filter options. I have check the performance of my view at DB end. It is not even taking 1 second to execute that view not sure why with query entity is not able to fetch all records. When in my paging info I am giving batchsize more that 10000 or -1, it gives me the error below this, it is working fine. Not sure if query Entity has limitation in fetching number of rows.
Please share, if I can use some other way to fetch all the records from DB and use in my interface.
Thanks in advance !!
Regards
Anusha
Discussion posts and replies are publicly visible
Hi , thanks it sounds it can work, but identifiers are not working for latest Appian version, could you update your recommendation? thanks
I'd suggest creating a new post with the issue you're having and provide some more context. This error "An error occurred while retrieving the data" is pretty generic so your use case may have an entirely different cause.