WF has to be start if any insertionDeletionUpdation of the record in SQL table

  • 15 February 2016
  • 1 reply
  • 0 views

Badge +2

Hi Experts,

 

I have a requirement that, The Workflow has to be start if a record has been Created or Updated or Deleted in the SQL table.

 

Can anyone give some idea, How exactly I can achieve this?

 

Regards

SK


1 reply

Userlevel 1
Badge +8

Hi SK1971

 

The only way I can think to do this is to create a  custom assembly that uses the K2 API to start a workflow, register this as a CLR in SQL and call this from a trigger on the SQL table. See http://www.c-sharpcorner.com/UploadFile/37db1d/create-your-first-clr-trigger-in-sql-server-2008-using-C-Sharp/

 

Workflows can be started from SmartObject methods (e.g. a Create method that creates a record in SQL) but you must of course use the SmartObject to create/update/delete your data to use this.

Reply