I have one list i.e-Tickets which is having more then 300K records. There are more than 10 views, now no one view showing items but it is giving threshold limit warning. Threshold limit we set as 80K.

Only ID column is indexed in this list which is by default, now i want to show last 5000 items which is obviously based on the ID column. I checked, list view only shows items if filter expression uses ID column.

  • which version of SP are you using?
    – Akhoy
    Jul 31, 2015 at 10:33
  • I am using SP 2013
    – SBP
    Jul 31, 2015 at 10:54

2 Answers 2


Can't you just set order by ID desc in view? And set the number of returning values to 5000. Thus you'll get last 5000 items.

  • I did that before and it gave me same threshold warning. I guess until we use filter parameters in the View, it will not return exact items.
    – SBP
    Jul 31, 2015 at 9:28
  • You need to have a filter that returns less than 5000 items. The Order you propose would be processed after the filtering stage. Thus it is to late to circumvent the limit. Jun 9, 2016 at 17:56
  • Make sure to only use the ID field in the lower section. No additional filtering/grouping/Counting of records is allowed. Mar 26, 2018 at 21:32

Use a custom search result webpart. After search result webpart in a blank page edit the quary to show only item in your path. Order your return by created date. You will have to deal with search update schedule but it works for a really large items number list. You can also customize the result template using HTML ang got a really reach and fancy result grid

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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