Thanks for the detailed explanation.
Q1: Preview the workflow once is the best way to achieve to this.
Q2: We tried to build a sample workflow to show the same using a Playground DB.
It will give an idea how to do the same. The trick lies in the dependent user input's SQL query.
In the example,
If the vol name ends with 1,3 then in the dependent user input will show Vol1,Vol3.
If the vol name ends with 0,2 then in the dependent user input will show Vol,Vol2.
Let us know if this helps.
Having problems attaching the backup.
So copy pasting the queries here: UserInput1:
SELECT
namevalue.Name as 'Name'
FROM
Playground.namevalue
UserInput 2:
SELECT
namevalue.name,
CAST(SUBSTRING(namevalue.name,
4) AS UNSIGNED) AS id
FROM
playground.namevalue
WHERE
CAST(SUBSTRING(namevalue.name,4) AS UNSIGNED) % 2 = (
SELECT
DISTINCT CAST(SUBSTRING(namevalue.name,
4) AS UNSIGNED) % 2
FROM
playground.namevalue
WHERE
namevalue.name = '${Name}'
)
User Input 2 is dependent on User Input 1.
A table "namevalue" is created in the Playground DB,
with one column "Name", having entries, Vol0,Vol1,Vol2,Vol3.
Regards
Abhi