Hello all,
First of all I would like to thank you for taking time reading my post!
I'm working on a current process where I need to trigger many subworkflows to request information for the main one. Because the main one will keep being edited after the subworkflows are launched, I've decided to set them as parallel. They will be started through a item list and after one person for the task is selected in that item list.
This is bringing me many issues and challenges.
First of all, I need to use 2 actions in the subworkfows to fill in 2 different Item List but my query is not bringing anything because I only get examples for the cases where we have parent and child
select
{DCNCOL:466} as {DCNCOL:462},
{DCNCOL:467} as {DCNCOL:463},
{DCNCOL:468} as {DCNCOL:464},
{DCNCOL:469} as {DCNCOL:465}
from WFElements
join WFElementDetails
on WFD_ID=DET_WFDID
where DET_WFDID = {WFCONCOL:3295} (form field in the subworkflow where I save the ID from the parent)
and DET_WFCONID ={WFCON:3192}
Second issue is that, even trying to save the ID from each subworkflow in the item list
select {WFCONCOL:3301} as DET_ID, WFD_ID as {DCNCOL:493} (column in the item list)
from wfelements
where {WFCONCOL:3295} = {WFD_ID} (form field saving the Parent ID)
and WFD_Dtypeid = {DT:120}
and isnull({WFCONCOL:3301}, '') <> ''
Third issue is that, if the parent gets cancelled, I need to move all the subworkflow for the Cancel step. For this I was trying to use the action Move Workflow but in the Data tab, probably something is not correct as I'm using
select {WFCONCOL:3295} as WFD_ID (parent ID in the parallel workflow)
I thought about changing to Child instead of Parallel but I'm not sure if it would fix my issues.
Does anyone faced something similar'
Thank you!