I have a list which have a lot of data. I can filter list in standard view but when I use quick edit view, just some column can filtered. It's not display "show filter choice" when the column have too many choice. How can I fix that?
-
how many items do you have in your list and can you please let us know the type of column you are facing issues withSagar– Sagar2018-01-22 10:08:02 +00:00Commented Jan 22, 2018 at 10:08
-
the list has about 10000 items but I filtered items to the view with 2000 items and it still can not filter. Many column has this issue, text, date, choice, ... I realize which column has a little data will display filter choice but if it has too much data then it will not display "show filter choice" like standard view do.Anh Dai Pham– Anh Dai Pham2018-01-22 10:31:11 +00:00Commented Jan 22, 2018 at 10:31
Add a comment
|
2 Answers
This post deals with a similar kind of issue, it described a limitation of 5000 items in a view.
Read up on Indexing a column, this may help Sharepoint to permit filtering on your column.
I can't comment yet, so I have to add an answer.
But basically I want to follow up on what Tally said, and say that I've found strange behaviour like this before, and what fixed it for me (apart from indexing) was that the filtering had to be in a particular order. (the indexed filter first)
For instance - if I filtered first by "column A is not empty" then "indexed column > date", it would sometimes have symptoms like you described, but if I filtered first by "indexed column > date" then "column A is not empty", it would be happy.
My guess is that because "column A is not empty" filters down to still over threshold, before the indexed filter takes to under threshold, it bugs out.
