document life cycle

[kalyanakumarr]

Dear Forum Members,
A document (odt or ooxml) need to be made from the Table in the Postgresql.
After approval the document is said to be in Active state.
The document will be modified and again stored in the Postgresql.
Now document is said to be in Modify state.
Then it becomes Active state after approval.
After 6 months the document will be deleted.
If required the deleted document could be brought back to active state.
The solution need to be java based.
How to achieve this by the Alfresco ?

Kindly guide me how to go about. Which technical manual to read?
Once path is known I will do my homework to arrive at the solution.

[steven_okennedy]

Hi kalyanakumarr,

I assume that when you're referring to Postgres that you mean the document needs to be created/stored in the Alfresco repository? (Alfresco actually only stores document metadata in its database and content in a filesystem-based content store). 

The steps you mention below would suggest that you want to create a workflow which will handle the state changes that your document goes through (possibly needing some custom metadata) followed by a custom scheduled action which will handle the regular checking for documents that are 6 months old and deleting them (although if you want to bring them back deleting them might not be the best idea! Better to move them to a location that is not visible to users you don't want to see it and allow your admins/power users to move it back if necessary. Alfresco does provide a "recycle bin" idea accessible through the user profile screen as well though where deleted items can be recovered from if do want to go deleting them).

Best place to start reading would be Jeff Potts' developer series (http://ecmarchitect.com/alfresco-developer-series) especially the ones on content modelling, actions and workflow.  For scheduled actions the wiki page gives some examples and explanation(http://wiki.alfresco.com/wiki/Scheduled_Actions).

Regards

Steven
More generally, the official docs (http://www.alfresco.com/resources/documentation) or the wiki (http://wiki.alfresco.com/wiki/Main_Page) are good places to find info

[leont3557]

:shock: