Andy DaleAndy Dale

My feedback

  1. 10 votes
    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      I agree to the terms of service
      Signed in as (Sign out)

      We’ll send you updates on this idea

      3 comments  ·  SharePoint Search  ·  Flag idea as inappropriate…  ·  Admin →
      Andy DaleAndy Dale commented  · 

      This is the problem I am facing as well

    • 1,115 votes
      Vote
      Sign in
      Check!
      (thinking…)
      Reset
      or sign in with
      • facebook
      • google
        Password icon
        I agree to the terms of service
        Signed in as (Sign out)
        You have left! (?) (thinking…)
        69 comments  ·  Sites and Collaboration » Document Libraries  ·  Flag idea as inappropriate…  ·  Admin →

        The 5,000 item threshold is likely here to stay. We are aware that it takes awareness on both sides to get past this limitation: list owners have to build the right fields, indices, and indexed views so that end user queries can run successfully in large lists. And then, end users have to run the correct queries – they can’t just open the root of the list, they have to use a filtered, indexed view.

        We want to pursue work that helps on both these ends – for example, proactively indexing more lists, making suggestions to list owners for views to create that will help end users, and helping end users at query time pick filters that will unblock their queries. Additionally, we want to increase our support for running more types of queries in large lists when an index is present – for example, instead of requiring an indexed…

        Andy DaleAndy Dale supported this idea  · 
        Andy DaleAndy Dale commented  · 

        The 5000 limit causes me endless problems. I keep creating and changing views, have all key columns indexed but still get call from irate customer every few months saying 'Threshold Limit has been reached'. The issue is that to pull all items back on an individual (patient) we have a link that searches all the items in the list. Please, please find a way to fix this biggest frustration.

      Feedback and Knowledge Base