Views

A view in Database is a searchable object in that is defined by a query. It does not stores any data but retrieves data from more than one table at run time creating a virtual table and returning the variety of data in the defined format. It is created using Joins. When talking about views in Appian, it, at the first glance does not exists but we can create one by querying more than one table and then formatting the data retrieved from multiple tables using Appian dictionaries.

I hope this answers your question.

- Harshit

A view in Database is a searchable object in that is defined by a query. It does not stores any data but retrieves data from more than one table at run time creating a virtual table and returning the variety of data in the defined format. It is created using Joins. When talking about views in Appian, it, at the first glance does not exists but we can create one by querying more than one table and then formatting the data retrieved from multiple tables using Appian dictionaries.

I hope this answers your question.

- Harshit

when we use view and when we use table?

if you want data from different table using joins you can create view accordingly create CDT and use it in appian.

Need data from single table go with table.