Skip to main content
nishthab0001
Participating Frequently
Jan 12, 2023 7:56 AM UTC
Question

Views in Appian

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
    Inspiring
    Jan 12, 2023 8:07 AM UTC

    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
    Participating Frequently
    Jan 12, 2023 9:02 AM UTC

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

    konduruc733182
    Inspiring
    Jan 12, 2023 9:33 AM UTC

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

    richardm900458
    Inspiring
    Jan 12, 2023 9:38 AM UTC

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

    richardm900458
    Inspiring
    Jan 12, 2023 9:40 AM UTC

    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?