SharePoint CAML Query limitation

Question

Hi All,

I am trying to run SPQuery against SharePoint list which has more than 165 OR clauses, which is not nested. I get the following error - .Value does not fall within the expected range.

However query seems to be working fine when the number of OR clauses is less than 156.

Is there any limitation for number for OR / AND which we can provide in SPQuery.Query? Or is it also bound to any character limit?

Any thoughts or suggestions will be helpful.

Answer 1

Hi @Satish Kumar ,

Caml Query will have 160 Or/And clauses limitation:

Sharepoint Webpart CAML and more than 160 clauses

What is the limit of nested OR's in a CAML Query?

I suggest you can reduce the Or clauses in CAML due to the limitation.

---

If an Answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.