• Introducing Dark Mode! Switch by clicking on the lightbulb icon next to Search or by clicking on Default style at the bottom left of the page!

Purge data from custom table


I have a custom table that is being growing exponentially, we need to create a purge process that will delete data based in date calculations(anything that is less than this x date will be deleted). Anybody could recommend the best approach to take in this regard?

Thank you,


Legendary Poster

Just create a UBE over your workfile and it's business view.
You may need an index on the date column in your table, but that depends where you want to delete from maybe.

Select based on your date
Read in each record
Save the key
Delete them using the key
Repeat until it ends