Change Workflow Queue Values Using SQL

Use this article to change workflow queue values in Microsoft SQL Server Management Studio.

 

1. Find the document in Synergize Explorer.

2. Right-click on the document and select Properties.

3. Click Show Filed Info.

4. In the resulting Field Values window, find the In_DocID field value.

   

5. Launch Microsoft SQL Server Management Studio.

6. In the dbo.Workflow table, find the WorkFlowID$ value.

   

7. Enter the following command to update the main table:

   update dbo.Main set WorkFlowID$ = ‘workflow #’ where In_DocID = ‘Syn#’

   Example:

   update dbo.Main set WorkflowID$ = '11' where In_DocID = 'Syn22'