How to delete record from the Pega Data table list of records older than 3 days ?
I want to delete all the records which are older than last 3 days with CreateDateTime property
Can anyone please help me with the function which can be given in Obj-Delete method when condition ?
***Edited by Moderator Marije to add Capability tags***
Lventur
IN
Have a data page sourced with report definition. In report definition have your logic to fetch the 3 days older data alone.
Then iterate the data page results and inside loop you can make use of Obj-Delete method to delete the entries. No need to have any when condition for Obj-Delete method, because data page will fetch only the expired 3 days entries alone..
Accenture
IN
Hi @DEEKSHA,
You can use the DateTimeDifference function with the following
@DateTime.DateTimeDifference(@DateTime.addToDate(.CreateDateTime,0,0,0,0),@DateTime.CurrentDateTime(),'D')>3 in your when condition
Areteans Technology Solutions Pvt. Ltd.
IN
@DEEKSHA You can use RDB-DELETE method here to delete the records older than 3 days. Below is the query you can use for this.
DELETE from pegadata.TableName where pxCreateDateTime<(Now()-'3 days'::interval)
Note: The above query was written for postgres database.