In CAML, if I have a managed metadata column with multiple values, you can determine if one of a list of values is in the column using the following query (where the order of the Values/FieldRef elements does not matter):
<Where> <In> <Values><Value Type="Integer">2</Value><Value Type="Integer">8</Value></Values> <FieldRef LookupId="True" Name="Managed" /> </In> </Where>
This will return true for a document which has terms 2 and 7 contained within it, because one of the values (2) is in the managed metadata column.
Is there a way to flip that around and say that all of the field values from the Managed Metadata column must be in the given list of values? i.e. if the Managed Metadata column has terms 2 and 7, something similar to the above would return false, because the list of values does not contain 2 AND 7. If the values were 2, 7, 10, that would return true, because the list of values does contain all of the terms in the column.