Skip to main content
nishthab0001
nishthab0001
January 12, 2023
Question

Views in Appian

  • January 12, 2023
  • 6 replies
  • 0 views

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

    6 replies

    konduruc733182
    konduruc733182
    January 12, 2023

    Hello nishthab0001,

    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

    nishthab0001
    nishthab0001Author
    January 12, 2023

    We have only readonly database cannot add any column in that.

    konduruc733182
    konduruc733182
    January 12, 2023

    Not sure then if it is possible. Can you try to edit the XSD of your CDT?

    richardm900458
    richardm900458
    January 12, 2023

    are you working with records or CDT/Data store in this context?

    richardm900458
    richardm900458
    January 12, 2023

    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?

    Terms & ConditionsAccessibility statement