none
List view threshold Issue in SharePoint Online RRS feed

  • Question

  • We have a list <o:p></o:p>

    -> We have 200,000 items in this list<o:p></o:p>

    -> we are creating a view with filter on "created" date type column<o:p></o:p>

    -> issue is that the items the column is fetching is inconsistent<o:p></o:p>

    -> For example, here is the scenario:<o:p></o:p>

     <o:p></o:p>

    if we filter for the date Jan 28th, we get 99 items<o:p></o:p>

    if we filter for the date greater than Jan 29th and less than Feb 1st, we get 114 items<o:p></o:p>

    if we filter for the date greater than Jan 28th and less than Feb 1st, we are supposed to get 213 items (adding above two numbers)<o:p></o:p>

    We have 7 index columns in the list. 

     <o:p></o:p>

    But we get error saying "The view cannot be displayed because it exceeds the list view threshold (5000 items) enforced by administrator<o:p></o:p>

     

    <o:p></o:p>

    Thursday, February 14, 2019 12:10 AM

Answers

All replies