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
Thank you , I was able to save it.
I have another question on the same lines.
1) There are 100 rows in one table . (Table 1) One of the fields is USER_ID
2) In another data table I have user id vs Employer mapped . (Table 2) . So this Table has two columns 1) USER_ID 2) EMPLOYER
3) I need to Update Table 1 with the corresponding EMPLOYER Name from table 2.
My confusion here is coz I have one DBTable.pxResults in Step 1 & another DBTABLE1.pxResults from Step 2.
I need to iterate through Table 1 , and then I need to iterate through Table 2 to find the corresponding Employer.
What is a good way to do this?
Thanks,
Smitha R
use sql join, you will have one result from both the tables, and you can determine which record easily.
Hi , I used report definition to join the tables instead of iterating them .
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.