Somebody asked this question, what will be proper answer for this?

There is a list having 50,000 records, now there is a custom web part which wants to show only top 5 five records. How can we implement this?


Assuming you have the List View Web Part that you want to manipulate to show only 5 records, you start by editing the web part and edit the current view. Clicking the link will get to the edit view page, where you can filter, sort and limit the number of records returned in you view, which will be used by your web part.

enter image description here

|improve this answer|||||
  • do u think top 5 is possible by LVWP? I think for this query is required? – Mdh22 Jul 14 '13 at 8:18
  • Dear Benny, I have another question for you. Does any professional company really keep 50000 records in a list when already there is threshold in-place? How do they overcome this problem? – Mdh22 Jul 14 '13 at 8:41
  • @Mdh22 A list can keep up to 30'000'000 item in the list, if they want to, so 50'000 items isn't uncommon. But you need to facilitate sort, filter and pagination to make it work OK. – Benny Skogberg Jul 14 '13 at 9:40
  • If we have set threshold, then how can we bypass threshold issue & keep large value in the list? – Mdh22 Jul 16 '13 at 3:13

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.