SQLSever All User Defined Data types become Boolean in DreamFactory

[RobDeVos]

I use SQL server (was 2012 now 2016) and "user defined data types", when I create a view based on a table that have fields that use a "user defined data type" and look at the schema of the view in DreamFactory they all have become Booleans. The work around is to convert the field to a char or other data type, but then the view can only be read it can not be updated.

[RobDeVos]

any progress on this issue?

[leehicks]

Does the table schema through DreamFactory show up as booleans as well as the view? Do you have an example user defined data type that we can test against?

[RobDeVos]

An example: -- Create User define datatype called DF_DataType CREATE TYPE [dbo].[DF_DataType] FROM [int] NOT NULL GO

-- Create table with 1 column using the user defined datatype DF_DtatType CREATE TABLE [dbo].[DF_table]( [DF_field] [dbo].[DF_DataType] NULL ) ON [PRIMARY]

GO

I Hope this is what you were looking for.