Skip to main content
T
tomj8549
August 21, 2023
Question

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

  • August 21, 2023
  • 3 replies
  • 0 views

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
stefanhelzle0001
Brainy
August 21, 2023

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

    mathieud0001
    mathieud0001
    Brainy
    August 21, 2023

    AFAIK, Appian does not support DB custom data types.

      T
      tomj8549Author
      August 22, 2023

      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

      Terms & ConditionsAccessibility statement