GUI does not support Hierarchyid

Hi Thinkwise community,

We want to use the data type Hierarchyid. Hierarchyid is very useful for multi-level structures and is better for our performance. Now we use recursive methods but the bigger they get the slower they become and every time something changes you have to recalculate the entire tree.

Unfortunately, this is not possible because the GUI does not support Hierarchyid. I saw a topic with a great solution by Anne Buit. Is it possible that Thinkwise can implemented this mapping?

Thanks!

Solution:

“The hierarchyid is a type that does not have a direct mapping to any internal datatypes used by the technology of the GUI so a conversion must be made to a mappable type whenever this value is loaded into the memory of the GUi (e.g. to nvarchar(4000) and back to hierarchyid).”

Topic:

Support for System Data type - Hierarchyid