TaxonomyField and AllowMultipleValues

Question

I understand one cannot filter a list containing a managed metadata field. But if one sets the AllowMultipleValues property of the Taxonomyfield to False, can we then filter a list on that field e.g. "filter when MyTaxonomyField Contains "xxx"?

Answer 1

Hi Premjit,

Based on my understanding, filter in list can be used to Managed Metadata Field. However, the filter type is limited.

If you use Managed Metadata Field in a list, whatever allow multiple values or not, in the view settings page, you can use filter to filter the field, like mmfield is equals to fieldvalue, the filter type: is/not equals to is allowed in this situation, but Contains/Begins with is not allowed in the filter settings.

You can have a check whether it is the issue.

Thanks,

---

Qiao Wei

TechNet Community Support

Answer 2

Thanks Qiao.

I have tested your answer. Say I have a calendar item and the metadata field is tagged with two entries e.g. Donkeys  and Horses.

If I filter the view on the metadata field and say "is equal to" Donkeys this indeed works.

I think the terminology is confusing though? Because to me "is equal to" means the value of the field is exactly equal to and in the example I give above this is not the case (the value would be Donkeys;Horses")

Thanks

Premjit

Answer 3

Hi Permjit,

Thanks for posting back.

For the look up columns like People and Group field, Managed Metadata field, this is the by design result. for example, we have a Meta field or People and Group field, which allow multiple values, when set filter on this field, mmfield is equals fieldvalue, then items with mmfield values contains fieldvalue will be filtered.

Thanks,

---

Qiao Wei

TechNet Community Support