Skip to main content
V
victoriab0001
January 25, 2022
Question

SQL VIEW record

  • January 25, 2022
  • 2 replies
  • 0 views

Hey everyone, 

I created an app where I builded a record and used records relationship to easy access to data from related records. Now I wanted to rebuild the record to use SQL View instead of records relationship. 

Where shoul I start

    2 replies

    gopalk2865
    gopalk2865
    Participating Frequently
    January 25, 2022

    hi victoriab0001, if you want to crate a recordtype from database view then , you will  be able to create with sync disabled.

    stewart.burchell
    stewart.burchell
    January 25, 2022

    Hi Victoria - related records effectively mimic SQL Views. So you'd want to use the same concept to relate the underlying tables in the same way that you do the records. You'd need to familiarize yourself with the syntax for creating a SQL View. Once you have the SQL View you can then point Appian at it to create a CDT based upon that View, just as if it were a SAL Table. Note: Appian CDTs require a Primary Key (of a Primitive Type) so you'd need to ensure you VIEW included a column for this purpose.

    Terms & ConditionsAccessibility statement