Question
Anthem Inc
US
Last activity: 3 Aug 2018 9:17 EDT
OBJ-Browse Retrieves Same Set of results
Hello All,
I have a requirement to fetch 1000 records at a time, open each workobject, and update few properties under pyWorkpage which are not exposed.I have included a wrapper activity to call the obj-Browse activity to retrieve 1000 records and update them individually. But the problem is I'm getting the same set of 1000 results every time the obj-Browse is being called. So, to avoid this I have added logic in Obj-Browse to fetch records which have pxUpdateDateTime is less than first record pxUpdateDateTime. But, for each workobject the pxupdateDateTime is not getting updated on commit. Is there any way to fetch different 1000 set of results on each obj-Browse?
Accepted Solution
Pegasystems Inc.
IN
Hi Santosh,
Below are few suggestions that you can try.
1. First Option:
- In the activity, before obj-browse add a step to set a property (say tempdatetime) to pxcurrentdatetime.
- Then in Obj-Browse add the filter condition that pxupdatedatetime < tempdatetime.
- Then update the pxupdatedatetime with for the properties which you are updating with pxcurrentdatetime.
- Note that the obj-browse should be in loop(as in each iteration you want to fetch 1000 records) and not the property-set step of the tempdatetime.
2. Second option:
- Add a flag property(true/false) for each work object.
- By default all values should be set to false.
- while doing Obj-Browse add filter condition with the flag property == false.
- while updating the property update this flag value to true.
Hope this helps you.
Regards,
Vikash