You're on your way to the next level! Join the Kudos program to earn points and save your progress.
Level 1: Seed
25 / 150 points
1 badge earned
Challenges come and go, but your rewards stay with you. Do more to earn more!
What goes around comes around! Share the love by gifting kudos to your peers.
Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!
Join now to unlock these features and more
we need to delete automatically issues archived after 1 year to clean up database .
the solution we find is:
*restore issues one by one then delete them.
this solution take a lot time.
we need clear the caches of the archived issues overall.
(notice: we don't want restore and delete ,again and again..)
thanks for your response.
I'd like to explore why you think you want to "clean up the database"?
Archived issues do not have a significant impact on your use of the system. They don't appear in searches or reporting unless someone is explicitly asking for archived issues. You won't get any increase in performance by deleting them because they're not actively included in anything day-to-day. The data behind them is tiny, if you're worrying about disk space on the database server (attachments are different if you're trying to regain space on the server's disk)
What are you actually trying to achieve by doing this?
hi Nic - from our point of view, it's basically a legal issue. GDPR includes a 'right to be forgotten in Article 17 whereas an archived issue can still be opened if a user has a direct link to it. So the only way to be compliant with law is to physically delete the archived issue after a certain amount of time...
I don't think you've quite understood the law. There is, exactly as you say, a right to be forgotten, but there are two caveats on that (which I'll try to do in plain English instead of "legalese")
The only way to be compliant with the law is to retain the tracking information. GDPR does not give you any rights not to be held responsible.
Even with GDPR, you waived your "right to be forgotten" when you signed up to do your job.
However, you can be anonymised. As long as enough data is kept to eventually work out your responsibility (and only by those that you agreed to), you can be mostly forgotten.