Hello,
Can anyone please help me out for following issue ?
Thanks for your time to look on..
Hi,
Try to disable throttling for that list and see if it works.Â
here is the link of how to do it. :
http://spservices.codeplex.com/discussions/280642
Also try to disable the feature called : “ViewFormPagesLockDown” and see if that works. This feature has been issue with permissions.”
yes thats the only issue I too think so, but Microsoft has not provided any group by limitation like that…so I belive there must be solution…and I am looking for that …Plus I cant remove persmissions..
Do you have any reference link that specify that with 5000 list items level permissions cant work with group by view ?
Hello Dipti,
Item level permissions seem to be the source of your problem then. I suppose that SharePoint has to scan the entire list in order to determine permissions, before even grouping by the indexed column, thus hitting the threshold.
Unfortunately, you’ll have to either remove the item level permissions or increase the list view threshold for your view to work.
Also , I checked the filtering approach you have specified, but still I am facing the same error. I believe its issue with item level permission load, however there is no any reference link by MS saying the limitation for Sharepoint list group by view.
Can you please help me out on this further ?
Thanks,
Thanks a lot Aldo Mar to look on this issue !!
Well , there is an item level permissions too , If I remove item level permission then group by works…that is what I found in new created list using template where item level permission was not there and hence it was grouping the item even it was more than 5000.
above issue we observer through sql profiler tool while querying list with item level permission and without permission , with item level permission the load over list was high and hence somewhere its got wrong and groupby didnt worked.
I will check out the filtering approach you have pointed out and let you know .
