Skip to main content
Known Participant
Dec 27, 2022 11:17 AM UTC
Question

DB view in record list

Hello All,

can anyone advise how to get the sql view in record list

    5 replies

    stefanhelzle0001
    Brainy
    Dec 27, 2022 11:49 AM UTC

    You can create a record on top of a database view when you disable data sync in that record. Do you have any specific question?

    rupaa0642Author
    Known Participant
    Dec 27, 2022 11:52 AM UTC

    Yes, I have a view created getting the data from multiple tables. I wanted to create a record and show list of columns from that view.

    In the record data section is giving me an option of tables, not views.

    stefanhelzle0001
    Brainy
    Dec 27, 2022 11:54 AM UTC

    Create a CDT from that table and add it to your datastore. Then you can select that datastore entity as a record source.