Redirect Worklist Item

You don't have to use the custom worklist broker. You can use the standard out of the box API calls.

Using the following signiture

bool WorkflowManagementServer.RedirectWorklistItem(string fromUserName,string toUserName,int procInstID,int actInstDestID,int worklistID)

Please see below for a code example:

            WorkflowManagementServer wfManServ = new WorkflowManagementServer();

            try

            {

                // Create a new connection

                wfManServ.CreateConnection();

                // Open the connection

                wfManServ.Connection.Open("Integrated=True;IsPrimaryLogin=True;Authenticate=True;EncryptedPassword=False;Host=localhost;Port=5555");

                foreach (SourceCode.Workflow.Management.WorklistItem worklistItem in wfManServ.GetWorklistItems("", "", "", "", "", "", ""))

                {

                    if(worklistItem .ProcInstID.ToString() == txtProcessInstanceID.Text)

                        wfManServ.RedirectWorklistItem("denallixCarl", "denallixBob", worklistItem.ProcInstID, worklistItem.ActInstDestID, worklistItem.ID);

                  }

            }

            finally

            {

                if (wfManServ != null)

                {

                    if (wfManServ.Connection.IsConnected)

                        wfManServ.Connection.Close();

                    wfManServ.Connection.Dispose();

                }

                wfManServ = null;

            }

The way that I was able to get the slot ID was to create a stored procedure in the K2 DB as per below:

->Once the stored procedure is created then create a SmartObject on this Stored procedure

-> Create a stored procedure on [Server].[kWorklistItemRedirect] which needs a slotID and who to direct to

-> Once these two SmartObjects are created you should be able to use the Smart Objects to redirect users.

USE [K2]

GO

/****** Object:  StoredProcedure [Server].[kWorklistItemItems]    Script Date: 2/7/2014 7:01:34 AM ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

/*

*/

CREATE PROCEDURE [Server].[kWorklistItemItems]

AS BEGIN

SET NOCOUNT ON;

/*

Status:

0 = Available

1 = Open

2 = Allocated

Return:

1 = Worklist item not found

2 = Item not open

3 = Success

*/

SELECT

[WS].[ProcInstID],

[WS].[ActInstID],

[WS].[Status],

CONVERT(INT, ISNULL([WS].[SlotFieldID], 0)) AS SlotID,

[EV].[Name],

.Type

FROM

[Server].[WorklistSlot] AS [WS] WITH (NOLOCK)

INNER JOIN [Server].[WorklistHeader] AS [WH] WITH (NOLOCK)

ON [WH].[ProcInstID] = [WS].[ProcInstID]

AND [WH].[ID] = [WS].[HeaderID]

INNER JOIN [Server].[Act] AS WITH (NOLOCK)

ON .[ID] = [WH].[ActID]

INNER JOIN [Server].[Event] AS [EV] WITH (NOLOCK)

ON [EV].[ID] = [WH].[EventID]

END

Please keep in mind this is my own opinion and is not the only way.

I am also not suggesting that this is a best practice.

The statements and opinions made in my postings are my own, and do not reflect the opinions of SourceCode Technology Holdings, Inc. or its subsidiaries. All information is provided as is with no warranties, express or implied, and grants no rights or licenses.

Ah.  OK. 

So with these two stored procs(one already in K2), I'll be able to redirect a worklist item to someone and it will be out of everyone's worklist items list, which it was there originally because it was assigned to a role which they were in. 

Thanks so much!

Thanh