Hi All,
I got a read only view from Oracle where no primary key column exist but In Appian we have to make some column primary key how can I solve this problem.
Appreciate your help!
Regards
Nishtha
Discussion posts and replies are publicly visible
Hello Nishtha Bhatnagar,
You might need to create a primary key for your view in your DB and then map it.
if you are creating the CDT for the first time in Appian using this view, after establishing a PK in the view you can simply create using the option Create from database table or view
We have only readonly database cannot add any column in that.
Not sure then if it is possible. Can you try to edit the XSD of your CDT?
are you working with records or CDT/Data store in this context?
and just to understand it deeper:are you want to have a DB view which has no PK, that his table structure (as record or CDt) has a PK in appian?
If one of the columns in the existing view is unique, you just use that as your primary key when defining your CDT. If there is no column that's unique in the view, you can create the CDT anyway but certain things won't work right.