Question
Obj_Browse & Obj-Save
Hi - I need to retrieve a lot of rows from one table and Update it to another table after changing/working on the data.
What is a good way to do it?
I can use an Obj-Browse to retrive the data into a DBTable property (Code-Pega-List) . Then I also have another property DBTable.pxResults which holds the results.
I am not sure how I can process the DBTable.pxResults and transform it into records that a Data Table expects. I also need to save this new Data Table records into Pega.
Can I pass this DBTable.pxResults into a Data Transform & work on it ? If so how will I return the output objects list to the calling activity so that it can be saved?
Thanks,
Smitha R
Hi Smitha,
1) Do a page copy of DBTable.pxResults into another page of different class and that class should mapped to the your another table.
2) Perform transformations on the another page and save the results to the table using Obj-Save.