Table in Apps

Feedback Apps
,
1

I have found the following issues with Table in Apps

  1. Does not load all the rows from the data entity
  2. Not sure on what basis it loads the rows, I have found it pretty random.
  3. Sort on Created/Modified Date at Loading using the Function does not work.
1 Like
3

@Murtuza_Masalawala ,

What is the quantity of records your entity?

When dealing with the data service , it is important to note that it can only return a maximum of 1000 rows for entities with 1000 or more records. This is a constraint of the API.

Therefore, it is not a problem but rather intentional. If you require all the records, you can perform a filter operation based on certain criteria and retrieve the best matching results, which will be less than 1000 at a time.

I hope this explanation suffices. If you are satisfied, please indicate that this is the solution.

Thank you,
Arvind

4

We have around 80,000 rows in the data entity
Thanks for this information which explains why the table displays only a few records
I reckon we will need to build a pagination system and retrieve records based on a filter

Would you be able to confirm on point 3 of my original query before I close this as a Solution. Thanks!
3. Sort on Created/Modified Date at Loading using the Function does not work.

5

@Murtuza_Masalawala ,

It is possible to use the sort function to apply sorting. For additional information, please refer to the URL provided below.

Sort Function

Thanks,
Arvind