https://wiki.smt-x.com/index.php?action=history&feed=atom&title=Query_approver_votes_of_approval_steps 2026-04-04T00:48:58Z Revision history for this page on the wiki MediaWiki 1.44.3 https://wiki.smt-x.com/index.php?title=Query_approver_votes_of_approval_steps&diff=564&oldid=prev 2022-05-19T13:00:10Z

<p></p> <table style="background-color: #fff; color: #202122;" data-mw="interface"> <col class="diff-marker" /> <col class="diff-content" /> <col class="diff-marker" /> <col class="diff-content" /> <tr class="diff-title" lang="en"> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Older revision</td> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Revision as of 15:00, 19 May 2022</td> </tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l1">Line 1:</td> <td colspan="2" class="diff-lineno">Line 1:</td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>The query below retrieves all approvers and their votes for a provided ticket id</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>The query below retrieves all approvers and their votes for a provided ticket id</div></td></tr> <tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>  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]</div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>  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] <ins style="font-weight: bold; text-decoration: none;">is </ins>on pis.[ProcessInstanceId] = pi.[Id] and pis.[TypeId] = 4 left outer join [ProcessInstanceStepActor] pisa on pisa.[ProcessInstanceStepId]=pis.[Id] and pisa.IsDisabled = 0 left outer join [ProcessISInstanceActor] pisia on pisia.[ProcessInstanceStepActorId]=pisa.[Id] inner join [ProcessInstanceStepLanguage] pisl on pisl.ProcessInstanceStepId = pis.[Id] and pisl.LanguageId = 1 where pi.[Id] = 2744</div></td></tr> <tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>from [ProcessInstance] pi</div></td><td colspan="2" class="diff-side-added"></td></tr> <tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>left outer join [ProcessInstanceStep] <del style="font-weight: bold; text-decoration: none;">pis </del>on pis.[ProcessInstanceId] = pi.[Id] and pis.[TypeId] = 4</div></td><td colspan="2" class="diff-side-added"></td></tr> <tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>left outer join [ProcessInstanceStepActor] pisa on pisa.[ProcessInstanceStepId]=pis.[Id] and pisa.IsDisabled = 0  </div></td><td colspan="2" class="diff-side-added"></td></tr> <tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>left outer join [ProcessISInstanceActor] pisia on pisia.[ProcessInstanceStepActorId]=pisa.[Id]</div></td><td colspan="2" class="diff-side-added"></td></tr> <tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>inner join [ProcessInstanceStepLanguage] pisl on pisl.ProcessInstanceStepId = pis.[Id] and pisl.LanguageId = 1</div></td><td colspan="2" class="diff-side-added"></td></tr> <tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>where pi.[Id] = 2744</div></td><td colspan="2" class="diff-side-added"></td></tr> </table>

Smtxwiki https://wiki.smt-x.com/index.php?title=Query_approver_votes_of_approval_steps&diff=563&oldid=prev 2022-05-19T12:59:37Z

<p>Created page with &quot;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...&quot;</p> <p><b>New page</b></p><div>The query below retrieves all approvers and their votes for a provided ticket id<br /> 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]<br /> from [ProcessInstance] pi<br /> left outer join [ProcessInstanceStep] pis on pis.[ProcessInstanceId] = pi.[Id] and pis.[TypeId] = 4<br /> left outer join [ProcessInstanceStepActor] pisa on pisa.[ProcessInstanceStepId]=pis.[Id] and pisa.IsDisabled = 0 <br /> left outer join [ProcessISInstanceActor] pisia on pisia.[ProcessInstanceStepActorId]=pisa.[Id]<br /> inner join [ProcessInstanceStepLanguage] pisl on pisl.ProcessInstanceStepId = pis.[Id] and pisl.LanguageId = 1<br /> where pi.[Id] = 2744</div>

Smtxwiki