sharepoint - What is the limit of nested OR's in a CAML Query? -
from question 'sql in equivalent in caml' learned sharepoint 2010 has sql "in" equivalent caml. 2007 version not back upwards this. op solved nesting bunch of or statements accomplish same result. tested , nesting indeed magic, but...
in case i'm getting items list around 1000 items. dynamically create statement ids in nested or-blocks caml-query. didn't worry big number of nested blocks this msdn states or-element:
occurrences: minimum: 0, maximum: unbounded.
and:
this element can nested within other or , and elements. server supports unlimited complicated queries.
when phone call getlistitems-method sharepoint 2007 built-in webservice, next error:
exception of type 'microsoft.sharepoint.soapserver.soapserverexception' thrown. part of sql statement nested deeply. rewrite query or break smaller queries.
my code written correctly because tested same code 5 nested or-elements , result expected. question is: limit of nested or-elements? cannot find anywhere microsoft claims unlimited.
thanks in advance!
for facing same problem. went search on sharepoint.stackexchange.com , found next question:
nested caml querie results in exception “ part of sql statement nested deeply. rewrite query or break smaller queries”one of answers points website:
caml: nested deepthe person discovered 500 items much batch of 300 worked fine. tried , works me. faces same problem, might solution. :)
sharepoint sharepoint-2007 caml
No comments:
Post a Comment