How to use trigger in K2 Blackpearl

Just to clarify.  What sort of trigger are you referring to?  Do you have a scenario for this?

One way would be is to use a Async Server Event.  Do the external call to your database to pass in the server event instance ID.

 Write a .NET trigger on the table to do a OpenServerItem call back to the process to update the data and call the Finish method.  Here's a sample taken from the K2 SDK.

       //Open the Connection
      connection.Open(serverName);

      //Get the ServerItem
      serverItem = connection.OpenServerItem(serialNumber);

      //Update Process Data or XML Field
      serverItem.ProcessInstance.DataFields["Result"].Value = "Complete";
      serverItem.ProcessInstance.XmlFields["Date"].Value = System.DateTime.Now.ToString();
      serverItem.ProcessInstance.XmlFields["Time"].Value = System.DateTime.Now.Hour.ToString() + ":" + System.DateTime.Now.Minute.ToString();

      //Update Activity Data or XML Field
      serverItem.ActivityInstanceDestination.DataFields["Result"].Value = "Complete";
      serverItem.ActivityInstanceDestination.XmlFields["Date"].Value = System.DateTime.Now.ToString();
      serverItem.ActivityInstanceDestination.XmlFields["Time"].Value = System.DateTime.Now.Hour.ToString() + ":" + System.DateTime.Now.Minute.ToString();

      //Complete the server event.

      serverItem.Finish();

      //Close the Connection

      connection.Close();

 

Triggering .NET code from a SQL trigger isn't a K2 specific thing.  There's a lot of articles on the web on this.  Here's one for reference.

http://www.15seconds.com/Issue/041006.htm

Hi Johny

Now I write .Net Trigger and hook to database finished. But I can't use object K2 such as:sourcode.HostClientApi,Sourcode.WorkFlow.Management to open method OpenServerItem in my .Net Trigger code. Because when I add them and I try to hook to database. I have error sound like "Sourceode.HostClientAPI not pure .Net Assembly"

My Sample Code:

Imports

System.Data

Imports

System.Data.SqlClient

Imports

Microsoft.SqlServer.Server

Partial

Public Class MyFirstClrTrigger

'<Microsoft.SqlServer.Server.SqlTrigger("FOR INSERT", "checkUserRole", "UserTable")>

<Microsoft.SqlServer.Server.SqlTrigger(Event:=

"FOR INSERT", Name:="checkUserRole", target:="UserTable")> _

Public Shared Sub checkUserRole()

Dim triggContext As SqlTriggerContext = SqlContext.TriggerContext()

Dim userType As String = String.Empty

If triggContext.TriggerAction = TriggerAction.Insert Then

Using connection As New SqlConnection("context connection=true")

connection.Open()

Dim sqlComm As New SqlCommand

Dim sqlPipe As SqlPipe = SqlContext.Pipe()

sqlComm.Connection = connection

sqlComm.CommandText =

"SELECT Type from INSERTED"

userType = sqlComm.ExecuteScalar.ToString()

If userType.ToUpper = "ADMIN" Then

sqlPipe.Send(

"Hello !!! You have the Admin role.")

sqlPipe.Send(

"We can use e-mail codes here to inform.")

Else

End If

End Using

End If

End Sub

End

Class

 

  Question

      - How to do that (Open method OpenServerItem in my .Net Trigger)

      - You talk about Async Server Event. You mean what even IPC Event or Server Event

      -  How to I can use external call

 thanks

Hi Ton,

 I verified this behavior and I think it is because of a limitation in SQL in dealing with mixed assemblies.  See this thread on the microsoft forum (http://forums.microsoft.com/msdn/ShowPost.aspx?PostID=1132820&SiteID=1).

One way to get around this is to wrap the K2 calls into a web service and then create a .NET class stub which calls this.  You should at this point be able to register the class stub as it is considered a pure assembly.

The other method I saw from some other posters was that you could try to expose the assembly using a COM wrapper and then invoke it from there.

Not too nice but it's still an option.

Hi

I also need to do this but am using K2 Blackpoint, this is very simple in SPD & Nintex as they have a 'Wait Until' option that you can pause a worklow until a certain field = a certain value, I cant believe you cant do this easily in K2 like you can SPD & Nintex, am I missing something ??

 

Cheers,

Hi Johnny,

Thanks for the reply above I can see the problems with using the Nintex way in a large enterprise environment.

Im still not sure though how I can do this in Blackpoint, Ive seen a post, I think from you suggesting a way you could achieve it in Blackpearlm but is it possible to achieve this in Blackpoint ?

Thanks

Professional suggestions

Convert DVD to iPhone

I assume you are referring to the callback using the asynchronous server event.

Nope, I don't think it is possible to do that in blackpoint due to the missing server event.  I would say that this is a blackpearl feature only.

So if this is a key feature that is needed, I would probably want to look at blackpearl instead of blackpoint.  The API and code capabilities in blackpearl introduce more flexibility and capability in your workflow designs.