I am trying to populate grid with result from a!queryEntity. Data loads with one

@jayashrib223 Hi, just had a look at the code you attached. Your code should additionally handle the following - Reload the local!poDataToLoad with fresh values (data and pagingInfo) not only when Search button is clicked, but also when you interact with paging grid (i.e. sorting/ paginating). Rest of the code seems fine. Please do let me know if you have any follow up questions.

Thanks sikhivahans for the inputs. However, I am using pagingInfo inside my a!queryEntity expression and I want to avoid calling expression multiple times. How can I achieve this?

No problem, please find attached the code with few comments and let me know if you have any follow up questions. Hope that helps you.

QueryEntityGrid.txt

It worked. Thank you for your assistance!

Noticed that sorting is working now but pagination is not. If I have batchSize=10, then I am getting only 10 records in grid (1-10 of 10 ) in total eventhough I have 18 records(totalCount=18).

Great!! There are 2 options of doing it:
1. You can pass a batchSize of -1 to the queryEntity rule which getes you all the records in a single go.
OR
2. Call the queryEntity rule upon the change in value of the pagingInfo. (Because you are obtaining a limited set of records which are sufficient for single page initially. So your query rule has to be re-run when you move to next page i.e. next batch should be fetched upon pagination)

Thanks sikhivahans for all your help! It's working now.

Great!!