Hello,
I have a "wait for sub-workflow" step that use advance configuration.
In my case the parent instance has a number or related "kids" (instances) and only one unrelated, but all from same workflow.
In order to indenfity the unrelated "kid", the parent has the wfd_id saved in a field.
The SQL that I use in the advance settings for the "wait for sub-workflow" verify if the total number of "kids" (related or unrelated) is equal to the total number of "kids" that are in a specific step (it is a finish positive type step).
When the numbers are equal then the parent instance should move to next step, otherwise it will move on a path that leads to same step (a save path).
In my case there are no steps of type "finish (negative)" only "finish (positive)".
All is good except the parent is not moving to the next step when all "kids" are moved to a finished (positive) step.
When a related "kid" moves to a "finish" step, it triggers the parent to go on "save" path, but the unrelated "kid" does not.
Is it possible to make a "wait for sub-workflow" step work correctly when checking for related and unrelated sub-workflows ?
Thank you,
Regards