I am not able to retrieve list items due to it has crossed threshold limit. The number of items in the list is 150000 and I am trying to fetch certain items filtered by a field value(say 'pincode'). Such matched values are not more than 20; Still, I am getting error of 'Threshold limit'
Please check my steps and let me know if I have done anything wrong.
- Created SP List.
- Created columns One of the columns is 'pincode',
- which I create as Index column (primary index).
- upload excel list data into sharepoint list using powershell.(around 150000 entries)
Here is my CAML Query
<Query><Where><Eq><FieldRef Name='pincode' /><Value Type='Number'>110015</Value> </Eq></Where></Query>
Error after operation failed:
"The attempted operation is prohibited because it exceeds list view threshold enforced by the administrator"
It would highly appreciable if someone could give a solution.