Avatar

Correct answer by
Employee Advisor

Hi @sirikambampati 

I would query Delivery and using the Link to Campaign select all the deliveries belonging to Campaign older than 3 years old....

 

BUT YOU CAN'T USE the Delete Action for Deleting deliveries as none of the related entities would be deleted. You MUST put these deliveries on the right deleted status (@deleteStatus set to 2) with a deleted status date (@deletedStatusDate set to current Date). Then these deliveries will be picked up by the normal clean up.

 

2 considerations to take:

  1. Deliveries in the deleted state are kept for 7 days prior being processed
  2. Standard clean up is treating 1,000 deliveries per day, so be also very careful of how much deliveries you put in the Delete state

Hope this helps,

Thanks

Denis

View solution in original post