Or clause in CAML query behaving like And clause

Question

I have a custom content type in the Pages library of a publishing site, which contains two multi-value taxonomy fields. I'm trying to write a CAML query that will return any items from the Pages library that contain specific values in either of those taxonomy fields, i.e. return any items where taxonomy field 1 = 'X' or taxonomy field 2 = 'Y', so I'm using In clauses within an Or clause in my CAML query. The weird thing is that the In clause appears to be behaving like an And clause. For example the following CAML query only returns items when both the NewsLocation field contains the value in the first In clause AND the OperatingCompany field contains the value in the second In clause.

<Where>
  <Or>
    <In>
      <FieldRef LookupId='True' Name='NewsLocation' />
      <Values>
        <Value Type='Integer'>1</Value>
      </Values>
    </In>
    <In>
      <FieldRef LookupId='True' Name='OperatingCompany' />
      <Values>
        <Value Type='Integer'>3</Value>
      </Values>
    </In>
  </Or>
</Where>

Have I got the CAML syntax wrong, or is there an issue with how In clauses work in Or clauses?

Answer 1

It looks like you're experiencing the same issue seen in this StackExchange post: Sharepoint CAML Query IN operator

The author of this post was also trying to use In inside of an Or clause. He thought that the issue might be a bug with LookupID because he was able to resolve the issue by searching against the text values:

<Where>
<Or>
<In>
        <FieldRef Name="COLUMN1"/>
        <Values>
          <Value Type='Text'>VALUE1</Value>
          <Value Type='Text'>VALUE2</Value>
        </Values>
      </In>
<In>
        <FieldRef Name="COLUMN2"/>
        <Values>
          <Value Type='Text'>VALUE3</Value>
          <Value Type='Text'>VALUE4</Value>
        </Values>
      </In>
</Or>
</Where>

This strategy returned the correct results for him. Are you able to use text values or is using the IDs a requirement?