Using colons in picklist we can construct hierarchical picklists for use in the ManTra UI. This is a very valuable feature because it allows us to control the combinations of values a user can select and ensure these combinations are valid.

The underlying TMS attribute field continues to have a character limit of 50. This is often not enough to support the hierarchical picklists for ManTra.

A customer is looking to map its Taxonomy into a 3-level hierarchical picklist. Most of the resulting picklist entries exceed the 50 character limit, with the character counts as high as 84.

Usability of the hierarchical picklists would be improved if the character limit was increased, e.g. by allowing Picklist as a UI Control option for Data Type nvarchar(255).