Pega activity for updating records in database
Hello everyone,
I have written one activity that is to fetch the records and to update the records and save it back with update values say for nearly 100-200 records,now using obj-open method i am able to get a single record and update it that is working fine but not able to get all records at the time as obj-open return single record only,so i tried to browse all records using obj-browse with pzInsKey and the immediate next step is obj-open by handle to which i am passing pzInsKey to loop(reference:-Saw the same article on pdn)but with that also when i passed particular key that worked fine but was not able to loop through all records at the same time.
can anyone suggest mewhere i am going wrong,how to work this out,any help Appritiated.
Regards,
Aakash Talreja
***Edited by Moderator Marissa to update categories***
Accepted Solution
Pegasystems Inc.
US
This could be one way of doing it. In step 2, I loop through the embedded pages and copy the pzInsKey from BrowsePage.pxResults(<CURRENT>) into a local variable.
Personal
IN
Thanks CarissaW_GCS for solution
Hii,
I tried on same steps you described,And now able to even loop through all records and i got expected results
Thanks you very much:)
Pegasystems Inc.
US
Yes, the local variable is defined on the Parameters tab. What do you see for the values when you trace?
Rabobank
SE
Hey Aakash ,
Obj-Open / Open by handle both will open "A" particular record, which means you will get only one record opened.
If you try top open the record inside a loop and update it, all the records fetched will be opened and updated.
Check how many records are getting fetched in the browse.
-sarath