Hi
I want add or complete data in a text fields in an interface (image below) to update many rows of my db at one go, instead of updating one by one or row by row
For example, complete the form interface (image above) to update 5 rows at one go... this rows of my db
which would be the best practice or help me with examples?
please help
Discussion posts and replies are publicly visible
Hi,
You can create a process model (generic process so that we can use the same anywhere we want) that contain a UIT and a Write to details process model (see below pic).
And what you only have to do, you have to pass the selected grid data (as we know we can hold the selected data in a local) on clicking the button from your above interface to the generic process model UIT and then you can update that data in the editable grid.Then after updating the data on clicking submit your updated data will go to write in the db.Thank You.
I hope the above solution will help you to update your data.
Hi Ravis420
As you said i will create 2 interfaces
1. the first for the selectable read only grid and save the selected rows in a local variable...
how i save that selected rows in a local variable?
2. the second for the editable grid for selected rows
how i call the selected rows in this interface?
Hi, I guess you have to create only one interface as you already have the below interface, right?
And then you have to pass the selected ids ( you can take help from below link) into the above process model that I have sugested.docs.appian.com/.../grid-with-selection-pattern.htmlAnd Secondly, "how i call the selected rows in this interface?"^^ , you can fetch the data using query entity by passing the ids in the filters, and please use dynamic paging if you are calling more then 15/20 rows.
Also to call that process model you can create a button using cardLayout and in link parameter of cardLayout you can call the process model and paas the selected ids.