Create View using Sync Record Tables

Question

I have 3 different Records and respective tables where SYNC is enabled. 
 Now, i want to create a view on top of these 3 tables and export to excel or use it any other workflow. 
 I am not planning to query view using queryentity or queryrecord etc but i use SQL Statement to get required data and populate on excel in PM. 
 If not view, I am left with stored procedure which is the least option in the list. 
 Question : Can i create view on top of synced records/tables in first place? All the resources says that i cant (if i query on it using queryentity or queryrecord) or in general etc.. 
 If not what is the work around?

Mathieu Drouin · Answer

You can create a view on any tables even if they are synced in Appian. 
 You just won't be able to create a Record from that view.

juergeng0002 · Answer

Creating a view of synced records is possible. There is only one restriction to consider: If you have defined custom fields for those records, they are not reflected in the database tables and therefore not included in the view.

Peter Lewis · Answer

Yeah you can use the edit list or you can just create a grid and put it on any interface: docs.appian.com/.../read-only-grid-configuration.html . You can pull back related data as well by just specifying the related fields you want to use.