Record is failing for 5000 rows giving "An Error occurred while retrieving data"

Hi PrakharGarg,

In your Record, you had Record list section, There you can restrict the paging, how many records to be displayed in one page, In a single page, it can be displayed up to 100 rows.

Please follow the below link for more info: docs.appian.com/.../Records_Tutorial.html

Regards,
Krishna u

Hi Krishna,

Yes, that is fine but my question is if I am restricting the no of records per page to 20 suppose, then whether it will fetch all th records and display 20 per page or it will only fetch 20 records for 1st page and then subsequently fetch the recorsds when user navigates using paging.

My main pain point is opening a record type is failing because of 5000 records after adding default filters

Hi Prakhar Garg ,

It will fetch all the records , and show 20 per page. you can keep the default filter for search criteria. In Records it can fetch 'n' no.of rows, It is possible by giving paging(Rows to Display Per Page) restriction to it.

Regards,
Krishna U

Hi Prakhar Garg ,

It will fetch all the records , and show 20 per page. you can keep the default filter for search criteria. In Records it can fetch 'n' no.of rows, It is possible by giving paging(Rows to Display Per Page) restriction to it.

Regards,
Krishna U

Hi Krishna,

It will fetch all the records , and show 20 per page - It means this limit is just for display, anyways it will fetch all the records. Correct?

you can keep the default filter for search criteria - Yes that is fine, but it is not of any help in our case.

In Records it can fetch 'n' no.of rows, It is possible by giving paging(Rows to Display Per Page) restriction to it. - As per your 1st point it will fetch all the records and display as per configuration (5 - 100) then paging restriction is just for displaying. But I want to limit the fetching as well as mentioned earlier.
Can you please elaborate more on the third point as it seems to be bit confusing for me?