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
7 replies
Subscribers
9 subscribers
Views
6951 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
General
CDT Mapping Primary Key and Foreign Key
Ravi Roshan
over 8 years ago
I have a main table say ABC which has ID column as primary and identity. I have another table DEF where I have another column say CASE_ID which is both primary and foreign key but not the identity. In the second table DEF I have provide the reference as ABC.ID.
I have mapped the second table CDT DEF in CDT ABC, however while verifying the Data Store, I am getting the error "The data source schema does not match the type mappings: Missing column: CASE_ID in dbo.ABC (APNX-2-4056-000)"
My Requirement is to map the second table as @OneToOne Relationship with first table. Please find some screenshots for reference in attachment.
Please provide any solution for this. Thanks
OriginalPostID-261496
Discussion posts and replies are publicly visible
Parents
0
sanjays0006
over 8 years ago
Ravi, the screenshot is from the 1st table CDT?
If yes, then you should write the Join on the ID column(element name is secondcolumn here) as you mentioned right?
Can you provide the element declarations from both the CDT's so that we can have a look?
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Reply
0
sanjays0006
over 8 years ago
Ravi, the screenshot is from the 1st table CDT?
If yes, then you should write the Join on the ID column(element name is secondcolumn here) as you mentioned right?
Can you provide the element declarations from both the CDT's so that we can have a look?
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Children
No Data