I am trying to create a nested CDT with one-to-many relationship for two existin

giridharn over 9 years ago

I am trying to create a nested CDT with one-to-many relationship for two existing tables and I am having difficulty making it work the way I wanted to. Hope someone can help me with this. The child table in this case has index based on two primary keys.
--- Customer table ---
ID (Primary key)
Name

--- Groups table --- (Primary keys Group_Id, Customer_ID)
Group_Id
Group_Name
Customer_ID

When I use write to datastore, one row is inserted/updated in the parent (expected) and only one row is being inserted/updated in the child table. Please see attached xsd

Appreciate any help

customer.xsd

Discussion posts and replies are publicly visible

Parents

0 giridharn over 9 years ago

Eliot, Never mind..I read in the documentation that write to datastore with composite keys is not possible unless you have column with unique values. So I settled for using query database node instead of write to datastore.

forum.appian.com/.../Database_Schema_Best_Practices.html

Thanks
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 giridharn over 9 years ago

Eliot, Never mind..I read in the documentation that write to datastore with composite keys is not possible unless you have column with unique values. So I settled for using query database node instead of write to datastore.

forum.appian.com/.../Database_Schema_Best_Practices.html

Thanks
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data