HI,
I have small problem.
I have main work flow where process starts few subworks flows,
and it "park" in "wait for all subwork flows" step.
In basic setup I have only 3 options:
No subworkflows,
All subworkflows finished positive,
Any subworkflow finished negative.
In my scenario I will have very often negative steps
Solution 1
option to solve all path put to positive step and use wait for all positive and forget about problem
Solution 2
set sql query where it will wait for all subflows doesn't matter positive / negative and if all will finish then will go by 1 path common for all results.
I did sql QUERY:
[code="sql"]
SELECT
e.WFD_ID as 'ID elementu',
e.WFD_STPID as 'ID kroku',
s.STP_Name as 'Nazwa kroku',
e.WFD_WFDID as 'ID rodzica',
CONVERT(date, e.WFD_TSInsert) as 'data utworzenia',
CONVERT(date, e.WFD_TSUpdate) as 'data aktualizacji',
e.WFD_IsFinish as '(Boolen) Czy ukończył bieg',
e.WFD_IsDeleted as '(Boolen) czy skasowany',
CONVERT(date, e.WFD_FinishDate) as 'Data ukończenia', -- zadania
e.WFD_Signature as 'Sygnatura zadania'
FROM
WFElements e
LEFT JOIN
WFSteps s ON e.WFD_STPID = s.STP_ID
WHERE
(e.WFD_STPID <> '{ST:370}' OR e.WFD_STPID <> '{ST:371}' OR e.WFD_STPID <> '{ST:372}')
AND e.WFD_WFDID = '{WFD_ID}'
AND e.WFD_IsFinish = 0
[/code]
I have results ... but error - no path .. how to with that or other query set path in advance settings ... webcon help is not mention about that scenario ... or how to configure that in proper way.