Please Share your Product Ideas with us!

Zen Desk #6812: We had a situation at SpinMaster where a Role is included in the Scenario but has Auto Finish Role set to True. The role is strictly there for a later role to reject against if they need changes made to their data.

The Role still receives a notification that their role is ready for processing even though it is set to Auto Finish. This was causing some confusion. In order to accommodate this we created our own customized view of webRequestRole_WorkflowMessageForAvailableRoleSel to exclude ttScenarioRole AutoFinishRole = 0 (we are using our own custom workflow anyway). 

CREATE VIEW [dbo].[webRequestRole_WorkflowMessageForAvailableRoleCustomSel]

AS

SELECT DGE.dbo.webRequestRole_WorkflowMessageForAvailableRoleSel.RequestID, DGE.dbo.webRequestRole_WorkflowMessageForAvailableRoleSel.RoleID,

DGE.dbo.webRequestRole_WorkflowMessageForAvailableRoleSel.UserID, DGE.dbo.webRequestRole_WorkflowMessageForAvailableRoleSel.WorkflowedBy,

DGE.dbo.webRequestRole_WorkflowMessageForAvailableRoleSel.WorkflowedOn

FROM DGE.dbo.webRequestRole_WorkflowMessageForAvailableRoleSel INNER JOIN

dbo.ttRequest ON DGE.dbo.webRequestRole_WorkflowMessageForAvailableRoleSel.RequestID = dbo.ttRequest.RequestID INNER JOIN

dbo.ttScenarioRole ON dbo.ttRequest.ScenarioID = dbo.ttScenarioRole.ScenarioID AND DGE.dbo.webRequestRole_WorkflowMessageForAvailableRoleSel.RoleID = dbo.ttScenarioRole.RoleID

WHERE (dbo.ttScenarioRole.AutoFinishRole = 0)