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 Eliot Gerson
Appian Employee
over 9 years ago

What RDBMS are you using? Can you attach a screenshot of the structure of the tables or the SQL script to create the tables? You mention that you are writing to two existing tables. What was the structure of the tables prior to the creation of the nested CDT?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 Eliot Gerson
Appian Employee
over 9 years ago

What RDBMS are you using? Can you attach a screenshot of the structure of the tables or the SQL script to create the tables? You mention that you are writing to two existing tables. What was the structure of the tables prior to the creation of the nested CDT?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data