Question
Eclatprime Digital Private Limited
IN
Last activity: 17 May 2023 9:12 EDT
How to delete multiple records presented in pega datatable in pega 8.7v
Hi Team,
I want to delete the multiple records presented in pega data table at a time.
ING Bank N.V.
NL
@Sai Guggilla Write an activity which will do the following :
(1) Do an Obj-Browse on the table, and the filter would be as per your specification. The columns selected must include pzInsKey of each instance.
(2) Loop through the list of records retrieved, and call Obj-Delete-By-Handle.
(3) Commit the changes, and check the table.
Your requirement should be fulfilled !
Sasi
IN
@Sai Guggilla Hi Sai,
In Activity use Obj-Browse method to browse all the records from db give the require property and class.
2.After browsing our data will be on the pagelist we have to loop that pagelist
3.In that looping we have to open each record by passing the primary key by using Obj-Open, then we will keep that each single record in the single page.
4.We will delete the single record which are in the single page by using Obj-Delete.
5.2,3,4 steps will be looped until the pagelist data ends.
Swedbank AB
LT
What if Obj-browse returns 1000 records. Looping through all of them in Pega will take ages. Is there a batch-delete way of doing it? I.e. you provide conditions similar to how Obj-browse works, and Pega does something like DELETE FROM table WHERE foreign_key='value'?
Link Group
IN
@VykintasT - You can have a DSS which you can compare against Param.pyForeachcount and can exit when the records specified in the DSS is matched.