topic How is the content tied to the workflow object? in Alfresco Archive

How is the content tied to the workflow object?

prachi379 — Tue, 10 Feb 2015 18:22:41 GMT

I am searching for a reference to the document ID in the workflow database tables. I can see a bunch of workflow attributes in the act_hi_varinst, act_hi_detail tables but none of them point to the document the workflow is tied to (or the content url ID). - In which of the database tables can I find

Re: How is the content tied to the workflow object?

mlagneaux — Wed, 11 Feb 2015 09:04:03 GMT

Hi,

The workflow objects are stored in a specific folder called workflow package. You can find workflow packages in the node browser under : workspace://SpacesStore > system > workflow > packages.

I can't make a test right now but perhaps the reference of the workflow package is stored in act_hi_attachment.

Re: How is the content tied to the workflow object?

prachi379 — Thu, 12 Feb 2015 18:36:22 GMT

Just checked act_hi_attachment and while it does have a column for content_id, that table is empty. I do have active as well as completed workflows in my alfresco share. Would you be able to do a check and let me know?

I am trying to display the 'document version' attribute for each document in a workflow on the 'my workflows' page. But so far I haven't been able to figure out where the content IDs for the workflows are stored at back end and also where the front end code to display the 'Items' section is located.

Any help is much appreciated!