Skip to main content
Participating Frequently
Jul 6, 2023 4:38 AM UTC
Question

Data Store Entity Mapping With View

I am Facing Some Issues While Mapping Data store entity.

I have created a view by joining three tables, and I obtained the exact data. Then, I created a CDT (Custom Data Type). However, when I attempted to map it into a data store, it failed and displayed an error.

    2 replies

    stefanhelzle0001
    Brainy
    Jul 6, 2023 6:07 AM UTC

    I suggest to check the DDL Appian created and adapt the CDT and/or the view to match each other.

    mathieud0001
    Genius
    Jul 6, 2023 9:40 AM UTC

    Did you try creating the CDT by using the "Create from database table or view" option?

    [View:https://docs.appian.com/suite/help/23.2/Mapping_CDTs_to_Pre-defined_Database_Tables.html]