CAML query of a managed metadata field

Question

CAML request returns [object Object] for a field that contains managed metadata. How does that get converted to a value that can be display on the web. For example, I know that a lookup field requires a .get_lookupValue() but I don't know how to handle a managed metadata field.

Assistance greatly appreciated.

Thanks

Answer 1

There are 2 methods to query a list/library that contains a managed metadata column:

1. Query against Term Name
2. Query Against WSSID

Method 1 (will look something similar to this):

 query.Query = @"<Where>
                  <Contains>
                      <FieldRef Name='" + MyTaxonomyFieldName + @"' />
                      <Value Type='Text'>" + tagName + @"</Value>
                  </Contains>
                </Where>";

Method 2:

query.Query = @"<Where>
                  <In>
                   <FieldRef LookupId='TRUE' Name='" + MyTaxonomyField + @"' />
                    <Values>
                       <Value Type='Integer'>" + tagLookupID + @"</Value>
                    </Values>
                  </In>
                 </Where>";

it is recommended to use the second method to avoid situations where the term name is used under different term groups!