Commit changes from a editable column in a repeating grid to the database
I am using a repeating grid in the UI whose columns are dropdown and editable.
This grid is sourced from a page list which is copied from a data page.
It also has a column with a button Save after each row to save the changes to the database.
To commit changes to the data base, on the Save button after each row i am using an event on click- run activity which uses an RDB-Save.
I am using a repeating grid in the UI whose columns are dropdown and editable.
This grid is sourced from a page list which is copied from a data page.
It also has a column with a button Save after each row to save the changes to the database.
To commit changes to the data base, on the Save button after each row i am using an event on click- run activity which uses an RDB-Save.
I use a property-set to get all the properties from the source page list of the grid to BusinessAdminPortalPage and then perfrom a rdb-save with the below connect sql:
The issue i face here is : When i click on the dropdown in the grid column and change the value, then click on save button, the value that is copied to the BusinessAdminPortalPage is the old value, not the changed one.
I tried post value too . It did not work. I did not see the value of the particular column property posted anywhere in the clipboard.
Any suggestions are welcomed.
Pegasystems Inc.
IN
Hello,
Have you configured on change post value for each of the dropdowns?
If not, could you please do so and test.
Thanks,
Gisela
Pegasystems Inc.
US
Hi Anuj,
I guess the page list data should be available in the pyWorkPage as you sourced this grid content with the Page List property which is available in your case.
Also in your activity, you are using the Property-Set method to set the source Page List data into a single Page. I am bit surprised how you are setting the Page list data into a single Page.
Regards
Mahesh
SiXworks Limited
GB
There are a couple of things to check:
- Does your DB table have a BLOB (pzpvStream column)? If it does, an RDB-Save will not work...that method cannot update the BLOB, only exposed columns. The next time you do an Obj-Open it'll bring back the old value from the BLOB.
- Posting the value of the column to the clipboard - As mentioned by Gisela_R, if it isn't populated on the clipboard then it can't be saved to the DB. A "Post Value" on change of the field will ensure this is populated.