Using dictionary process data in action “start a subworkflow (SQL)”

0

Hi,

You should create a query that will generate as many items as you want to get subworkflows.
In addition, you can return users or groups in one of the columns of the query and transfer this data to the attribute in the registered flow, then set the action of assigning the task to this attribute there.

if the dictionary values come specifically from 1 element, you can use the dictionary's guid to fetch the values

select * from wfelements where WFD_Guid = 'b94a269e-b683-4ce8-be3b-fcf2f0ad2792' (guid of your dictionary. provided dictionaries are migrated between environments, you are sure that guid refers to the same element)

if the data comes from multiple dictionary cards use the id of the form type to get the values from the dictionary
e.g. select * from wfelements where WFD_dtypeid = 1597

use a CROSS JOIN query to create multiple items

Regards

Hi,
Could you provide more details about the processes and dictionary?
Is there any connection between the first flow and the dictionary?
In order to retrieve only the necessary information for each instance from the dictionary, you will need to add some conditions to extract what is required.

Thank,
Raluca

Karel, Raluca

Thank you for you hints. While trying to provide more details / describe more clearly the problem, I did some progress and SQL query is returning column with users. Unfortunately I still missing something, as I have error behavior. I hope picture is explanatory enough. Regards, Ondrej

Hi,
Please show how you have configured the basic and advanced tab. And test this sql query from the Data tab, and paste what result you get.

Hi Ondrej,



Thanks for the details. I will also need you to do some tests.
Firstly, you should change the SQL condition/filter and replace the "Write User or Group Nr. to be selected from DIC" from OBJECT to the VALUE tab (the equality only needs the current value).
Copy-paste the new SQL and test it. Best to do it in a business rule or an action like "Change value of single field". If you have a saved instance then you can also test it in the expression editor.
After confirming that it works and returns the desired values, use it in the "Start subworkflow" action and test it again.
Will come with other suggestions after.


Regards,
Raluca

Hi Karol, see the details in pic. Thank you Ondrej

Hi,
You can try choose a " form type" in the subworkflow action in Basic tab.
Do you have many form type? (one for each process).

Thanks,
Raluca

Hi Raluca, I can not find the form fields from Dictionary process in Values (And now, It even makes sense to me). This was one of the reasons, why I asked community. Therefore I can not elaborate single subworkflow, as I need a values for it. Thank you Ondrej

Hi,

Delete the SWF from the search bar and try looking for the field again.

Regards,
Raluca

Raluca, Karol,

It is working now, the problem was as you pointed in Form type and object instead of value. Thank you very much, Regards Ondrej