Views in Appian

Question

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

Mike Schmitt · Answer

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.

Konduru Chaitanya · Answer

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

Views in Appian

Top Replies