I have definied two queries...
...one to select a controller
and a second
...to select igroups based on the selected controller
in Workflow/Setup/User Inputs
Query 1 (Single select) is:
SELECT array.name FROM storage.array
Query 2 (Multi select) is:
select
igroup.name
FROM
storage.igroup,
storage.array
WHERE
igroup.array_id=array.id
AND array.name like '${ArrayName}%'
AND igroup.os_type = 'vmware'
Clicking the test button the queries work as expected. When I am in the workflow preview mode then first query 2 shows the result of the first controller of query 1 as expected. When I select another controller in the query 1 box AND this controller has no matching igroups then wfa will hang. This happens only when the content of the multiselect changes from "non empty" to "empty".
What is wrong?
When I append "UNION SELECT '[no more igroups]' to query 2, then it will never hang.
This will work:
select
igroup.name
FROM
storage.igroup,
storage.array
WHERE
igroup.array_id=array.id
AND array.name like '${ArrayName}%'
AND igroup.os_type = 'vmware'
union
SELECT
'[no more igroups]'
WFA version is 2.2.0.2.6
