Skip to main content
New Participant
Aug 21, 2023 9:31 AM UTC
Question

How to Map a "custom data Type" field from Postgresql to Appian CDT

Hi All,

Can you advice  how can I map the "status" field with a custom datatype on the table to Appian CDT? I tried using the Text/String but when verifying on the Datastore, "No match tables found"

- Data type on the Table

- Creating CDT from Table

- Error upon Verifying on DataStore

3 replies

stefanhelzle0001
Brainy
Aug 21, 2023 11:30 AM UTC

I think you will have to create a view in DB and align the data types to the ones Appian supports.

mathieud0001
Genius
Aug 21, 2023 11:30 AM UTC

AFAIK, Appian does not support DB custom data types.

tomj8549Author
New Participant
Aug 22, 2023 1:58 AM UTC

Thank you guys, for the development of this ticket I also filed for another one which is also connected to this one. community.appian.com/.../unable-to-map-the-other-schema-from-recordtype