Trying to map a CDT to a view in my database. XSD attached. When I attempt to cr

John Stretton over 8 years ago

Trying to map a CDT to a view in my database. XSD attached. When I attempt to create a data store entity for this CDT, Appian wants to execute the following line in a DDL script:

add aid numeric(19,0) not null;

Obviously this fails because you can't add a column to a view. What am I missing? How can I get Appian to stop trying to add this column?

RFP_DeadlineAlerts.xsd

Discussion posts and replies are publicly visible

Parents

0 rawich over 8 years ago

@johns222, Appian is trying to add primary key to your view (but Appian doesn't know that and it assumed, it's a table).
One workaround to this is to create your view with primary key from original table as well, and mark it as primary key when you create the CDT.
If you have no control over the view definition, you'll have to define composite primary key by modifying the XSD directly and use @Id in the annotation of multiple columns.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 rawich over 8 years ago

@johns222, Appian is trying to add primary key to your view (but Appian doesn't know that and it assumed, it's a table).
One workaround to this is to create your view with primary key from original table as well, and mark it as primary key when you create the CDT.
If you have no control over the view definition, you'll have to define composite primary key by modifying the XSD directly and use @Id in the annotation of multiple columns.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data