Appian Community
Site
Search
Sign In/Register
Site
Search
User
DISCUSS
LEARN
SUCCESS
SUPPORT
Documentation
AppMarket
More
Cancel
I'm looking for ...
State
Not Answered
Replies
4 replies
Subscribers
8 subscribers
Views
2305 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
General
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
OriginalPostID-167656
OriginalPostID-167656
Discussion posts and replies are publicly visible
Parents
0
giridharn
over 9 years ago
Eliot, The database is Oracle. The tables and CDT are sample and not actual tables. We cannot change the structure of these tables as these are used by multiple applications. So the structure is the same before and after CDT creation. Thanks for your response
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Reply
0
giridharn
over 9 years ago
Eliot, The database is Oracle. The tables and CDT are sample and not actual tables. We cannot change the structure of these tables as these are used by multiple applications. So the structure is the same before and after CDT creation. Thanks for your response
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Children
No Data