GetListItemChangesSinceToken query returns "Value does not fall within the expected range."

Question

The following statement returns "Value does not fall within the expected range." when the query argument is filled in. If it is set to null, the call works fine.

XmlElement data = (XmlElement)listsObject.GetListItemChangesSinceToken(listGUID, null, query, viewFields, null, queryOptions, null, contains);

The query argument contains the following code:

<Query>
  <Where>
    <Eq>
      <FieldRef Name="Status" />
      <ValueType Type="Text">Approved</ValueType>
    </Eq>
  </Where>
  <OrderBy>
    <FieldRef Name="Status" />
  </OrderBy>
</Query>

Any idea why this happens?

Answer 1

Have to tried removing the <Query> tag from the query text? Also, have you tried putting the OrderBy before the Where? Sometimes SharePoint doesn't like queries like that

Have you tried changing the order of the OrderBy and Where tags? According to this blog post and my own personal experience, you should put the OrderBy tag before the Where tag.

Answer 2

Did you make sure that fields you are using in OrderBy are included in the SPSiteDataQuery.ViewFields property?

If not, could you please paste the whole code?

Answer 3

At Lists.GetListItemChangesSinceToken Method it says:

Note: The GetListItemChangesSinceToken method fails for lists with unique item permissions if the PermMask field is not explicitly requested: <FieldRef Name="PermMask"/>

Could this be your issue?

Answer 4

GetListItemChangesSinceToken MSDN Reference article says:

The query parameter is not intended to be used with the contains parameter.

So, just remove your contains parameter, and it should be ok.