How can we display more than 5000 records in interface and search by custom picker?
Anyone having Idea?
Discussion posts and replies are publicly visible
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.
For what purpose?
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 ?
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
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.
Not clear. can you add some more details?
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.
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
Sarathkumar R Stefan Helzle Yogi Patel Prasanta Paul
Suppose This is custom filter.
Behind this logic I made a rule where I am getting 5000 record by a!queryrecordtype(),
If I want to search 5001th record, how can I ?
I tried with cdt -
batch size -1 its breaking after 33000 records and Record Type breaking after 5000 recordsafter searching in picker, it should be displayed in the grid also