Update related workflow instance

0

Hi all!

We have to update some columns in a workflow dependent on other columns from the same workflow item,
e.g. WFD_AttDecimal1 = WFD_AttDecimal2 * WFD_AttDecimal3.

Sounds trivial, but it isn't, especially in a SaaS system, where 'Run an SQL procedure' is missing.

Another approach for us was to use 'Update related workflow instance' action, but this approach obviously leads to nowhere (maybe this is a bug or document context is missing here).

We tried this in a minimal example, just using current instance id as value in action (see screenshot attached).

This leads to

ID: {WFD_ID}

being replaced in field 'Anmerkungen', which is obviously not what we want ;-)

Remark: We tried to use this in a cyclical action, maybe this is the wrong place here ...


Maybe we are missing something pretty essential here.


Any other ideas how to update workflow elements in SaaS PROD environment?


Thanks a lot!

Any other ideas