Veröffentlicht Wed, 31 Jan 2018 09:15:55 GMT von Benoit Vassart ASC

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




Veröffentlicht Wed, 31 Jan 2018 12:34:52 GMT von Phil Robson DocuWare Corporation Senior Director Professional Services, Americas

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

Veröffentlicht Wed, 31 Jan 2018 12:42:45 GMT von Josef Zayats


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.


Veröffentlicht Wed, 31 Jan 2018 12:59:13 GMT von Benoit Vassart ASC

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

Veröffentlicht Wed, 31 Jan 2018 13:07:20 GMT von Josef Zayats


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)

Sie müssen angemeldet sein um Beiträge in den Foren zu erstellen.