Hello All,
can anyone advise how to get the sql view in record list
Discussion posts and replies are publicly visible
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?
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.
Create a CDT from that table and add it to your datastore. Then you can select that datastore entity as a record source.
Yes CDT is created and published. But its not appearing in source.
Is there an admin controls here?
What about the datastore?
You have to disable data sync in the wizard when you create that new record. Then you can select the datastore and your entity.