Querying the Data from Views

That sounds fine - do you have any particular question?

Yeah. Thanks for your response.

Please refer to the structure of the tables that I gonna use to create a View using Join operation.

Student Table:

Pass_Request_Details Table:

Pass_Data View:

My question is how to query this data (from above mentioned View) and use it in our appian application like in Interface, Reports etc. Thanks for your help.

Hi,

You can Create CDT for the view similar to how you create for a table and map it to the data store. Then you can query using a!queryEntity(). Querying is pretty much same how you can do with tables except write operations.

Similar to how you query from a regular table, Views are also queried by creating a CDT and Data Store Entity mapping to the view.  The one word of caution I would give you is to make sure you construct your View such that your primary key column is actually unique.  If it's not a unique value, funny things will happen when you query on the view, relating to the count of items it contains.

Sure. I will do. Thank you.

Thanks for your information. I will do it.

while i am creating CDT from a view the CDT  is being created all good but the mapping to data store is not happening and i can't seem to find why? can you please help me??

More details please. What went wrong? Any error messages? Did you try to add the entity manually to the DS?

yes stefan, I have created a view from two of my tables and then i tried to create a CDT from view, but even after selecting the check box that lets you to crate an Entity for the Data Type, Its not able to create an Entity. and is showing an Error that states   

"""

You need to open the draft datastore and try to validate it. It will probably see an error, click on the more option to see details of the error, and write it back here.