How is the content tied to the workflow object?

[prachi379]

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 this reference?
- In workflow-form.get.html.ftl, there is a comment which says the 'Items' section will be loaded through ajax. Where can I find the code which loads the 'Items' section on the workflow/task details page?


Thanks!

[mlagneaux]

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.

[prachi379]

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!