Question

more than 5000 records

Forum|Forum|2 years ago
August 1, 2024
19 replies
0 views

How can we display more than 5000 records in interface and search by custom picker?

Anyone having Idea?

You cannot query all 5000 records at once since it will lead to performance issues and the query will time out. You can try to query the data in batches of 10 or 20. And showing all 5000 records at once will not be looking good as well from UI point of view.

You can query the data once some value is entered in the custom picker which can be used as a filter.

K

kavitar298810Author

I'm using pagination and showing 10 records per page , but in my data table having more than 5k records, how can I display or shown under search 5001th record ?

sarathkumr268295

On what basis will the 5001th record will be displayed?
If its based on the value entered on the custom picker, just pass it as filter to the query then it will work similar to what you have implemented. You dont need to worry about anything else. The pagination and other things will take care. Whatever is matching that picker value, will get displayed in the first 10 rows. If its more than 10, it will be in the next page which will get queried when you move to the next page.

stefanhelzle0001

For what purpose?

K

kavitar298810Author

I'm having a scenario to associate records for particular department, If I'm searching 5001 record It will not be displayed under the search or pagination itself

stefanhelzle0001

I still have a hard time understanding what you try to achieve.

My max number of rows in a grid is 20. Everything else is solved using paging, filtering and search.

prasantap0900

If you want to show the 5000 data in the interface, you can configure the page-nation with the help of looping. Like if your start index and batch size is not equal then you just go for the next. Like that you can configure. But what is the use

K

kavitar298810Author

I tried with cdt -

batch size -1 its breaking after 33000 records and Record Type breaking after 5000 records

after searching in picker, it should be displayed in the grid also

prasantap0900

I do not think so that will be not a good user experience. If you are filtering with "A" there is so many countries, if you are searching with "AME" may be there has only few countries or America only. Query the data and configure the filter like that. And why do you need to show much more data in an interface? I think you should not.

I think you got my point.

karumurua531442

hi [mention:32b006e57eb743ada44b00598fbfe6f3:e9ed411860ed4f2ba0265705b8793d05] May I know what is your requirement to show more than 5000 records in UI, with a custom picker, this would affect the user experience