Hi,
Is there any built-in way in K2 to automatically delete records over 6 months old / 1 Year from Smartobjects?
If not, would it be perfectly fine to use SSIS to schedule a daily check to delete records from the tables using SQL commands?
i.e. Delete from table where the timestamp is < dateadd<year -1, getdate sort of thing?
Would this mess up any of the forms or k2 integrity by using SSIS to run some SQL to delete over records from the Smartobject data tables?
Also, the other issue i have is deleting PDFs. I use the PDF Converter tool to save forms as PDFs. These PDFs are stored in a Smartobject. How do I only delete
those PDF records which are over 6 months/1 year. The problem here is that the PDF Smartobject does not have a Timestamp field, just a ID and PDF column. Any ideas?
Thanks
