Question
Radial
IN
Last activity: 24 Jun 2022 5:43 EDT
Save Page list to DB with out looping
My requirments is to save to page list to DB with out looping the List.
i tried Commit over the list but recods not adding. and Obj save over list is not excepting.
Please let if there are alternates.
***Edited by Moderator Marije to add Capability tags***
ING Bank N.V.
NL
@yuvasaivarunmCan you share the screenshot of the code you wrote ? When you are inside the loop, you need to get the full instance by doing an Obj-Open first, and then do a obj-save on it.
Just doing a Obj-Save on the looped page will not work.
Radial
IN
Hi @VTALUKDAR
- I'm calling a Data Transform in a an Activity.
- In Data Transform im forming a Page List and I could see all data formation is happening as expected in the tracer. Can we save page or Page List to Db from Data Transform.
- After execution of Data Transform in the Activity i added Obj-Save over the page list, this is throwing the error as below.
| Step Status Info |
Cannot open or save instances of class Code-Pega-List--the class might be abstract, or it might have no defined keys, or it might descend from Code-. |
- My Goal is to save the Existing PageList to DB with out looping.
ING Bank N.V.
NL
@yuvasaivarunm No you cannot : every record which is being saved into the DB needs the record information. Just running an Obj-Save on top of the page list record does not work.
(1) Loop through the Page list in the activity,
(2) Inside the loop, do an obj-open-by-handle and open the instance on a Child Page.
(3) Call the DT , make the necessary transformations directly on the Child Page
(4) In the activity outside the DT, but still inside the loop , call the Obj-Save and save the record.
You can also try using Saveable Data Pages to implement this, but it would be too difficult to explain here.