Query approver votes of approval steps: Revision history

Jump to navigation Jump to search

Diff selection: Mark the radio buttons of the revisions to compare and hit enter or the button at the bottom.
Legend: (cur) = difference with latest revision, (prev) = difference with preceding revision, m = minor edit.

19 May 2022

  • curprev 14:0014:00, 19 May 2022‎ Smtxwiki talk contribs‎ 858 bytes −2‎ No edit summary
  • curprev 13:5913:59, 19 May 2022‎ Smtxwiki talk contribs‎ 860 bytes +860‎ Created page with "The query below retrieves all approvers and their votes for a provided ticket id select pi.[Id], pi.[UniqueReference], pi.[DateStarted] as [ProcessStarted], pi.[DateEnded] as [ProcessEnded], pisl.[Name], pisa.[Email] as [ApproverEmail], pisa.[Name] as [ApproverName], pisia.[DateStarted] as [ApprovalStepStarted], pisia.[DateEnded] as [ApprovalStepEnded], pisia.[DecisionId] as [ApprovalVote] from [ProcessInstance] pi left outer join [ProcessInstanceStep] pis on pis.[Proce..."
Retrieved from "https://wiki.smt-x.com/index.php/Query_approver_votes_of_approval_steps"