In Order to fetch records from a DB table is it necessary for the record to be open First?
I have been one scenario on activity like i want to fetch some records with status as processing then i want to update some properties and save it back to the table.
I answered this by saying use Obj Browse using pyStatusWork==Processing in filter first then looping through the pagelist.pxResults then adding a property set for updating the record and call commitwithErrorHandling.
Can somebody confirm if this is the correct solution or do we need the record to be open first in order to get fetched.
Accepted Solution
Updated: 11 Jun 2023 3:14 EDT
Bits in Glass
IN
@TanyaS58 while doing obj-browse you will be giving . pzinskey as one of the column to fetch. So the records you fetch using obj-browse will have pzinskey in all the pages/records. While looping the list, you will have pzinskey in the context.
Bits in Glass
IN
@TanyaS58 by doing obj-browse you will get the list of cases. But to update the case, yes you need to do obj-open and then save, commitwitherrorhandling.
You will be looping the pagelist which you got by doing obj-browse and then you will be doing open, prop set, save and commit.
Cognizant
IN
@Anoop Krishnajust wanted to know one more thing about this if I am not sure about the class key/instance handle how can I use obj open/obj open by handle?
Bits in Glass
IN
@TanyaS58 obj-openbyhandle by using pzinskey(unique key) of that particular instance and obj-open by using keys(mentioned in the class) of that particular instance.
https://www.pegahelp.com/2020/05/pega-obj-openobj-browse-obj-filter-obj.html
Updated: 8 Jun 2023 13:54 EDT
Cognizant
IN
@Anoop Krishna no i mean when we are not aware of the class key and pzinskey(unique handle)how will we open the record?Neither we are aware of the class name (so we cant use class key)nor we are aware about the pzzinskey in this scenario how to use obj open/obj open by handle
Accepted Solution
Updated: 11 Jun 2023 3:14 EDT
Bits in Glass
IN
@TanyaS58 while doing obj-browse you will be giving . pzinskey as one of the column to fetch. So the records you fetch using obj-browse will have pzinskey in all the pages/records. While looping the list, you will have pzinskey in the context.
Cognizant
IN
@Anoop Krishna Thanks for the solution