Topic
1 reply Latest Post - ‏2012-12-04T14:36:41Z by SystemAdmin
SystemAdmin
SystemAdmin
199 Posts
ACCEPTED ANSWER

Pinned topic Process Engine Database - Attachment Information

‏2012-12-04T09:43:33Z |
Hello,

Hopefully a quick question, we have a requirement to use the backend databases for process engine to expose the attachment GUID for a document. There needs to be away to have a relationship between a work item (Completed or not) to a document. I have spent some time on the database tables for the object store and nothing is standing out right away.

Also, is anybody aware of an entity relationship diagram for the P8 database?

Hope you can help!

  • Darren
Updated on 2012-12-04T14:36:41Z at 2012-12-04T14:36:41Z by SystemAdmin
  • SystemAdmin
    SystemAdmin
    199 Posts
    ACCEPTED ANSWER

    Re: Process Engine Database - Attachment Information

    ‏2012-12-04T14:36:41Z  in response to SystemAdmin
    This has been resolved. There is no real relationship diagram, however the infocentre has information. The only way to get a link between the docid and a work item is to use a cooperation to write the attachment docID to a work item data field.

    Cheers

    Darren