3

Can I filter my view to show only 5000 recent added/updated out of 6000 items? My list has more than 5000 items and I want to show only 5000 recent items.

Improve this question

1 Answer 1

Reset to default
0

You can achieve this,

First you have to Sort items by modified date or Created date and then set item limit.

  1. Go to "Your View" In list setting.
  2. Click on "Your View" on which you want to set item limits. (Modify View)
  3. In "Sort" section, select "created" or "modified" column from drop down.
  4. Then select the radio button "Show items in descending order"
  5. Go down, In "Item Limit" section, Type the maximum number of items you want to display.
  6. Then select radio button "Limit the total number of items returned to the specified amount".
  7. Ok
Improve this answer
7
  • but pagination wouldn't work, I want paging as well.
    – Ali
    Commented Mar 14, 2016 at 23:29
  • Then there is another radio button under "item limit" section "Display items in a batch of specified size" . Select this. It will enable pagination.
    – SP Developer
    Commented Mar 15, 2016 at 3:36
  • "Item Limit" section, Type the maximum number of items you want to display. gives the number of items you want to display per page, I am looking for an option to show only 5000 items but with pagination.
    – Ali
    Commented Mar 15, 2016 at 3:45
  • As I told in my comment. Select radio button "Display items in a batch of specified size"
    – SP Developer
    Commented Mar 15, 2016 at 3:49
  • but that will throw error if items are more than 5000.
    – Ali
    Commented Mar 17, 2016 at 2:08

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.