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
10 replies
Subscribers
7 subscribers
Views
2862 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
General
1- I have created an Oracle DB View using the attached DDL; it is working fine i
mohamedb
over 8 years ago
1- I have created an Oracle DB View using the attached DDL; it is working fine in the DB and it does not have a primary key.
2- I then created the corresponding CDT using the XSD attached.
3- Now, when I try to add the entity representing this view to the Data Store and click Verify I get the attached error message.
Please, advise on how to solve this problem. My end goal is to use this view to fetch data into tables used on my entity backed record that get its information from another table.
view + xsd + error.zip
OriginalPostID-211587
OriginalPostID-211587
Discussion posts and replies are publicly visible
Parents
0
mohamedb
over 8 years ago
@christineh: Agree that an @id is needed by Appian.
@abhinavg712: The trick here is that this view is representing an M-to-N relationship; so it does not really have a primary key.
From a DB perspective, do you have an idea how to add an extra column while creating this view which will be auto-incremented for instance?
Then, it will be easy to add the @id notation while creating the XSD?
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Reply
0
mohamedb
over 8 years ago
@christineh: Agree that an @id is needed by Appian.
@abhinavg712: The trick here is that this view is representing an M-to-N relationship; so it does not really have a primary key.
From a DB perspective, do you have an idea how to add an extra column while creating this view which will be auto-incremented for instance?
Then, it will be easy to add the @id notation while creating the XSD?
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Children
No Data