In a CAML Query I filter for multiple lookup fields by combining multiple
This caused a log entry like this:
Some lookup fields were omitted from the query result because the list exceeds th elookup column threshold...
I know that the threshold can be configured in the settings of the web application, but that's not what I want.
I just figured out that CAML also offers an
<In> synthax. In its syntax the lookup field appears only once.
<In> <FieldRef LookupId="TRUE" Name=WhateverField/> <Values> <Value Type="Integer">11</Value> <Value Type="Integer">12</Value> <Value Type="Integer">13</Value> </Values> </In>
So my question is:
Does that count for one lookup or for three concerning the Sharepoint lookup threshold? So ist this an option to get around the threshold problem or not?