Executing a business process by change directly from db

Hello, 

 

I am wondering if a business process is started by a trigger, could that trigger also happen on the database side? (Example SQL script adjusting value in db so that a business process should be triggered).

 

This is the process in question:

 One the boolean flag is "1" process is suppose to run. 

 

If this is not how business processes are meant to run, how else could we trigger this business process via a database value changing? Would we have to use the DBExecutor, or other c# code on the section itself?

 

Thank you. 

Like 0

Like

1 comments

Dear Philip,

The business process won't be triggered on update/insert made directly into the database either from script task or directly via database system query.

The best option would be updating/inserting via script task within another business process where you should write the query that alters the field value with the help of EntitySchemaQuery (the manual is available in the Academy)

Oleh

Show all comments