Hello,
Can anyone please help me out for following issue ?
Thanks for your time to look on..
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 .