Hello Everyone.
I'm trying to find a way to automatically cleanup the repository. The users
will allow me to delete uploads older than 1 year.
I created the following query from watching the database while I selected the
Organize/Uploads/Delete Uploaded File menu option.
SELECT upload_pk,
Hi Ray,
To find the uploads over a year old:
select upload_pk from upload where upload_ts (now() - interval '1 year')
order by upload_ts
You can then take that list and schedule the delete agent on each one of the
upload_pk's with the fossjobs command (man fossjobs).
Unfortunately, you can't
2 matches
Mail list logo
