Records Retention Schedule

[mario_rieger]

Dear All,

in our company we are working on the basis of Records Retention Schedules. Enclosed you will find an example:

Records Code: JC-D.5.3   
Records Title: Policy on Business Conduct - Executive Certificate Copies and Required Backup Certificates   
Records Description: Documents maintained by each affiliate company.
Active Document: CY+1   
Inactive Document: 6 or FTA   
Office of Record: Strategic Marketing - Finance - Internal Controls

What is to do to integrate in Alfresco the Retention Period for the Active Document (in this example: Current Year + 1 year) and second for the inactice phase of the Document (6 further years).

After that period the document has to be deleated.

Thank you for your help.

Mario

[derek]

Hi,

Create a quartz-activated job (see scheduled-jobs-context.xml) that gets the NodeService and SearchService injected.

Search for the active documents using a Lucene query against the workspace://SpacesStore and just call delete for each match found.  Remember that your search can be limited to date ranges based on the creation date.  If you want to base the deletion on last-access time, then you'll need to make use of something like the ContentHitsAspect from the SDK CustomAspect sample.

Do the same against the archive://SpacesStore and delete where appropriate.

A forge project would be a good place to host the code.  Alternatively, supported customers can normally get these sorts of features pushed in without too much trouble.

Regards