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
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
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.
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.