Skip to main content
Known Participant
July 25, 2022
Question

how to add db view in Interface

  • July 25, 2022
  • 2 replies
  • 3 views

I have created a view by joining two tables in my database.

I have added the view into the appian datastore,  when i click on save and publish, im getting the below error.

    2 replies

    stefanhelzle0001
    Brainy
    July 25, 2022

    It seems like the view does not perfectly fit the CDT. Could it be that there is no primary key defined?

    Known Participant
    July 25, 2022

    i hve added primary key in view..it is working..thanks u