Workflow Engine: Trigger condition to start a workflow-1517393755

Dear All, 

We want to create a approval workflow which should start when an index entry is modified. In our case, we have a field 'Status', when this field has a defined value, the workflow should start. 

This 'value update' is driven by the customer ERP, which update directly the value on the Docuware SQL database. (dwdata database).

It's seems that updating directly values within SQL is not supported and the Workflow is not started. Only if an index is changed within the web client or with the Docuware API. 

We don't want to use the Docuware API which is difficult in our case.( Customer's programming is not .NET).

Any ideas to find a workaround? 

Kind Regards

Workflows are triggered by Content Server. If Content Server does not perform the update then it will never be detected. You must ensure that DocuWare performs the update. You could have your external process update a different field, and have Autoindex run and look for a specific value in the other field, and when found set the status to the desired value. The workflows will then trigger.

Phil Robson
Senior Director Support Americas

Benoit,

we use a custom stand alone Docuware API .NET 'rewrite' program that is activated by a SQL trigger (IF UPDATE of STATUS field). This solution does not require any changes to existing ERP processes.

Dear Josef,

Do you have more technical details on your solution? If I understand, we set a trigger on a sql field, then, the SQL trigger is updating a field with the Docuware api? 

Kind Regards

Benoit,

We've develoed a standalone Docuware API based program which re-writes specified index fields for specified Docuware documents. This program is called by abovementioned SQL trigger with required parameters specified (DOCID, Field)