[RedCat]

What is the best way to delete all candidate uploads that are older than 5 years?

Thank you so much!

[RedCat]

Can anyone assist me? Much appreciated?

[petter parker]

I can't!!!

[RussH]

Hi RedCat,

do you mean to delete any candidate that's over five years old?

Best to run a sql query to identify anyone that matches, and then again after you're sure to delete those candidates. There's currently no option in the UI to search and bulk delete.

if you only want bulk uploads over five years deleted, what identifies a bulk upload as opposed ot a manually created one? is there something you can search for?

Finally - are you sure you want to delete them, or would you rather just mark them as inactive?

[RedCat]

Hi Russ,

Thank you so much for your reply.
Due to the enormous size of my OpenCats database I need to delete attachments on candidates profiles (not the entire candidate profile), only the attachments (cvs, etc) they have been uploaded by ourselves or when job seekers register with us via OpenCats.

So I’m wanting to save only candidates details and delete attached that are older than, for example, 5 years. Bearing in mind I’ve been using my OpenCats database for 10yrs+ now.

Thank you so much. I look forward to your response