Query approver votes of approval steps: Difference between revisions
Jump to navigation
Jump to search
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..." |
No edit summary |
||
| Line 1: | Line 1: | ||
The query below retrieves all approvers and their votes for a provided ticket id | 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] | 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] is 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 | ||
from [ProcessInstance] pi | |||
left outer join [ProcessInstanceStep] | |||
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 | |||
Latest revision as of 15:00, 19 May 2022
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] is 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