You need to sign in to do that
Don't have an account?
Chinnodu
Hi All,I have 10000 records , now i will be retrive 5000 records, how to we can achieve this ?
Hi All,
I have 10000 records , now i will be retrive 5000 records, how to we can achieve this ?
Thanks,
viswa
I have 10000 records , now i will be retrive 5000 records, how to we can achieve this ?
Thanks,
viswa
Normally if you want to display all the 5000 records in a single vf page is possible if and only if you use the READONLY = TRUE in vf page.
Then you can use this Query to get all the 5000 records.
If you use Readonly = true then we can display upto 10000 records in a single vf page at a time.
Here you can use this Query to display 5000 records..
Actually Visual force can display 1000 records only .If you want display more than 1000 records you can use Pageniation.
You have two options for pagination inside of Visualforce pages
- Offset
- StandardSetController
With OFFSET pagination you are limited to 2,000 records; however, with a StandardSetController you can paginate up to 10,000. So, one thing you could do would be to refactor to use the StandardSetController paginationAnother thing that you could do, would be to add some sort of filtering capability, so that the user can get to the records they need. For example, if you would return more than 2,000 records, display a message saying something like "Showing 2,000 records but there could be more. Please use a filter to narrow down the results."
I hope it will help you.
Regards,
Jyothsna D