I'm using Toad Data Point 188.8.131.52, and MySQL 5.7
I'm trying to use Loop Dataset to pull a list of values to iterate over to perform queries with in MySQL. Following the tutorial on youtube as an example, I have a loop data set with a driving query that returns 3 rows with 2 columns. The column of interest is 'flow_name' and I've named the dataset variable 'OpenFlows'.
In my child action I have a Select to File, with a simple query:
Select * from table WHERE flow_name = :OpenFlows.flow_name
I've also tried @OpenFlows.flow_name and #OpenFlows.flow_name#
None are working, it's as if the variable value isnt being passed. I'm getting 0 rows exported. Is there some other way we're meant to supply variables to a query?