# Automation Designer: Query Iterator using variable?

**URL:** <https://forums.toadworld.com/t/automation-designer-query-iterator-using-variable/40709>\
**Category:** Toad for Oracle & DevOps Toolkit\
**Created:** [March 14, 2018, 9:14am UTC](https://forums.toadworld.com/t/automation-designer-query-iterator-using-variable/40709 "2018-03-14T09:14:55Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![jeff.butler\_27568](https://avatars.discourse-cdn.com/v4/letter/j/47e85d/32.png) [@jeff.butler\_27568](https://forums.toadworld.com/u/jeff.butler_27568)\
**Post date:** [March 14, 2018, 9:14am UTC](https://forums.toadworld.com/t/automation-designer-query-iterator-using-variable/40709/1 "2018-03-14T09:14:55Z")

</div>

Hello,

I am wondering if it’s possible to use a variable inside the query of an SQL Query Iterator in the Automation Designer?

Example:

![SQLQueryIterator.jpeg](https://global.discourse-cdn.com/quest/original/2X/c/c144d735ccacb02986ceb048aed1c4963a7655be.jpeg)

The idea behind this is to then use a Variable Prompt to set the value of the variable used in the SQL Query Iterator’s WHERE CLAUSE at runtime.

---

<div class="post-metadata">

**Author:** ![amit\_naidu](https://avatars.discourse-cdn.com/v4/letter/a/7ea924/32.png) [@amit\_naidu](https://forums.toadworld.com/u/amit_naidu)\
**Post date:** [March 14, 2018, 9:23am UTC](https://forums.toadworld.com/t/automation-designer-query-iterator-using-variable/40709/2 "2018-03-14T09:23:03Z")

</div>

Why not put the query iterator inside another query iterator? Or inside a list iterator.

---

<div class="post-metadata">

**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:** [March 14, 2018, 9:23am UTC](https://forums.toadworld.com/t/automation-designer-query-iterator-using-variable/40709/3 "2018-03-14T09:23:44Z")

</div>

Sorry this isn’t possible right now but I’ll see if I can add that for you.

I guess this is just an example, but you might want to look at some of the other iterators…you might be able to do what you want with file or list iterators.