I have a CDT that maps to a table. The CDT and the table has an ID column. Is th

guozhangy over 10 years ago

I have a CDT that maps to a table. The CDT and the table has an ID column. Is there a way to insert a new row into the table using CDT with the ID value pre-assigned (suppose I want insert a row with ID=100). The Appian document only uses @GeneratedValue for the ID column. Is there any other annotation, such as @assigned...

Discussion posts and replies are publicly visible

Parents

0 guozhangy over 10 years ago

Thanks for the reply.

I tried that approach, I set the ID of the CDT to 100 (which doesn't exist in the table). A row was inserted into the table, but with different ID. The assigned value (100) was ignore by Appian.

I also tried not to use @GeneratedValue and Sequence for the ID column in my schema file, but then the schema will not be loaded.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 guozhangy over 10 years ago

Thanks for the reply.

I tried that approach, I set the ID of the CDT to 100 (which doesn't exist in the table). A row was inserted into the table, but with different ID. The assigned value (100) was ignore by Appian.

I also tried not to use @GeneratedValue and Sequence for the ID column in my schema file, but then the schema will not be loaded.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data