how to use content iterator in sharepoit 2010

Question

there are 7000 items in my list. i need to filter the list and retrieve result i am using the following code in my webpart.

string query = "<Where><BeginsWith><FieldRef Name='Project' /><Value Type='Text'>ab</Value></BeginsWith></Where>"
SPQuery spquery = new SPQuery();
spquery.Query = query;
ContentIterator iterator = new ContentIterator();
iterator.ProcessListItems(list, spquery, ProcessListItem, ProcessListItemError)

as i am using ContentIterator still it is giving me the error "The attempted operation is prohibited because it exceeds the list view threshold enforced by the administrator"

Update:

string query2 = @"<Where><Eq><FieldRef Name='Project' /><Value Type='Text'>11759</Value></Eq></Where>"; 
SPQuery spquery = new SPQuery(); 
spquery.RowLimit = 10; 
spquery.Query = query2; 
spquery.QueryThrottleMode = SPQueryThrottleOption.Override; 
ContentIterator iterator = new ContentIterator(); 
iterator.ProcessListItems(list, spquery, ProcessListItem, ProcessListItemError);

In every case weather I used SPCollectionItem or Iterator. when ever I am passing the where condition in spquery. same error comes.

score 2 · Answer 1 · answered Jul 18 '12 at 17:00

To efficiently use ContentIterator and avoid throttle exception, you should explicitly include OrderBy clauses.

Try to use ContentIterator.ItemEnumerationOrderByNVPField which actually enables the index to be used.

For more details,check this out

http://extreme-sharepoint.com/2012/07/17/data-access-via-caml-queries/

score 1 · Answer 2 · answered Jun 23 '12 at 23:31

Likely because the the Field you are comparing on is not indexed: http://msdn.microsoft.com/en-us/library/ff798465

If you were to build a query that returns the first 100 items sorted by the ID field, the query would execute without issue because the ID column is always indexed. However, if you were to build a query that returns the first 100 items sorted by a non-indexed Title field, the query would have to scan all 10,000 rows in the content database in order to determine the sort order by title before returning the first 100 items. Because of this, the query would be throttled, and rightly so—this is a resource-intensive operation.

score 0 · Answer 3 · edited May 23 '17 at 12:06

0

You either have to ...

... set a RowLimit below the configured threshold on your query.
... or define a query that returns less items.
... or change the threshold of the list.

edited May 23 '17 at 12:06

Community

1
1

answered Jan 07 '12 at 10:38

Stefan

14,530
4
55
62

thanks row limit was defined and what about this query abc it is also giving the same error as number of return result is one – saurabh Jan 07 '12 at 10:45
You could set the [SPQuery.QueryThrottleMode Property](http://msdn.microsoft.com/en-us/library/microsoft.sharepoint.spquery.querythrottlemode.aspx) to `Override`. Does this change anything? – Stefan Jan 07 '12 at 11:53
Updated code string query2 = @"11759"; SPQuery spquery = new SPQuery(); spquery.RowLimit = 10; spquery.Query = query2; spquery.QueryThrottleMode = SPQueryThrottleOption.Override; ContentIterator iterator = new ContentIterator(); iterator.ProcessListItems(list, spquery, ProcessListItem, ProcessListItemError); in every case weather i used SPCollectionItem or Iterator. when ever i am passing the where condition in spquery. same error comes. – saurabh Jan 07 '12 at 15:00

Tjassens · Answer 4 · 2012-01-09T08:25:23.227

0

have you seen this:

msdn link

hmmz, just tried this and it still gave an error. If I use this however I can iterate over way more than 7k listitems:

private int GetItems(SPList list){
    var query = new SPQuery();
    query.Query = "";
    query.QueryThrottleMode = SPQueryThrottleOption.Override;
    var items = list.GetItems(query);
    return items.Count;

}

so my advice is to just use the list.getitems

edited Jan 09 '12 at 08:25

answered Jan 09 '12 at 08:17

Tjassens

922
6
9

if you try with some "where clause" in query, again it will give throttle error – saurabh Jan 12 '12 at 17:11
then I cant help you because I tried it and it works fine over here – Tjassens Jan 13 '12 at 11:16

score 0 · Answer 5 · answered Jan 23 '12 at 04:07

You just need to change your query.

    //Keep your query inside <View></View> tag.
    string query = "<View><Where><BeginsWith><FieldRef Name='Project' /><Value Type='Text'>ab</Value></BeginsWith></Where><View>" 
    SPQuery spquery = new SPQuery(); 
    spquery.Query = query; 
    ContentIterator iterator = new ContentIterator(); 
    iterator.ProcessListItems(list, spquery, ProcessListItem, ProcessListItemError)

Now run the program and it will work.

That runs - but now the SPQuery isn't applied. – Andy Burns Apr 27 '12 at 10:27 — Andy Burns, Apr 27 '12 at 10:27

how to use content iterator in sharepoit 2010

5 Answers5