# Automation designer **URL:** \ **Category:** Toad for Oracle & DevOps Toolkit\ **Created:** [October 21, 2022, 7:25pm UTC](https://forums.toadworld.com/t/automation-designer/56271 "2022-10-21T19:25:26Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![Jim\_Sniatecki](https://avatars.discourse-cdn.com/v4/letter/j/dc4da7/32.png) [@Jim\_Sniatecki](https://forums.toadworld.com/u/Jim_Sniatecki)\ **Post date:** [October 21, 2022, 7:25pm UTC](https://forums.toadworld.com/t/automation-designer/56271/1 "2022-10-21T19:25:26Z")
For the SQL Iterator feature how do you create a child action in the form of %Query Iterator1. to reference the query result? ---
**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\ **Post date:** [October 21, 2022, 7:28pm UTC](https://forums.toadworld.com/t/automation-designer/56271/2 "2022-10-21T19:28:35Z")
Hi Jim, See my reply here. At the bottom is a link to my dropbox folder that has some docs that should help. > [@Toad for Oracle Query Iterator](https://forums.toadworld.com/t/toad-for-oracle-query-iterator/55103): > > I'm trying to get a very basic loop working to insert some records into a table. I've worked with Toad Data Point for a number of years, but this doesn't appear to use the colon or pound sign variables the way TDP does. My problem is this. In my query iterator I have a simple select to return a list of values. Then I have a child action that is properly nested under it. In that I have an insert from select statement and I need to pass the output of the list to the insert as an input paramet… Here's a link to the folder: > **[Toad](https://www.dropbox.com/sh/122c8wmmfrd2vgn/AAAsO1aKKSyIyOKlpGGEyxQHa?dl=0)** > > Shared with Dropbox The doc: "Automation Designer: Choose which script to run based on a variable" uses a query iterator with a script. Let me know if you still have questions. ---
**Author:** ![Jim\_Sniatecki](https://avatars.discourse-cdn.com/v4/letter/j/dc4da7/32.png) [@Jim\_Sniatecki](https://forums.toadworld.com/u/Jim_Sniatecki)\ **Post date:** [October 21, 2022, 7:48pm UTC](https://forums.toadworld.com/t/automation-designer/56271/3 "2022-10-21T19:48:26Z")
That is not what I'm looking for. When I run the Query Iterator it has in the Properties screen a message line that reads: Child Actions may use variables in the form of %Query Iterator 1.% to reference the query result. It does not explain how to do this with an example. ---
**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\ **Post date:** [October 21, 2022, 7:51pm UTC](https://forums.toadworld.com/t/automation-designer/56271/4 "2022-10-21T19:51:01Z")
What would you like to do with the result? I am asking so I can give you a relevant example. ---
**Author:** ![Jim\_Sniatecki](https://avatars.discourse-cdn.com/v4/letter/j/dc4da7/32.png) [@Jim\_Sniatecki](https://forums.toadworld.com/u/Jim_Sniatecki)\ **Post date:** [October 21, 2022, 7:54pm UTC](https://forums.toadworld.com/t/automation-designer/56271/5 "2022-10-21T19:54:23Z")
Nevermind, I just found your correct document which I believe answers my question. Sorry I read the wrong doc before. Thank you for the download, I believe it is exactly what I'm looking for. I wish Quest had some good tutorials on the Automation Designer as it is really a valuable tool. ---
**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\ **Post date:** [October 21, 2022, 7:56pm UTC](https://forums.toadworld.com/t/automation-designer/56271/6 "2022-10-21T19:56:08Z")
Thanks for the feedback. I've been thinking that I should add some examples with iterators in the "samples" folder in automation designer.