2 Replies Latest reply on Jun 28, 2017 7:28 AM by Guy Edkins

    What table(s) in EPDM holds the approvals that have been made or not for a parallel transition.

    Guy Edkins

      I want to query on SQL directly for the names that have signed (or not) for a file in a given state that is entering a parallel transition where multiple signatures are required. What table(s) in EPDM holds the approvals that have been made or not for a parallel transition.

        • Re: What table(s) in EPDM holds the approvals that have been made or not for a parallel transition.
          Steve Ostrovsky

          Not 100% sure about the Parallel transition, but you'll need the Documents, Status, TransitionHistory, Transitions and others. This might get you started:

           

          Select p.path 'Folder Path', d.filename 'File name', th.transitionnr 'Transition #', t.name 'Transition Name', u.username 'Transitioned By',

            th.comment 'Transition Comment', CONVERT (VarChar, th.date, 101) 'Date of Transition' , s.name 'Current Document State'

          From Documents d

          /** DocumentsInProjects lists all of the documents that are in a project. It does not list the project names.

          You need to join the Projects table if you want the folder names and paths **/

          Inner join DocumentsInProjects dp on d.documentid = dp.documentid

          Inner join Projects p on dp.projectid = p.projectid

          Inner join Status s on d.currentstatusid = s.statusid

          /** TransitionHistory lists all of the documents that have gone through a workflow transition. It does not list the Transition names.

          You need to join the Transitins table if you want the Tranistion names**/

          Inner join TransitionHistory th on d.documentid = th.documentid

          Inner join Transitions t on th.transitionid = t.transitionid

          Inner join Users u on u.userid = th.userid

          Where (d.deleted = 0) and (d.ObjectTypeId = 1)

          Order by d.filename, th.transitionnr