Hi,
I have a SQL table which I want to display as my editable table on the interface. Also, I want to give the user an option to edit the data from that for few columns.
I am able to display the table in the site view, but I am unable to add the table into my existing interface, how shall I proceed.
I watched the videos relating to query editor but it did not help.
Also is it possible to query from 2 tables using a foreign key or we need to create views?
Discussion posts and replies are publicly visible
This sounds to me like a use case for an editable grid.
It's not precisely the same as displaying the database table in edit view, similar to what a built-for-purpose database client would do.
You can query the data and display it in an editable grid, a user can edit what you allow to be edited, and then the edits can be submitted back to the database via the write to data store entity smart service, (i.e. Appian writes an update back to the db).
If you have a web-based db client that supports embedding, you could explore the possibilities of using the web content viewer. However, I suspect this will present security consideration you might not like.
I have already created a data store, but I am unable to query the data into the editable grid. What should I mention in the row attribute of the editable grid?
If I write the Query rule, then to it is not working. I think is due to the fact that the query is extracting multiple rows at a time.
Hi Karan,
Please refer the below link which will explain how to create the row attribute.
https://docs.appian.com/suite/help/20.3/Editable_Grid_Component.html
Create the query entity and use it in editable grid for source.