Hi Guys,
I gonna write a "Join" query & create a "View" on it. Now, I want to query the data from MySQL's "Views" & use it in my Appian application. Thanks in advance.
Discussion posts and replies are publicly visible
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.