Forum Discussion

pavel-wbr's avatar
pavel-wbr
New Contributor II
7 months ago

change Workflow Status from data management

Hi all,  I use the dashboard to trigger data import from external database. After successfull import I want to make the workflow step (type Workspace) complete by calling SetWorkflowStatus. Stran...
Extensibility
pavel-wbr's avatar
pavel-wbr
New Contributor II

Hi Aymar, 

here is the code I use:

	Public Function CompleteWorkflow(ByVal si As SessionInfo, ByVal wfClusterPk As WorkflowUnitClusterPk) As XFSelectionChangedTaskResult
		Try				
			Dim selectionChangedTaskResult As New XFSelectionChangedTaskResult()
		
			'Get the workflow Info object, retrieve and the Workspace Workflow task and set its status ti COMPLETED	
			Dim wfStatus As WorkflowInfo = BRApi.Workflow.Status.GetWorkflowStatus(si, wfClusterPk, True)
			Dim wfTask As TaskInfo =  wfStatus.GetTask(New Guid(SharedConstants.WorkflowKeys.Tasks.Workspace))
			If Not wfTask Is Nothing Then

				
				
				
				If (debug) Then ' DEBUG - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
					BRApi.ErrorLog.LogMessage(si, "#DEBUG: IDB_GeneralHelper / CompleteWorkflow: ", $"task: {wfTask.Description} || status: {wfTask.Status}"
					)
				End If ' - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
				
				If wfTask.Status <> WorkflowStatusTypes.Completed Then
					'Update the workspace workflow to COMPLETED
					Dim wfRegClusterDesc As String = BRApi.Workflow.General.GetWorkflowUnitClusterPkDescription(si, wfClusterPk)
					
					BRApi.Workflow.Status.SetWorkflowStatus(si, wfClusterPk, StepClassificationTypes.Workspace, WorkflowStatusTypes.Completed, StringHelper.FormatMessage(Me.m_MsgWorkflowCompleted, wfRegClusterDesc), "", Me.m_MsgWorkflowCompletedReasonButton, Guid.Empty)							

					If (debug) Then ' DEBUG - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
						BRApi.ErrorLog.LogMessage(si, "#DEBUG: IDB_GeneralHelper / CompleteWorkflow: ", "step completed!"
						)
					End If ' - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
					
				End If
			End If

			selectionChangedTaskResult.IsOK = True							
			selectionChangedTaskResult.ShowMessageBox = False
			selectionChangedTaskResult.WorkflowWasChangedByBusinessRule = True

			Return selectionChangedTaskResult							
						
		Catch ex As Exception
			Throw ErrorHandler.LogWrite(si, New XFException(si, ex))
		End Try			
	End Function

I am sure is processed it creates a debug record in Error log.

I use no args here.

It should work, I have no idea why it doesn't. 

Thanks for help!

Pavel

FredLucas's avatar
FredLucas
Contributor III
7 months ago

Hi pavel-wbr,

Have you tried refreshing the application or moving to a different workflow and get back to the one you expected to have been updated to understand if this could be due to the lack of the refresh?

Only dashboard extender rules are able to return a XFSelectionChangedTaskResult object which is the one that contains the info required for OS to refresh the workspace. If you trigger a DataManagement Sequence that triggers a dashboard extender rule your Workspace won't get refreshed automatically and you'll have to manually do it to see the outcome.

If you are looking for a way to trigger have the Workspace updated and also trigger other Data Management steps, you could have the dashboard extender launching the data management sequence for you. You might find this post interesting: https://community.onestreamsoftware.com/t5/Rules/Running-DM-package-from-the-BR-and-completing-the-workflow-step/m-p/34828#M3568