You are viewing limited content. For full access, please sign in.

Question

HierarchyID Data Type problem

Updated January 15, 2017

asked on January 14, 2017

I have sql server Table with HierarchyID Data type Field, i can not add it to external tables in admin console.

i got a message that this data type in not supported?

0 0

Replies

replied on January 15, 2017

Hi Ayman,

If there's no support for the datatype, you could create a view of the table, either excluding the HierarchyID field of converting it to an nvarchar(4000).

CREATE VIEW NewView AS
SELECT convert(nvarchar(4000),myHierarchyID)
FROM table_name

Then you can configure the view as an external table.

-Ben

1 0

replied on January 15, 2017

thank you i already did that, but i only send it in case laserfiche may fix this problem in the future.

0 0

replied on January 15, 2017

No worries.

0 0

You are not allowed to follow up in this post.

Sign in to reply to this post.

Asked January 14, 2017
Updated January 15, 2017
165 views