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
5 replies
Subscribers
7 subscribers
Views
3169 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
General
What is the annotation used to map a composite key (combination of more than one
nimishan
over 8 years ago
What is the annotation used to map a composite key (combination of more than one column used to identify the table) in xsd?
Also, what is the annotation for mapping a View in database?
OriginalPostID-207203
OriginalPostID-207203
Discussion posts and replies are publicly visible
0
Tim
Certified Lead Developer
over 8 years ago
Some information in this recent post should help...
forum.appian.com/.../e-202003
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
manojj
over 8 years ago
As per my knowledge, Appian does not support composite keys directly, may be if you can find any other single column which will uniquely identify a record in the table?
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
manojj
over 8 years ago
and for your view annotation, there is no separate annotation for view, it is treated in a same way as table by Appian, just make sure that all the data-fields and type matches properly in the CDT. I am not sure if that's a requirement but I also maintain the sequence of the table column and CDT mapping.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
atulp
over 8 years ago
Just make sure the view has unique column which needs to have annotation as @ID
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
SANTOSH S KUNDLIK
A Score Level 2
over 8 years ago
You should use @Table same as for database tables, view need to be created in DB with 1 unique column, need to have same or more column in View, need to hsve same name as you mentioned in @ Table annotation.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel